How to Send the lead form 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 for the lead form and collect the data in the sheet.

Step 1: Click on the edit option of the editor. 

 
Step 2: Go to the form settings, and in advanced settings, you will get the connect now option.

Step 3: Then, you will get the option of a webhook. Add the webhook link there.

Click on Save

Congrats!! Your data is passed in Google Sheets.