Question

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!

Reply