Is it correct setting for a request to Google Sheet?
But Google Script can’t understand the data, responding undefined JSON
However, empty request works well
Best answer by Felix
View original
Userlevel 4
Hey Marina,
I am not sure what exactly your setup is, but I tested it on my account with the add-on “Webhooks for Sheets” and that worked for me (see screenshots). I can’t find any mistakes from your screenshot. Did you setup the script yourself without an add-on?
I think the chances are high you already checked that out, but in case you haven’t, I would highly recommand you to use Make or Zapier for a task like this. They both have a free plan, depending on your volumes of course:
- Make
- Documentation CIO
- 1000 ops/ month for free
- Zapier
- CIO & Google Sheets landing page
- 100 tasks / month for free
Hope that helps,
Felix
I did not know about Webhooks for Sheet. That’s good =) thanks!
Reply
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.