Make Google Sheets "Watch New Rows" not picking up new rows

说明与用途

在 Make.com 场景中，Watch New Rows 触发器因空行、错误工作表、起始点错误或行操作而无法检测新行。删除空行、修正工作表和标题设置、重置起始点并将表视为仅追加，可确保可靠检测并一次性处理新行。

问题

The Make.com Google Sheets Watch New Rows trigger fails to detect new rows when a blank row exists above them, the wrong tab or header row is selected, the start point is past the new rows, or rows are inserted, sorted or deleted.

结果

After cleaning the sheet, correcting trigger settings, and treating the tab as append‑only, the Watch New Rows trigger reliably captures new rows and processes them once.

工作流

• Check that the trigger points to the correct spreadsheet and sheet name.
• Verify that the sheet contains headers and set the header row range if not in row 1.
• Remove any blank rows between headers and data.
• Reset the trigger’s "Choose where to start" to a point before the first unprocessed row and run once.
• Treat the watched tab as an append‑only log; sort data on a separate tab if needed.
• Add a filter after the trigger to ensure only rows with a key column value exist.
• If using formulas that fill entire columns, limit them to rows with data or move them to a separate tab.
• Use Search Rows on a schedule with a status column for hand‑typed sheets if needed.
• Ensure the scenario is on and the schedule and limit settings are appropriate.
• Optionally, use an Apps Script installable trigger to send new rows to a Make custom webhook for instant processing.

证据

Make's documentation for Watch New Rows says: if a sheet contains a blank row, Make doesn't process the rows after it.

来源

Make checks the sheet on the scenario's schedule (e.g. every 15 minutes) and returns new rows, up to the Limit you set.

来源

Reset "Choose where to start" to a point before the first unprocessed row, save, and click Run once.

来源