In this article you will learn how to easily submit form data from Elementor to Google sheets directly without any plugin or external service.
As in this short video example:
Watch the video tutorial, or keep reading!
First, create your Google Sheet
Create a new Google Sheet as you normally would.
Then, open the Script Editor
Open the script editor in Google Sheets.
Go to Tools and the click on Script Editor.
Copy this code to enable the Elementor Form to Google Sheet data transfer
Credits for the code to this GitHub.
<script> /* Please login to get the code * The code will be for the Elementor Export Form Data to Google Sheet Easily tutorial * Found at this URL https://element.how/elementor-form-google-sheets/ */ </script>
Paste the code inside the Google Script Editor in the Code.gs file
Then 1. Click on the title to rename the Script and 2. Click on the disk to Save the changes.
Now, deploy the Script to make the google Sheet ready to receive Elementor Form data
Using New UI (02-2021):
- Click the deploy button > New deployment
- Click on the gear icon close to 'Select type', choose Web app
- Under 'who has access', select 'Anyone'
- Click the 'Deploy' button in the lower right corner
- Follow the on screen instructions to give permission
- Copy the Web app URL
In case you see a different UI (legacy), click here to see the video instruction for that one.
After deploying copy the Web app URL.
Add the action after submit 'Webhook' to your Elementor form
This is what will link it to the google Sheet.
Under the Actions After Submit dropdown add Webhook and paste the copied Web app URL in WebHook URL under the Webhook options.
Finally, make a test by submitting a filled form
Now you can submit data in Elementor form and the data should automatically get synced to your Google Sheet.
You can cleanup and organize your Google sheet.
By deleting the useless 'Sheet1', and re ordering your columns, it makes it much easier to have the information you want, right at the start of the sheet.
You can now submit form data from Elementor Forms to Google Sheets directly without Zapier or any other third party tools. Enjoy!