Google Spreadsheets is a Web-based application that allows users to create, update, and modify spreadsheets and share the data live online.
You can open it in your browser window like a regular webpage, but you have all the functionality of a full spreadsheet application!
Users can easily embed Google Docs spreadsheets, documents, forms, and presentations into WordPress by copying and pasting the embed code.
Some of the content creators use Google Spreadsheets to explain marketing strategies. It was a brilliant idea/tool for team collaboration.How to Embed Google Sheets to WordPress Click To Tweet
DISCLOSURE: This post may contain affiliate links, meaning I get a small commission if you decide to make a purchase through my links, at no additional cost to you. Please read my full disclaimer here for more info.
In this article, you’ll learn a few steps to connect WordPress to Google Sheets using Ninja Forms Zapier add-on.How to Embed Google Sheets to WordPress Click To Tweet
First, what is Ninja Forms?
Ninja Forms is a drag and drop WordPress Form Builder. You can create PayPal payment forms, file upload forms, ActiveCampaign, and more super easily.
Risk-Free 14 Day Money Back Guarantee always!
They have 3 pricing plans:
- Personal $99
- Professional $199
- Agency $499
How to Connect Google Sheets with Your WordPress Forms
In just a few steps, you can integrate your WordPress forms with Google Sheets. Sending data over is automated and immediate. All you have to do is establish the link once and the data will flow with every submission.
Let’s get started!
#1 Get started with Zapier
Ninja Forms add-ons are just like regular WordPress plugins. Once you purchase the plan, you can follow the steps below!
- Login to your WordPress Dashboard and go to Plugins > Add New.
- Search for Ninja Forms in the box provided, and click “Install Now.”
- After the installation finishes, click “Activate” and you’re ready to work with Ninja Forms.
Make sure your license keys are entered in your WordPress Dashboard under Ninja Forms > Settings > Licenses.
By doing this, you’ll connect your WordPress and Ninja Forms account.
Next, create an account with Zapier. (Free plan is OK) After you’ve created the account with Zapier, move on to #2 step.
#2 Create that Zap!
Log into your Zapier account and click “Make a Zap” in the left toolbar.
#3 Setup your Zap to start integrating WordPress form with Google Sheets
Once you’re in the zap setup page, just search Ninja Forms in the App & Event search bar:
Choose “New Form Submission” as the Trigger Event and click Continue. You’ll now be shown a webhook:
Copy it, then go back to WordPress and into your form (or create one that meets your specifications). Go to the Emails & Actions tab, add a Zapier action, and paste the webhook into the Zapier Webhook field:
Now Publish (save) the form, Preview the form, enter test data into each field (do not skip this step!), and Submit the form preview. Now head back to Zapier, and click Continue.
After this step, you’ll have a few options to proceed. Test & Continue to make sure the Zap works well. If anything goes wrong, Zapier will give you troubleshooting steps.
#4 It’s now time to connect WordPress to Google Sheets
Same as before, search and select Google Sheets as the Action App in Zapier:
You’ll then be asked to select the Google account you want to connect to Zapier.
Next, select the specific Spreadsheet and Worksheet (the Google Sheet itself you want to send data into, and the worksheet/page within that document that you’ll be populating with info).
Now you should see the headers for that Worksheet appear:
If you don’t, your heading formatting likely differs from what Zapier requires. You can fix it using their documentation.
Map the fields of your form to the sheet headers you want to populate.
You’ll see that Zapier is using the field data from when you submitted the form preview above to learn which field is which. When you continue, this test data will be sent through to your spreadsheet to confirm the connection!
Zapier supports over a thousand services, and there are dozens that will directly connect to Ninja Forms. If you want to know more about Ninja Forms, please visit their website.