How To Connect WordPress To Google Sheets: 3 Easy Steps
Disclosure: This post contains an affiliate link to an add-on for Ninja Forms to connect your WordPress website to Google Sheets. If you purchase this add-on through this link, I’ll receive a small commish at no cost to you.
In any business, whether you’re a virtual assistant, an author or a solopreneur, you’re probably getting forms submission from customers. They may be asking about an upcoming product launch and want to be placed on a waiting list. Or your taking sign-ups for a webinar or online course you created.
Whatever the reason a customer is submitting a form, you have to keep track of that data and organized.
We’re all looking for that one thing to help us work smarter not harder.
In this post, I’m going to show you that in just 3 simple steps, you can integrate your WordPress forms to automatically send data to Google Sheets. All you have to do is establish the link once and the data will flow with every submission!
The following tutorial is going to walk you through the set up. Before getting started, make sure you have access to:
Here we go…
Zapier allows you to create workflows to automate repetitive tasks. It takes working smarter to the next level!
They have over 2,000 apps but for this tutorial, you’re going to use The Ninja Forms Zapier add-on. This is the tool that will establish a link between your WordPress website and Google Sheets.
First, install and activate the Ninja Forms Zapier add-on on your website.
Next, create a free account with Zapier. Now you’re ready to get started!
When you create a workflow in Zapier, it’s referred to as a Zap. Creating a Zap super simple. Just log into your Zapier account and click on “Make a Zap” in the left toolbar.
Once you’re in the zap setup page, type in Ninja Forms in the App & Event search bar.
Choose “New Form Submission” as the Trigger Event and click Continue. A Ninja Forms webhook URL will be displayed.
Copy the URL then go back to WordPress and pasted into the form you want to use (or create one that meets your specifications).
Now go to the Emails & Actions tab. Add a Zapier action, and paste the webhook URL into the Zapier Webhook field on the right.
Click Publish to save the form. Preview the form and enter test data into each field (do not skip this step!). Now submit the form preview.
Head back to Zapier and click Continue.
After this step, you’ll have a few options to proceed. We recommend to Test & Continue to make sure the Zap works well. If anything goes wrong, Zapier will give you troubleshooting steps.
If it’s good to go, the next step is to connect WordPress to Google Sheets. Same as before, search and select Google Sheets as the Action App in Zapier:
Select ‘Create Spreadsheet Row in Google Sheets’ as the Action Event. Then sign in to 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).
You should see the headers for that Worksheet appear like this:
If you don’t, check that the heading format. It might be different from what Zapier requires. You can fix it using their documentation.
Now just 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!
I hope you found this tutorial helpful. If you want to find out more about this add-on for WP Ninja forms, check out their website* for all the details. Happy Zapping!