Skip to main content
Solved

Data from Customer.io to Google Sheets


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

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

View original
Did this topic help you find an answer to your question?

2 replies

Felix
  • Novice
  • 210 replies
  • Answer
  • March 4, 2023

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


  • Author
  • Novice
  • 1 reply
  • March 5, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings