How to Send the Product 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 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 4After 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