Need help on this update google sheet row error

Status: Open · Asked by pabblytest on · 0 views

pabblytest — Question ·

I get these two errors in my workflow:
Task History ID: IjU3NjUwNTZmMDYzZjA0MzA1MjY0NTUzMTUxMzI1MTYzNTQzMjBmMzEi_pc
Step Name: Google Sheets > Update Row
Connection Name: Google Sheets #1
Task Error Detail:

{
"error > code": 400,
"error > message": "Unable to parse range: Sheet1!A",
"error > status": "INVALID_ARGUMENT"
}

can you help? Thanks!

Arshil Ahmad — Reply ·

Hi @pabblytest,

The value (4 - Horrific Old Medical Tools) you tried to search for in the 'Lookup Spreadsheet Rows' action step does not appear to be present in your Google Sheets spreadsheet, because of which no row has been passed to the 'Update Rows' action step, and you encountered the error.
https://drive.google.com/file/d/1VIOvXoQf_WU_wPJU8oJ5btt85RnNq0mM/view?usp=sharing

pabblytest — Reply ·
Hi @pabblytest,

The value (4 - Horrific Old Medical Tools) you tried to search for in the 'Lookup Spreadsheet Rows' action step does not appear to be present in your Google Sheets spreadsheet, because of which no row has been passed to the 'Update Rows' action step, and you encountered the error.
https://drive.google.com/file/d/1VIOvXoQf_WU_wPJU8oJ5btt85RnNq0mM/view?usp=sharing


thanks!

Back to all forum threads · Log in to reply