Enrich Google Sheets rows via any REST API in rate-limited batches

How it works

• Reads all rows from a Google Sheet
• Splits them into configurable batches (default: 5 rows per batch)
• Calls any external REST API once per row (GET or POST, Header Auth)
• Waits 1 second between batches to stay within API rate limits
• Routes responses: writes enriched data back to the sheet on success, logs errors on failure
• Loops through all batches until the full sheet is processed

Set up steps

• Takes ~10 minutes to configure
• Connect your Google Sheets OAuth2 credential to both Sheet nodes
• Set your Sheet ID and tab name in the Read Rows node
• Paste your API endpoint URL in the Call API node and connect your Header Auth credential
• Adjust batch size and wait duration via the sticky notes inside the workflow
• Update the Update Row node with the column(s) you want to write back