Flow: Add Google Sheets lookup, update and upsert rows plus a new row trigger
n8n's Google Sheets node supports append or update row, update row, get rows with filters, clear and delete (https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/sheet-operations/), and Zapier's most used Sheets trigger is 'New or Updated Spreadsheet Row'. Our Sheets node only appends a row or reads a whole range (lib/flow-integrations.ts sheetsConfigSchema operation append|read) and there is no Sheets trigger. Sheets is the default database of small teams, so 'update the row for this deal when it is won' and 'when a row is added, create a contact' are everyday cases. First scope: lookup by column, update and upsert by key column, and a polling trigger for new rows using the schedule infrastructure. Priority: medium. Effort: M. Compared with Zapier / n8n.
Comments 0
No comments yet.
Sign in to comment