Fix Google Sheets 429 quota exceeded in Duaer

What the error looks like in Duaer

• The service is receiving too many requests from you
• Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' (Write requests when writing)

The Google Sheets API allows 300 read and 300 write requests per minute per project, and 60 each per user. When Duaer calls the API once per item, a few dozen items hit the limit.

Fix it in Duaer

1. Make fewer calls: one Google Sheets node with many items writes them together with Append Row. Avoid a lookup node before every item.
2. When you must go item by item, add Loop Over Items with Batch Size 50 and a Wait of 60 seconds inside the loop.
3. In Duaer, open the failing node, switch to Settings, turn on Retry On Fail, set Max. Tries to 3–5 and Wait Between Tries (ms) to 5000.
4. When you look up the same sheet many times, read it once and match in memory with Merge or an expression.