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:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/7f7ede46-5b19-4d9f-afa6-c98f683a2334.png)
Here’s what I have in the body:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2f878762-83fd-4c3d-b7d0-f20aeee192a3.png)
Here’s my entry in the zap itself:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/83135107-c1cf-4487-8638-b9bf04fb331f.png)
Here’s the error I’m getting: "error": { "code": 400, "message": "Invalid JSON payload received. Unexpected token.\n,}\n^", "status": "INVALID_ARGUMENT" } }