Want to monitor your form entries in a spreadsheet? When you connect WordPress to Google Sheets, you and your team members can easily sort through and analyze the data. Here’s how to send data from your WordPress form to a Google Sheet.
Saving Form Entries in Google Sheets
A few benefits of saving form entries in Google Sheets are:
- Easy team collaboration: Your team members can easily monitor form entries. You don’t need to provide login credentials to your WordPress dashboard.
- Quick data analysis: Generate personalized reports based on the data your visitors submit and make informed decisions quickly and easily. For example, if you’re creating a poll, you can easily interpret the user inputs by connecting them with Google Sheets.
- Save entries automatically: You don’t need to enter the form entries by hand. Simply connect your form with Google Sheets and all the entries will be saved automatically.
Integrate WPForms With Google Sheets
After the installation, you’ll need to create a simple WordPress form. You can see our tutorial on creating a simple contact form in WPForms. Let’s rename the form as Google Sheets for the sake of this example.
In order to import entries into Google Sheets from your form, you’ll need to install and activate Zapier addon on your site. The Zapier addon lets you connect your WordPress forms to over 1500+ web apps, including things like Salesforce, Jira, and the Google Sheets app.
For more help with this step, you can check out our tutorial on how to install and use the Zapier addon.
Now let’s take a look at how to connect WordPress forms to Google Sheets.
Log into your Zapier account and click the Make a Zap button in the top navigation.
Then, follow Zapier’s step by step guide to create a Zap. To see screenshots of every step, you can refer to our tutorial on using Zapier with WPForms.
Make sure to choose the Google Sheets form you just created, when you’re asked to setup Edit Options. You must have at least one test entry on your form before fetching existing entries.
You should then see a successful confirmation message.
Connect WordPress Forms to Google Sheets
After connecting Zapier to the WPForms plugin, you’ll need to connect WPForms to Google Sheets.
The first step is to choose Google Sheets as the action app. Enter Google Sheets in your search bar, and then, click on it when it shows up.
Then, you’ll be asked to select Google Sheets action. As we are looking to add form entries to Google Sheets from WordPress, let’s choose Create Spreadsheet Row and click Continue.
Now you need to connect your Google account to Zapier. To do this, you’ll need to authorize Zapier to access your Google Sheets data. After authorizing it, click Continue.
Yikes…Are you guilty of any of these? Be sure to check out our list of the biggest complaints about contact forms from site visitors.
Create a Spreadsheet and Import Entries
Before you can import the form entries to your Google Sheets, you’ll have to create a new spreadsheet by logging into Google Sheets.
You’ll also have to add new rows in your spreadsheet so that form entries can be configured with the corresponding row.
Now go back to your Zapier account. You’ll be asked to specify the name of the spreadsheet and worksheet. Once you specify them, you’ll be shown the rows you just created in your specified spreadsheet. Make sure to connect each form field to the appropriate Google Sheets field. After connecting them all, click Continue.
If you want to test what data has been updated in Google Sheets, click on Test. You’ll now see the data just like the screenshot below. Click Create & Continue.
You’ve just tested Google Sheets app on Zapier successfully.
You may login to your Google Sheets account to verify the updated data.
In the final step, make sure to turn on your Zap. You can also give your Zap an appropriate name. By turning on Zap, you can automatically send all future form entries to Google Sheets whenever your visitors submit the form on your site.
You’ve just connected your WordPress form with Google Sheets. All the future entries will be added to the specified spreadsheet in Google Sheets.
Do you want to encourage form submissions on your site? Check out how to create a popup feedback form in WordPress.
What are you waiting for? Get started with the most powerful WordPress forms plugin today.