Google Sheets Trigger¶
Node: googleSheetsTrigger · Full type: n8n-nodes-base.googleSheetsTrigger · Version: 1
Ergonomic keyword available:
TRIGGER gsheets_update— see NFLOW.md for shorter syntax.
Credentials¶
googleSheetsTriggerOAuth2Api (alias: @google)
Parameters¶
| Parameter | Type | Default | Details |
|---|---|---|---|
pollTimes |
fixedCollection | {...} | groups: item |
documentId |
resourceLocator | {...} | required; modes: list, url, id |
sheetName |
resourceLocator | {...} | required; modes: list, url, id |
event |
options | "anyUpdate" | required; rowAdded, rowUpdate, anyUpdate |
includeInOutput |
options | "new" | new, old, both |
options |
collection | {} | keys: columnsToWatch, dataLocationOnSheet, valueRender, dateTimeRenderOption |
pollTimes children:
item group:
| Parameter | Type | Default | Details |
|---|---|---|---|
mode |
options | "everyDay" | everyMinute, everyHour, everyDay, everyWeek, everyMonth, everyX, custom |
hour |
number | 14 | |
minute |
number | 0 | |
dayOfMonth |
number | 1 | |
weekday |
options | "1" | 1, 2, 3, 4, 5, 6, 0 |
cronExpression |
string | " * * * * " | |
value |
number | 2 | |
unit |
options | "hours" | minutes, hours |
options children:
| Parameter | Type | Default | Details |
|---|---|---|---|
columnsToWatch |
multiOptions | [] | |
dataLocationOnSheet |
fixedCollection | {...} | groups: values |
valueRender |
options | "UNFORMATTED_VALUE" | UNFORMATTED_VALUE, FORMATTED_VALUE, FORMULA |
dateTimeRenderOption |
options | "SERIAL_NUMBER" | SERIAL_NUMBER, FORMATTED_STRING |