What google sheet operation appends data to a spreadsheet while updating the ones already existing via the key Retool

Hi Community, does anybody know? I want to back up info from a retool table to a google sheet periodically. But I dont want to duplicate entries. I want new entries appended and existing entries (identified by a key) to be updated

I can’t find that option in retool.

I would:

  1. get the primary id column from google sheets.
  2. Then filter the new data to only contain those entries that are not in the primary id column.
  3. Insert those entries into google sheet.
  4. Perform a bulk update for the whole set of entries or only those that where filtered out.
1 Like