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
What google sheet operation appends data to a spreadsheet while updating the ones already existing via the key Retool
I can’t find that option in retool.
- get the primary id column from google sheets.
- Then filter the new data to only contain those entries that are not in the primary id column.
- Insert those entries into google sheet.
- Perform a bulk update for the whole set of entries or only those that where filtered out.