Engineered an automated n8n workflow that runs daily to fetch, paginate, and process large datasets (500+ records across multiple pages) from external APIs without triggering rate limits (429 errors). The workflow performs date-math comparisons against previous periods, aggregates totals, writes the structured data to Google Sheets, and dispatches a summary report via Gmail.