Google Spreadsheet error 400

[Patrik_NM]

Hello,

i am trying to set up my first pabbly connect

I use a webhook and spreadsheet where I want to add a row with variables from the webhook.
If I set the variable to the spreadheet in the first column, the update will go without problems. However, if I put the variable in the 2nd or other columns, it will show some errors:

• Error code: 400
• Error message: Requested writing within range ['Google Ads: Leads'! A6], but tried writing to column
• Error Status: INVALID_ARGUMENT

Can you help me pls?

 

[Pabblymember11]

Hello,

i am trying to set up my first pabbly connect

I use a webhook and spreadsheet where I want to add a row with variables from the webhook.
If I set the variable to the spreadheet in the first column, the update will go without problems. However, if I put the variable in the 2nd or other columns, it will show some errors:

• Error code: 400
• Error message: Requested writing within range ['Google Ads: Leads'! A6], but tried writing to column
• Error Status: INVALID_ARGUMENT

Can you help me pls?

Please reconnect the Google Sheet steps and try again. Make sure to clear your browser cache issue once -

 

[eilishbilliepatrick]

A Google Sheet Error 400 typically indicates that the credentials used in the integration are invalid. If Google Sheets returns a Bad Request - "Unable to retrieve cells" error, this is because you do not have column labels in the first row of your sheet.

 

[Patrik_NM]

the problem was that the sheet name contained a colon, after removal it works without problems