Getting started
Rules Engine Widgets
Google Sheets Trigger
4 min
the google sheets trigger node is an event driven entry point that starts a simplita workflow automatically whenever data changes in a connected google sheet, removing the need for manual or scheduled runs it integrates a small, pre generated google apps script into your sheet, which listens for inserts, updates, and deletions and posts a structured json payload to a secure webhook url exposed by this node use this node when a workflow must react instantly to spreadsheet activity rather than running on a schedule or manual trigger typical use cases include form submission automation, lead intake from sheets, data validation/enrichment, approval flows driven by status changes, and real time sync to external systems (crm, ticketing, notifications) node configuration connection tab (google sheet access) this tab connects simplita to the target spreadsheet and sheet tab authentication (required) select a google service account credential (stored as a json key) spreadsheet id (required) the spreadsheet file id from the google sheets url (the long id between /d/ and /edit) sheet name (required) the exact sheet tab name (case sensitive), for example sheet1 credential requirements (service account) the service account email must be shared on the spreadsheet as a collaborator with the required access level (commonly editor for full functionality) if “no custom credentials found” appears, add a custom credential by pasting the service account json key, then refresh the credential list configuration tab (trigger rules and output) this tab controls when the workflow starts and where the event payload is stored event type (required) all events (insert, update, delete) triggers on any change insert triggers when new rows are added update triggers when existing data is modified delete triggers when rows are removed filter column (optional) column header to filter by (example status) filter value (optional) exact value required in the filter column (example completed) if both filter fields are set, the trigger fires only when the affected row matches filter column = filter value output variable name (required) default sheettriggerresult this is the variable downstream nodes use to access the event payload