5 ms·

Turn your Google Sheets into a webhook without code

62 points by wayneshng 4y ago

habibur 4y ago
$15/month.
- ducharmdev 4y ago
  Behind every no code solution, is a SaaS company making bank off the belief that we don't need code... by writing code.
  - zoover2020 4y ago
    ~turtles~ programmers all the way down!
  - stevesearer 4y ago
    I just started to pay $9/mo for a tool that monitors a folder on an sFTP server for updates to a .csv, then parses the files and posts the data to a webhook. At first I balked at that, and then realized I had no idea how to do that and it has worked flawlessly so far.
    - gl9 4y ago
      That is how I look at SaaS tools. If your hourly rate is greater than the months subscription it is worth it. In enterprise, just getting something hosted in a local server was hell, add in maintenance and the money is worth it.
  - ivix 4y ago
    You have just described the whole software industry.
  - DangitBobby 4y ago
    You don't need code! You need functionality ;)
- sufehmi 4y ago
  This should be the topmost comment.
soared 4y ago
Low code tools can be a bit funny and this is the perfect example. A person who knows what a webhook is probably doesn’t need this tool. The people who need this tool’s functionality.. likely don’t know what a webhook is. I just started use an app script called importJSON which lets you make api calls directly from gsheets, since I get a lot of value from apis but don’t know how to actually code. This post looks to be in a comparable area, but I don’t know if that’s accurate. The introduction needs improvement. > In this article, we will talk about how to turn your Google Sheets into a webhook so that you can receive data from the endpoint and have the data inserted into your Google spreadsheet What value does this provide, and can you give me an example use case? What is “the data” in this context? Ideally you don’t want a lowcode user to leave your blog post to google the answers to these questions.
- wayneshng 4y ago
  Hi, thanks for the advices. I think I should have added some explanation about what a webhook is and how it can be useful. Will update the post.
  - soared 4y ago
    Looking forward to it. I have many gsheets that would make excellent websites, but converting gsheet logic to work on a website has eluded me.
- ec109685 4y ago
  You need some proxy from webhook into the google sheet, right?
  - soared 4y ago
    I don't know what a webhook is, so I don't know :P
gl9 4y ago
This could work great with sql2sheets[1] new feature[2] I launched yesterday, which lets you collect html form responses directly to google sheets, if you want to stay on brand and not use the google forms product. [1]https://sql2sheets.com https://sql2sheets.com [2]https://www.youtube.com/watch?v=jAgbhPRT9D4 https://www.youtube.com/watch?v=jAgbhPRT9D4

62 points by wayneshng 4y ago

habibur 4y ago

$15/month.

ducharmdev 4y ago
Behind every no code solution, is a SaaS company making bank off the belief that we don't need code... by writing code.
- zoover2020 4y ago
  ~turtles~ programmers all the way down!
- stevesearer 4y ago
  I just started to pay $9/mo for a tool that monitors a folder on an sFTP server for updates to a .csv, then parses the files and posts the data to a webhook. At first I balked at that, and then realized I had no idea how to do that and it has worked flawlessly so far.
  - gl9 4y ago
    That is how I look at SaaS tools. If your hourly rate is greater than the months subscription it is worth it. In enterprise, just getting something hosted in a local server was hell, add in maintenance and the money is worth it.
- ivix 4y ago
  You have just described the whole software industry.
- DangitBobby 4y ago
  You don't need code! You need functionality ;)
sufehmi 4y ago
This should be the topmost comment.

soared 4y ago

Low code tools can be a bit funny and this is the perfect example. A person who knows what a webhook is probably doesn’t need this tool. The people who need this tool’s functionality.. likely don’t know what a webhook is. I just started use an app script called importJSON which lets you make api calls directly from gsheets, since I get a lot of value from apis but don’t know how to actually code. This post looks to be in a comparable area, but I don’t know if that’s accurate. The introduction needs improvement. > In this article, we will talk about how to turn your Google Sheets into a webhook so that you can receive data from the endpoint and have the data inserted into your Google spreadsheet What value does this provide, and can you give me an example use case? What is “the data” in this context? Ideally you don’t want a lowcode user to leave your blog post to google the answers to these questions.

wayneshng 4y ago
Hi, thanks for the advices. I think I should have added some explanation about what a webhook is and how it can be useful. Will update the post.
- soared 4y ago
  Looking forward to it. I have many gsheets that would make excellent websites, but converting gsheet logic to work on a website has eluded me.
ec109685 4y ago
You need some proxy from webhook into the google sheet, right?
- soared 4y ago
  I don't know what a webhook is, so I don't know :P

gl9 4y ago

This could work great with sql2sheets[1] new feature[2] I launched yesterday, which lets you collect html form responses directly to google sheets, if you want to stay on brand and not use the google forms product. [1]https://sql2sheets.com https://sql2sheets.com [2]https://www.youtube.com/watch?v=jAgbhPRT9D4 https://www.youtube.com/watch?v=jAgbhPRT9D4