Upsert Row on Google Sheets throw err: Unable to parse range:

Help
1

This is my Flow :
Trigger & API call work ok .
But Upsert Row on Google Sheets throw this err:

Unable to parse range: nhap!#ERROR!:#ERROR!

at Gaxios._request (/tmp/ee/c_1qfre14/node_modules/.pnpm/gaxios@4.3.2/node_modules/gaxios/build/src/gaxios.js:129:23) at process.processTicksAndRejections (internal/process/task_queues.js:95:5) at OAuth2Client.requestAsync (/tmp/ee/c_1qfre14/node_modules/.pnpm/google-auth-library@7.14.0/node_modules/google-auth-library/build/src/auth/oauth2client.js:368:18) at Object.updateSpreadsheet (file:///tmp/ee/c_1qfre14/user/google_sheets/google_sheets.app.mjs:311:15) at Object.updateRow (file:///tmp/ee/c_1qfre14/user/google_sheets/google_sheets.app.mjs:469:14) at Function.all (null:null:null) at Object.run (file:///tmp/ee/c_1qfre14/user/google_sheets/actions/upsert-row/upsert-row.mjs:181:9) at global.executeComponent (/var/task/launch_worker.js:154:22) at MessagePort.messageHandler (/var/task/launch_worker.js:620:35)

2

Hi @welcomenemalstore

First off, welcome to the Pipedream community. Happy to have you!

That is a really opaque error I agree.

Just googling around, it sounds like one or more header rows that you have set up in the action have been removed or just don’t exist in the actual Google Spreadsheet.

Can you double check to make sure all headers are present that need to be?

3

i folowed the exam , but still get this err.

do you have any flow that work , can i view an examle flow that work ?

4

thanks for reply , can i view an exam flow that worked ?

5

Hi @welcomenemalstore , thanks for your patience, we’re all currently on a Pipedream off site and have spent some time away from keyboards.

Here’s an example workflow of logging the request IP address to a Google Sheet with the Upsert action:

If that’s not helpful, could you perhaps share some more information about the parameters you’re passing to the upsert action?

1 Like
6

This BUG occurs in spreadsheets that are configured with a language where the parameter separator for formulas is not a comma ( , ). In Portuguese, for example, the separator is the semicolon ( ; )

On File menu => Settings Switch to English (United States) and it should work.

But keep in mind that this change will impact the formatting of date and decimal number fields.

image
image715×545 57.3 KB