Do you want to know how to connect Gravity Forms to Google Sheets? Looking for a tool to integrate Gravity Forms and Google Sheets? Do you want to send Gravity Forms to different Google Sheets? Looking for the best Zapier Gravity Forms to Google Sheets alternative?
Gravity Forms plugin comes with a Gravity Forms Zapier Add-On that helps you connect Gravity Forms form to Google Sheets via the Zapier automation tool. But with Zapier you have to pay for each form entry that is exported to Google Sheets Spreadsheets.
So you make use of the Tablesome plugin which acts as a connector for Gravity Forms and Google Sheets, and connect unlimited number of forms and export unlimited form entries.
How to Connect Gravity Forms to Google Sheets – Video Tutorial
Gravity Forms Google Sheets Integration Addon – Tablesome
Tablesome allows you to connect and manage your Gravity Forms entries data with Google Sheets. When someone submits a contact form on your WordPress website, Tablesome sends form submissions from Gravity Forms to Google Sheets.
With Tablesome you can export Gravity Forms submissions to any Google Sheet spreadsheet by mapping form fields on your sheet. You can connect multiple Gravity Forms form to multiple Google Sheets.
By creating a Gravity Forms and Google Sheets integration workflow using Tablesome you can easily export and save the Gravity Forms entries without worrying about any loss of information.
How it is better than Zapier:
Zapier charges you a monthly subscription and also charge you for the amount of data that you send to Google Sheets.Tablesome is a reliable one-time investment.
So the best alternative to Zapier’s Gravity Forms to Google Sheets integration is Tablesome. With Tablesome you can send Gravity Forms to separate Google Sheets of your choice. Therefore, Tablesome is the finest solution for connecting Google Sheets with Gravity Forms.
You can easily start a Tablesome free trial here.
Connect Gravity Forms with Google Sheets using Tablesome
Prerequisite
Before you more to implementing the steps below you need to have:
- Gravity Forms plugin installed and created a form that you want to connect to GSheets
- Create a Google Spreadsheet that you want to connect to Gravity Forms. We recommend that you create a free and separate Google spreadsheet for each form and that you do not add any other content on this spreadsheet.
- Tablesome Pro plugin installed and activated
Steps to Connect Gravity Forms with Google Sheets
Connect to Google Account
Tablesome allows you to connect your WordPress site with Google account using the Oauth 2.0 method.
- In your WordPress dashboard, go to Tablesome → Tablesome Settings → Integrations → Google
- Then click “Connect to Google”
- Login to your Google account and in the Google Authorization page give access to all of the required scopes namely Google Sheets and Google Drive.
- After Tablesome is connected to your Google Account save the settings
Create a Gravity Forms to Google Sheets Integration Workflow:
Now you have to create a workflow with Tablesome to send Gravity Forms entries to a Google Spreadsheet.
- Go to Tablesome → Create New Table and give the workflow a suitable title
- In toolbar go to Workflows → Trigger 1
- Under trigger field, select the ‘Gravity Forms – On Form Submit’ trigger
- Now you can select the Gravity Forms form you want to connect to Google Sheets
- Then navigate to Action -1 and click the “GSheet Add Row” option under the Action field section.
- After that, choose the Spreadsheet you want to link to your form. Before moving on to this step, make a spreadsheet if you haven’t already.
- Select the spreadsheet’s worksheet next.
Map Gravity Forms Fields to Google Spreadsheet Columns
- In order to send the form data you have to map the required Gravity Forms form fields to Google Sheets fields using Tablesome. Mapping columns will be based on the Sheet headers and you can even map custom form fields such as Phone Number fields to Google Sheets.
- You have to map the Gravity Forms form fields to match to the corresponding Google spreadsheet columns. You can select only the form fields which you want to export.
- The 1st row from the Spreadsheet will be selected as the Header for the columns to which you have to map the form fields. So make sure to add the header data into your spreadsheet. You can label the 1st row so that it matched your form fields.
- After mapping all the fields save the Tablesome workflow.
- Now you can try to send a form submission using the Gravity Forms.
Upcoming Features:
- Filter Gravity Forms Entries based on Conditions
Send specific Gravity Forms submissions based on user input if you don’t want to send all Gravity Forms submissions to Google Sheets.You can configure form fields to send data only if certain conditions are met. Tablesome also allows you to send data only after payment is received. Send only form entries from specific countries to Google Sheets, for example. - Manually Send Entries to Google Sheets
Besides automatically sending gravity forms submissions to Google Sheets, Tablesome allows you to manually send form entries to Google Sheets. - Logs for Gravity Forms to Google Sheets Data
Tablesome keeps a detailed log of every gravity form submission, which you can easily access. You can see whether or not an entry was sent to Google Sheets, and if it was not sent, you can easily resend it. - Full Synchronization
All Gravity Forms entries are fully synchronized with Google Sheets by Tablesome. If you update an entry, that entry’s row will be updated in Google Sheets. - Error Reporting
If an error occurs while sending data to Google Sheets, Tablesome will send an email with the error details to the specified email address.