I’m trying to update a column at a time with google sheets. Ideally I’d like to do multiple columns, but we’re starting with just one.
I’ve got everything set up according to the google API documents and when I test the API, it works. But when I transfer the zap over live, it runs into an error saying that the formatting is wrong and it expected another value. I’ve tried this with multiple inputs (a column of 5-6 values) and just one value, but I get the same error each time. Here’s what google API documents say it should look like:
Here’s what I have in the body:
Here’s my entry in the zap itself:
Here’s the error I’m getting: "error": { "code": 400, "message": "Invalid JSON payload received. Unexpected token.\n,}\n^", "status": "INVALID_ARGUMENT" } }