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

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.