Webhook Integration with Google Sheets

Here is the video illustrating the procedure of Smartflo webhook integration with Google Sheets.

1. Log in to Gmail and then search Google Sheets. 

2. Open a blank new sheet and give the spreadsheet and sheet any name.

3. Click on Extensions and go to App Script. Copy the script provided by the support team into the code.gs file.

4. Then search for the spreadsheet name variable and assign the value of the var with the name given to the sheet in Step 2.

5. Click on Publish, select Deploy as a web app, and then select as new, select the account for which the spreadsheet is made, and then select "Anyone, even anonymous" in the who has access to the app. Then click on Update.

6. It will ask for authorization, authorize it, and then a URL will be provided. copy it and append ?gskey=qwerty12345 to it.

7. Use this URL in webhooks for getting the responses in Google Sheets.

     

8. Log in to the Smartflo portal.
   

9. Go to Services > Webhook and click on the Add Webhook button.
   

10. Create a webhook and add the copied link in the URL tab and click Save.