Google Sheets Upsert action: Unable to parse range: A!#ERROR!:#ERROR!

Hello guys.
I’m just starting to use pipe dream. I’m getting error “Unable to parse range: A!#ERROR!:#ERROR!” with Google Sheets Upsert action. What I’m doing wrong?

I tried A in Key Column. Getting this error.
I also tried {{“A”}}. Same error

1 Like

Hi,
Did you manage to solve this, by any chance?
Thx a ton.

Hi @JSONborn

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

I believe this issue above is because the Key Column data is actually given the intended **Update - Column / Values ** pairs.

But I can’t confirm since the screenshot only shows part of the screen.

If you can share your entire Google Sheets Upsert action’s configuration, I might be able to help.

1 Like