Do you want to know how to connect Google Sheets and Elementor Forms? Looking for a Elementor Google Sheets Integration tool? Do you wish to send different Google Sheets with Elementor Forms? Looking for a better option than Zapier to connect Elementor Forms to Google Sheets?
Elementor is a very popular WordPress page builder actively used by millions of users around the world. It comes with a Elementor Form widget for building contact form, a Elementor makes it easy to build frontend form.
When you generate leads through Elementor Forms you might want to save the form entries data to an external database such as Google Sheets, just like how Google Form saved data on Google Sheets.
Let’s see the best way to connect Elementor Forms to Google Sheets.
How to Connect Elementor Forms to Google Sheets – Video Tutorial
Connect using No Code Zapier Alternative for Elementor Forms
When you question Elementor’s official blog, “How to connect Elementor Form to Google Sheets,” they recommend using Zapier to connect Google Sheets to Elementor Forms.
However, doing this in Zapier would cost you at least $20 per month and $240 for a year!
Others recommend that you add some code to your site to achieve the Elementor Forms to Google Sheets integration if you don’t have Zapier.
If you don’t know how to code, you might be uncomfortable with this.
In this article, I will show an affordable way to integrate Elementor Forms with Google Sheets with Zero Coding and save hundreds of dollars!
Elementor Forms Google Sheets Integration Addon – Tablesome
You may connect and manage your Elementor Forms entry data with Google Sheets using Tablesome.
Tablesome automatically sends the Elementor Form submissions to a Google Sheets spreadsheet whenever someone submits a contact form on your WordPress website.
By mapping form fields on your sheet, Tablesome allows you to export Elementor Form submissions to any Google Sheet spreadsheet. You can link numerous Google Sheets and Elementor Forms together.
By using Tablesome to create an Elementor Forms and Google Sheets integration workflow, you can easily export and save Elementor Forms entries without worrying about data loss.
You can easily begin a free Tablesome trial here.
Step by Step Guide to Connecting Elementor Forms with Google Sheets
Prerequisite
Before you more to implementing the steps below you need to have:
- Elementor Pro plugin installed and create a form on an Elementor page using the Form Widget
- Create a Google Spreadsheet to connect to Elementor Forms. For each form, we advise you to make a free, distinct Google Spreadsheet. We also advise you not to add any other content to this spreadsheet.
- Tablesome Pro plugin installed and activated
Steps to Connect Elementor Forms with Google Sheets
Connect to Google Account
Utilizing Oauth 2.0, Tablesome enables you to connect your WordPress website to your Google account.
- In your WordPress dashboard, go to Tablesome → Tablesome Settings → Integrations → Google
- Then click the “Connect to Google” button
- Log in to your Google account and grant access to all necessary scopes, namely Google Sheets and Google Drive, on the Google Authorization page.
- Save the settings once Tablesome is linked to your Google Account.
Create a Elementor Forms to Google Sheets Integration Workflow:
We must set up a workflow with Tablesome after connecting to a Google account in order to send data from Elementor Forms to a Google Spreadsheet.
- Go to Tablesome → Create New Table and give the workflow an appropriate title
- In toolbar, go to Workflows → Trigger 1
- Choose the “Gravity Forms – On Form Submit” trigger under the trigger field.
- You can now choose which Elementor Form to connect to Google Sheets.
Then go to Action -1 and select “GSheet Add Row” from the Action field section. - Then, select the Spreadsheet you want to link to your form. If you haven’t already, create a spreadsheet before proceeding to this step
-
Next, select the spreadsheet’s worksheet.
Map Elementor Forms Fields to Google Spreadsheet Columns
- In order to send the form data, you have to map the required Elementor Form fields to the corresponding Google spreadsheet columns using Tablesome. You can select only the form fields which you want to export.
- The header for the columns to which you must map the form fields will be taken from the first row of the spreadsheet. Thus, be sure to include the header information in your spreadsheet. You can label the first row to match the fields on your form.
- Save the Tablesome workflow once all the fields have been mapped.
- You can now attempt to submit a form using Elementor Forms.
Overall, integrating Elementor Forms with Google Sheets can help you more easily collect and manage data from your website, and can provide a range of benefits in terms of collaboration, data backup, and integration with other applications.