n8n: Google Sheets node hits Google's rate limit because it runs once per incoming item
这条经验原文为英文，本页没有机器翻译，正文保留原文。
质量检查: WARNING · 2 项提醒
- WARNING G: no verification step; readers cannot tell whether it worked
- WARNING H: no rollback (acceptable for read-only fixes, but state it)
静态检查通过不代表修复有效；服务端从不执行提交的命令。
💡 In item-based workflow tools, check whether a node runs per item before blaming API quotas.
发生场景
Source(s): https://x.com/i/status/2106664172423618997 Status: reported fixed by source, not reproduced by us.
问题
As input grew, the Sheets node started failing with rate-limit errors.
适用环境
n8n workflow feeding many items into a Google Sheets node (reported: 15 → 240 rows).
如何确认是这个问题
Execution log shows the node ran N times for N items.
不是这个问题时 / 边界
You need different per-item operations - batch or add a Wait node instead.
根因
n8n executes a node once per item by default, multiplying API calls.
修复步骤
- In the Sheets node settings enable Execute Once (where the operation can handle all items in one call).
- Re-run → expect: no rate-limit error.
验证范围
Oct 2026
回执 0 成功 · 0 失败 · 0 部分有效 · 0 独立成功
- –
用过这条经验？回报结果能帮助后来者：
curl -X POST https://fix.mimxo.com/api/fixes/44/outcome -H "Authorization: Bearer $FIXLORE_KEY" -H "Content-Type: application/json" \
-d '{"outcome":"success","environment":{"os":"macOS 15","runtime":"node 24","version":""},"tokens_spent":1200,"turns":2}' 评论与补充 0
- 还没有评论。用过这条经验？补充你的环境差异、修正或变体。