This is a Google Workspace add-on that will allow you to instantly create a webhook & start logging incoming data onto a Google Sheet, without writing any code or signing-up on a new platform 🔥
Hey PH peeps 👋🏾
I'm Sourabh — a typical spreadsheet nerd who's currently obsessed with making it easy to use webhooks.
Webhooks inherently are these special kind of APIs that allow you to capture incoming data and with the right tool set, even log it appropriately where needed. Given how Google Sheets already allows us to create automations and connect with external sources with the help of Apps Script, after tinkering for a while with different approaches on how to make this process easier — compared to how folks do it today i.e. by either copy>pasting code or making a copy of an entire existing spreadsheet — thanks to the relatively new Apps Script API, making this add-on a reality was finally complete.
Here's what's possible in a nutshell: "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
INSTRUCTIONS
1. If you're installing or using the add-on on a freshly created Google Sheet (which still has that "Untitled spreadsheet" in the name), you will need to name/rename it to something else in order to save the spreadsheet to your Google Drive
2. Make sure that you've enabled your Google Apps Script API by navigating to this link: https://script.google.com/home/u...
3. During the webhook creation process, you'll be asked to reload the add-on and the spreadsheet. Whenever you do need to do that, make sure to click on the add-on icon from the right-side panel on the browser to come back to the add-on screen where you may've last left-off
TIPS & TRICKS
- Make both GET and POST requests via HTTP methods although, at the moment, plain text, HTML and XML data types in POST isn't supported.
- Use the "gid" parameter multiple times to add more than one sheet Id (taken from the spreadsheet URL) when triggering a request and that way, you can log data on all those sheets via single incoming request — more on this can be found here https://youtu.be/hj3y0QTykdQ?t=487
Feel free to reach out to me on code@script.gs or by any other means as listed here — https://script.gs/contact
Let's also connect on:
- Twitter — https://twitter.com/choraria
- LinkedIn — https://www.linkedin.com/in/chor...
This is cool, @choraria! It's amazing how many times you end up using Google Sheets when building out NoCode solutions despite having other powerful, relational data stores at your disposal so being able to send data directly into Sheets is a great idea.
For example, Apify has a handy Webhooks integration to take action based on the outcome of your tasks so you can send your data over to a specific sheet, using the Webhook URL your add-on supplies, if the Apify task succeeds and to another sheet if the task fails perhaps. Currently I use Make (formerly Integromat) to intercept the data and parse it but sometimes it's better to go directly to your destination as you do here.
Well done on the launch and thanks for making it 👍🏻
Whoa! Thanks so much for sharing the scenario there. If you run into any issues or feel like something’s missing, please please don’t hesitate to reach out.
