Solved

Data from Customer.io to Google Sheets

  • 3 March 2023
  • 2 replies
  • 111 views

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

icon

Best answer by Felix 4 March 2023, 10:51

View original

2 replies

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:

 

Hope that helps,
Felix

I did not know about Webhooks for Sheet. That’s good =) thanks!

Reply