Google Sheets append error with MailChimp new subscribers

Hi, I'm getting an error when trying to append a new MailChimp subscriber to Google Sheets:

"Invalid JSON payload received. Unknown name "": Root element must be a message."

append-error.png


Thanks,

Ron
 

Supreme

Well-known member
Staff member
Hey @takingaction
Hi, I'm getting an error when trying to append a new MailChimp subscriber to Google Sheets:

"Invalid JSON payload received. Unknown name "": Root element must be a message."

append-error.png

You need to pass the values in a comma-separated line with double quotes. Also mentioned in the help text. Kindly try again and let us know if that works for you.

Eg - "Test 1","Test2","Test 3"

Regards
 
Top