Webhooks for Sheets

Create Apps Script-native Webhooks for Google Sheets

20 followers

Create Apps Script-native Webhooks for Google Sheets

20 followers

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 🔥

Free

Launch tags:API•Spreadsheets

Launch Team

Wispr Flow: Dictation That Works Everywhere — Stop typing. Start speaking. 4x faster.

Stop typing. Start speaking. 4x faster.

Promoted

Webhooks for Sheets

Maker

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

Report

4yr ago

@choraria Looks awesome!

Report

4yr ago

Webhooks for Sheets

Maker

So many thanks, mate!

Report

4yr ago

Agent Maya (by Flow AI)

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

Report

4yr ago

Webhooks for Sheets

Maker

Hey @darren_alderman 👋🏽 At the moment it can only add data 😅 I should be able to add the ability to read the data fairly easily too 🤔 Will work on it in the upcoming iterations.

Report

4yr ago

Agent Maya (by Flow AI)

@choraria Thanks!

Report

4yr ago

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

Report

4yr ago

Webhooks for Sheets

Maker

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.

Report

4yr ago

Visor

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

Report

4yr ago

Webhooks for Sheets

Maker

You bet! And thanks, Michael 🦾

Report

4yr ago

Noloco

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

Report

4yr ago

Webhooks for Sheets

Maker

You bet! Do feel free to reach out and share anything that did/didn't work too 🙏🏽

Report

4yr ago

Copy Text Easily

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

Report

4yr ago

Webhooks for Sheets

Maker

Thanks, Basharath 🙌🏽

Report

4yr ago

Congratulations, @choraria! This looks great! 🔥

Report

4yr ago

Webhooks for Sheets

Maker

Thanks, Ben. Hope this is helpful and if not, happy to listen-in on either feature adds or improvements 🤓

Report

4yr ago