Struggling to find a good way to send data from WordPress into Google Sheets? Your search is over!
Spreadsheets might not be the most exciting thing in the world, but when you need one, you need one! Google Sheets specifically is one of the best and most popular spreadsheet applications for collaborative teams. Unfortunately, there’s not a whole lot of easy-to-find ways to integrate WordPress with them.
If you’ve visited WordPress.org recently looking for a plugin that’ll do the trick, you’ve probably been disappointed.
Custom integrations work, but the time and resources to maintain them can be a real hassle.
What other options are there?
How to connect WordPress with Google Sheets with your WordPress forms
Connecting WordPress with Google sheets can be done in just 3 steps using your WordPress forms.
Sending data over is automated and immediate. All you have to do is establish the link and information flows over with every form submission! Let’s look at how.
What you’ll need to follow this guide:
1. Get set up with Zapier.
Next, create an account with Zapier themselves. Now you’re ready to get started!
2. Make a Zap!
Integrations between applications handled by Zapier are called Zaps. We’ll be creating a Zap that will connect Ninja Forms with Google Sheets. It’s super simple. Just log into your Zapier account and click “Make a Zap” in the left toolbar.
3. Setup your Zap to connect any WordPress form with Google Sheets
Once you’re in the zap setup page, just search Ninja Forms in the App & Event search bar to find us:
Leave “New Form Submission” set as the Trigger Event and Continue. You’ll now be shown a webhook:
Copy it, then head back to WordPress and into your form (or create one to the specifications you need). 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 Continue.
You’ll now be prompted with a few options to proceed. We recommend to Test & Continue to make sure the webhook has succeeded in establishing a connection. If anything goes wrong, Zapier will give you troubleshooting steps.
On a successful test, it’s now time to connect WordPress to Google Sheets. Same as before, search and select them:
With your action selected, you’ll then be asked to select the Google account you want to connect to Zapier.
Next, you’ll 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).
Once your Spreadsheet and Worksheet are selected, you should see the relevant headers for that Worksheet appear:
If you don’t, your heading formatting likely differs from what Zapier requires. That’s a simple fix 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!
Connect WordPress to Google Sheets in 3 easy steps, zero code required!Click To Tweet
If you followed these 3 steps, you now have WordPress connected to Google Sheets. Congratulations!
One of the most beautiful things about WordPress is being able to take the stock experience and make it truly your own. Thousands on thousands of plugins offer nearly limitless integration to products and services produced by people all over the world.
It’s a big world though, and the WordPress.org repository can’t possibly cover it all. That’s where Zapier comes into play, connecting you to apps that don’t have an official plugin yet. We’re proud that your WordPress forms in part make that connection possible.
We hope you enjoy your new connection! What integration would you like to see a tutorial for next?