Google Sheets Addon

Google Sheets Addon is a Pro Feature

Unlock Google Sheets Addon and other powerful features to grow your business.

Get WPForms Pro

Would you like to automatically send form entry data to Google Sheets? The Google Sheets addon for WPForms provides a simple method for sending your form entries directly to a Google spreadsheet.

This tutorial will show you how to install and use the Google Sheets addon in WPForms.

Requirements:


Before getting started, you’ll first need to make sure WPForms is installed and activated on your WordPress site and that you’ve verified your license. You will also need to sign up for a Google account if you don’t already have one.

Accessing Google Sheets Integration Settings

Once you’ve installed WPForms and your license is verified, go ahead and install and activate the Google Sheets addon.

After installing the Google Sheets addon, you’ll need to access the Google Sheets integration settings. To do this from the WordPress dashboard, go to WPForms » Settings and click on the Integrations tab.

click-integrations-tab

Next, click on the Google Sheets integration to expand its settings.

click-google-sheets

Connecting WPForms to Google Sheets

To connect WPForms to your Google account, go ahead and click the Continue with Google button.

click-to-continue-with-google

Note: If you would prefer to use a custom application to connect WPForms to Google Sheets, you can click Enable Advanced Mode to set up and connect your Google app. See our documentation on connecting to Google Sheets via custom application for more details.

You’ll then be redirected to a Google authentication page where you’ll need to select a Google account to use with WPForms.

Choose an account

Once you’ve selected a Google account, click the Continue button to sign in and connect your account.

Sign in to Google account

Next, click Allow to grant WPForms access to your Google account.

Click Allow to grant access

Note: To learn more about the Google permissions needed for WPForms, check out our documentation on Google permissions for the Google Sheets addon. If you prefer not to share your Google data with WPForms, you can connect via a custom Google application instead.

Now when you return to WPForms » Settings » Integrations, you should see the green Connected status along with your connection details.

google-sheets-connected-status

Note: The Google Sheets addon only supports one Google account connection at a time.

Adding a Google Sheets Integration to Your Form

Now that you’ve successfully connected WPForms to your Google account, it’s time to add a Google Sheets integration to your form. To do this, you’ll need to create a new form or edit an existing one to open the form builder.

Once you’ve accessed the form builder, go to Settings » Google Sheets and click the Add New Connection button.

select-add-new-connection-button

Next, an overlay will appear where you can enter a connection nickname. Feel free to use any nickname you’d like, as this won’t be visible to your users. Once you’ve added a nickname, click the OK button.

add-nickname-and-click-ok

Configuring Connection Settings

After you add a connection nickname, additional settings will appear. Here you’ll see options to create a new spreadsheet or select an existing spreadsheet that you already have in your Google account.

For this example, we’ll create a new spreadsheet by selecting the Create New option.

create-a-new-spreadsheet

Note: If you’re selecting an existing spreadsheet, please note that only Google spreadsheets you have permission to edit will appear in the list of available spreadsheets. Check out Google’s documentation on sharing files from Google Drive to learn more about access permissions.

Although it’s optional, we recommend adding a name to the Spreadsheet Name and Sheet Name fields to help you keep track of your spreadsheet.

spreadsheet-and-sheet-names

Once you’ve connected your form to a Google spreadsheet, a link icon will appear under the Spreadsheet section of your connection settings.

Go ahead and click the link icon to open your Google spreadsheet in a new browser tab.

click-link-icon

Mapping Form Fields to Google Sheets

Under the Field Mapping option, you’ll see two columns for mapping your form fields to your spreadsheet: Column Name and Form Field Value.

column-name-and-form-field-value

By default, WPForms maps the Entry ID to Column A of your spreadsheet.

default-entry-id-custom-value

When the form submission is added to your spreadsheet, the Entry ID will appear as a link in Column A. Clicking the Entry ID link will take you to the individual entry page for that particular form submission.

entry-id-link-in-google-sheets

If you’d like to map form data to a new column, simply click the Column Name dropdown and select your desired column.

select-a-column

Then, you’ll need to select a form field you’d like to map to the column in your Google spreadsheet. To select a form field, click the Form Field Value dropdown and click on the form field you’d like to use.

For our example, we’ll select the Name field.

select-name-field

In our Google spreadsheet, we’ll now have a column where we can see the names of users who submit our form.

name-mapped-to-google-sheets

Adding a Custom Value

Instead of selecting a field from your form to map to your spreadsheet, you can use a Custom Value, such as a Smart Tag or Google Sheets formula.

To add a custom value, click the Form Field Value dropdown and select Custom Value.

select-custom-value

Then, a new field will appear where you can insert your custom value.

If you’d like to use a Smart Tag for the custom value, go ahead and click the Smart Tag.

click-smart-tag-icon

You’ll then see a list of available Smart Tags. For our example, we’ll select the Entry Date Smart Tag so we can quickly see the date of the form submission in our spreadsheet.

select-entry-date-smart-tag

Note: Want to learn more about Smart Tags? Be sure to check out our guide to using Smart Tags in WPForms.

Now when a user submits our form, we’ll see the date of the form submission will appear in our Google spreadsheet.

entry-date-mapped-to-google-sheet.png

Note: The Google Sheets addon also supports conditional logic. Be sure to check out our guide to using conditional logic to learn more.

Once you’re finished configuring your connection settings, be sure to save your form by clicking the Save button.

click-to-save-form

Frequently Asked Questions

Below are some of the most common questions we receive about using the Google Sheets addon with WPForms.

I have a lot of spreadsheets in my Google account. Why don’t I see all of my spreadsheets when I try to select one to use with WPForms?

Please double-check your access permissions for the specific Google spreadsheet you’d like to use. Only Google spreadsheets you have permission to edit will appear in the list of available spreadsheets to select. To learn how to request Editor access, check out Google’s documentation on sharing files from Google Drive.

Once you have Editor access, the list of available spreadsheets may take a few minutes to update in your WPForms settings.

Can I disconnect the Google Sheets addon in WPForms?

Yes, WPForms provides the option to disconnect your Google Sheets connection for a single form or from your site entirely. To learn more, see our tutorial on disconnecting Google Sheets connection in WPForms.

I have more than 26 fields in my form. How do I add extra columns in Google Sheets?

By default, Google Sheets has 26 columns representing the 26 letters of the alphabet (A-Z). If you require more than 26 columns when setting up Google Sheets on your form, you’ll need to create the new columns from the Google Sheets doc.

For more details, be sure to check our tutorial on adding an extra column in Google Sheets.

Why can’t I see a shared corporate spreadsheet in the available options for form connection?

If you can’t see a corporate spreadsheet shared via email groups, it’s likely due to the connected Google Sheets addon account not having direct Editor access. To fix this, ensure the connected account email has Editor access to the spreadsheet, even if you already have group access.

Keep in mind that the list of available spreadsheets is cached and updated every 10 minutes. You may need to wait or clear your cache to see the updated list.

For more details on sharing files and managing access permissions in Google Drive, check out Google’s documentation for sharing files from Google Drive

Why do deleted column names still appear when I reconnect my Google Sheet to WPForms?

This occurs due to a 15-minute caching of column names in WPForms. To resolve this, either wait 15 minutes for the cache to update or manually clear the WordPress transient cache. For more info on clearing cache, follow WPBeginner’s guide to managing and deleting transients in WordPress.

I’m not seeing the option to update WPForms. How do I update the plugin?

Google Sheets addon requires having the latest version of WPForms installed on your website. Sometimes, the option to update the plugin won’t show in your WordPress admin area.

To resolve this, you’ll need to force your WordPress site to check for plugin updates. For more details, see WPBeginner’s guide to forcing plugin updates in WordPress.

That’s it! Now you know how to set up and use the Google Sheets addon for WPForms.

Next, would you like to learn more about what you can do with user-submitted information in WPForms? Be sure to check out our complete guide to form entries to learn more.

The Best WordPress Drag and Drop Form Builder Plugin

Easy, Fast, and Secure. Join over 6 million website owners who trust WPForms.

Please enable JavaScript in your browser to complete this form.