Build scheduled AI-generated reports (data aggregation, Google Sheets, LLM summarization)

Description: We need someone to build automated, scheduled reports that pull data from multiple sources, filter/process it, and use an AI model to generate a clean, readable summary — delivered automatically on a set schedule (daily/weekly). Deliverables: A scheduled workflow that aggregates data from at least one external source AI-generated summary/report using an LLM, with reliable structured output parsing Formatted delivery (e.g., to a messaging platform or email) Graceful handling when a data source fails or the AI call doesn't return valid output Skills required: JavaScript Scheduled/cron-based automation LLM prompt engineering with structured (JSON) output Data filtering and relevance/recency logic API integrations (web data source + Google Sheets + delivery channel) How we work: We test with real data early, not just mocked examples Expect production-hardening: handle empty data, API failures, and malformed responses without crashing Scope: 1–3 months, Ongoing project, Intermediate–Expert Budget: [set based on your rates] Screening questions: Share an example of an automation you've built that pulls from an external data source and summarizes it with AI. How do you handle it when the AI's response doesn't come back in the format you expected?