Bug: Google Sheets - Upsert Row

Questions & How-to
1

There appears to be a problem with the Google Sheets “Upsert Row” action that prevents any row updating, at least under the following setup:

  1. Create google sheet with KEY column as Column B (eg “Date”, “ID”, “value”)
  2. Create upsert workflow to use Column B and provide a value that already exists in the sheet.
  3. Use the “run node once”, and observe the behaviour in google sheets.

This should update the already existing row, but instead it creates a new row.

I can provide more detailed examples if this cant be replicated.

2

Hello! I’ve taken this for testing and will get back to you with the results. There may indeed be a bug. I’ll update you soon!

3

Hi @Raian, do you have an update for this is problem? Have you been able to confirm as a bug?

4

Hello, sorry for the delayed response. During testing, everything worked correctly in all my cases. Fields with existing values were updated properly and did not create duplicates.

Additionally, everything functions as expected in the developers’ debug scenario

Could you please provide screenshots or a screencast of the issue?