How to Send the Product 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 for the product set rules and collect the data in the sheet.

Step 1: Click on the "Create New Product" 

 
Step 2: Inside the product, select all the pages, payment options, and price, and Click on set product Rule

Select the webhook option> provide webhook name > insert the webhook URL

Click on Save

Step 3: Save the Product setting & then click on the save Button

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

Congrats!! Your data is passed in Google Sheets.