Philip is freelancer
If you feel the content is useful. Thank for me with a coffee ๐
Google sheet provides a convenient way to collect data. You can use it to store data forms, connect with other CRM and marketing applications.
When you connect Forms to Google Sheets, you can use the analytical powers of the latter to make powerful calculations from the gathered data.
In this tutorial, we will show you how to connect Brizy Forms to Sheets. We will show you how to do this.
WHAT IT CAN DO
Webhooks for Sheets puts the ability to instantly create a webhook and start accepting/logging incoming data onto a Google Sheet, without writing any code or having to sign-up on a new platform.
With this add-on, you'll be guided through:
1. Enabling your Apps Script API with just 2 clicks
2. Adding a new container-bound Apps Script project to your existing Google Sheets
3. Updating your script with open-source (pre-written) code and instantly deploying it as a web-app
4. Authorizing the newly minted script by means of a custom menu option and start using it to receive & log incoming data
Step 1: Creat a new sheet and install app "Webhooks for Sheets"
Install app "Webhooks for Sheets":
- Seach google with key: "Webhooks for Sheets", install
- Create a new Sheet or open a sheet to save form data
- Click open app (icon menu right bar) and Follow the suggested steps:
+ Reload this spreadsheet
+ Click on the Webhooks custom menu option and then choose Authorize
+ Repeat Click on the Webhooks custom menu option and then choose Authorize, again
+ Reload the spreadsheet, again and done ! ๐
Step 2: Add Integrate WEBHOOK to form
Step 3: Setting Integrate webhook
- Copy Webhook url from "Google sheet" (inside app Webhooks for Sheets)
- Paste URL to REQUEST METHOD
- Set REQUEST METHOD : POST
- Connect and done
If you feel the content is useful. Thank for me with a coffee ๐
