Can anyone review this custom action with google sheets for me?

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" } }

0 replies

Be the first to reply!