节点 / builtin / trigger
New row
Start the workflow when rows are added at the bottom of a Google Sheet
此内容尚不支持你的语言。
Start the workflow when rows are added at the bottom of a Google Sheet.
What it does
Section titled “What it does”Every Check every minutes, the trigger reads the sheet and starts one run with the rows added since the last check. It watches the bottom of the sheet: edits to existing rows don’t count. When rows are deleted, it starts again from the new bottom, with a warning, and never replays old rows.
A check that finds nothing new starts no run. Press Run to fetch a test event: the latest items, without moving the trigger’s position.
When to use it
Section titled “When to use it”- A form that writes to a sheet: act on each new answer.
- A shared sheet of leads: add each new lead to your CRM.
Inputs and settings
Section titled “Inputs and settings”| 设置项 | 类型 | 作用 |
|---|---|---|
| Connection (必填) | Credential | |
| Spreadsheet (必填) | One of several shapes | Paste its link or ID. |
| Worksheet ID | Text | The gid in the link; empty = the first sheet. |
| Check every | Number | At least 1 minute, only while the workflow is On. 默认值:5 |
| On the first check | Choice | Options: Skip what’s already there, Start with the latest. 默认值:Skip what’s already there |
| How many to start with | Number | For “Start with the latest” and Fetch test event (1–20). 默认值:3 |
Spreadsheet takes the sheet’s link or ID. Worksheet ID is the gid number in the link; leave it empty for the first sheet.
Outputs
Section titled “Outputs”-
Output
One item per new row, keyed by the header row.
Dependencies and credentials
Section titled “Dependencies and credentials”- Connection (connection, OAuth2): required. See Create a connection.
Example workflow
Section titled “Example workflow”- New row on a Signups sheet.
- Gmail sends a welcome email to
{{ $input.email }}.
Common issues
Section titled “Common issues”- “Choose a spreadsheet first.”: paste the spreadsheet’s link in Spreadsheet.
- An edited row didn’t start a run: only added rows count.
Related nodes
Section titled “Related nodes”- Polling triggers: how every “New …” trigger checks.
- Google Sheets: read and write rows.
- Schedule Trigger: run at fixed times instead.