How to Send the Form Data to Google Sheets Without Using the 3rd Party Tool?

Modified on Thu, 30 Nov, 2023 at 12:21 PM


Step 1: Create a Google sheet and click on  Extension > Add-ons > Get Add-ons




Step 2: Once you follow the steps, this screen will appear. 



Step 3: Search Webhooks for sheet in the Search bar and "install" the Add-ons


Step 4: After Installing Add-ons, Refresh(Reload) the sheet 


After reloading the webhook Icon visible on the right Panel of the sheet shown below, click on the webhook Icon.


Step 5: Select the Form and click on Create Button 



In order to take out the webhook URL with the sheet, follow the steps mentioned below: 


Step 1: Reload the Spreadsheet 


Step 2: Click on the Webhook custom menu option and then choose Authorize


Click on Ok 


Choose your Google account. 



Click on Allow

 



Step 3: Again, click on the Webhook custom menu option and then choose Authorize 


Reload the Spreadsheet > click on webhooks > click on Authorize.


Once you follow the steps, this popup will appear in the lower right corner.





Step 4: Reload the Spreadsheet


Now all four steps are completed, click on Next; it will show you the Webhook URL.

Let's collect this Webhook URL to the form and collect the data in the sheet.



Step 1: Click on the "Create New Project"


Step 2: Inside the project, create a new page via "Add New Page."




Step 3: Add the form element to the Editor.




Step 4: Go to the settings of the form, add the Webhook URL, & click on the save button.





Step 5: Publish the page and fill out the form on the published URL.



Step 6: After filling out the form, you will see the data in your Google sheet.




Congrats!! Your data is passed in Google Sheets.






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article