Webhooks for Sheets

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...

Congratulations, @choraria! This looks great! 🔥

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 👍🏻

This looks really great @choraria - can't wait to try it out!

This looks amazing! 😍 Spreadsheets are so flexible and useful. I can't wait to give this a try and see what I can automate.

?makers is this just for adding and updating data to the Google Sheet? Or can you READ and DELETE data too?

Great. Just so handy tool without the need to code in apps script. Congrats on the launch.