You are helping me build the following AI agent workflow. ## Goal Zoho to Supabase Product Sync: Scheduled sync pulls Zoho Inventory products and variants into Supabase, mapping SKUs, stock levels. ## Specification - What it does: Keep your Supabase database up to date with fresh inventory from Zoho Inventory on a schedule. You get accurate stock levels, dimensions, and custom attributes for every product variant mapped directly into your target table without manual entry. - Trigger: On a schedule (Scheduled ยท daily) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Zoho Inventory: Source inventory data via API - HTTP Request: Fetch product metadata and variants - Supabase: Store synced product data in database ## Known pitfalls, handle each one explicitly in your implementation 1. Zoho API rate limits can block the run, so add exponential backoff logic to retry requests after a delay. 2. Supabase row-level security policies might reject inserts if the service role key is not used correctly, verify permissions in the Supabase dashboard. 3. Data type mismatches between Zoho strings and Supabase integers will cause insert failures, enforce explicit type casting during mapping. 4. Duplicate SKUs can create conflicting records in Supabase, use upsert operations to handle existing product updates gracefully. ## Reference implementation https://n8n.io/workflows/5503 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/zoho-to-supabase-product-sync/ via usecasesforagents.com