Automation + Python Script: Gmail → Claude AI → Google Sheets Pipeline

I need a specialist to build 4 automation scenarios + a standalone Python backfill script.
THE 5 COMPONENTS:
A. Email text extraction (Gmail → Claude API → Google Sheets) — auto, with content classification routing to 14 sheet tabs
B. Image processing (Google Drive → Claude Vision → Sheets) — auto
D. Daily price feed (Yahoo Finance → Sheets) — auto
E. Heartbeat monitor — auto
Python script: Historical backfill of 5,751 emails from .mbox export (reusable)
KEY REQUIREMENTS:
Strong experience (scenarios, routers, HTTP, JSON, iterators, error handling)
Python scripting (email parsing, API integration, Google Sheets API)
External API integration (Claude API, Yahoo Finance)
Google Sheets API (conditional formatting, VLOOKUP)
AI/LLM API experience a plus
Available 2-3 weeks
I PROVIDE:
Complete technical spec (20 sections), sample data, API keys, Sheet template.
DELIVERABLES:
4 scenarios, reusable Python backfill script, 14-tab Google Sheet...