.png)
Every Monday at 8am, the business owner's inbox receives a full AI-written performance report —automatically.
Tools Used: n8n | Google Sheets | Groq API | LLaMA 3 | Gmail
Most small business owners track their numbers in spreadsheets, but rarely have time to analyse what those numbers actually mean. They're too busy running the business to review it.
This creates a dangerous pattern: decisions get made on gut feeling rather than data. Trends go unnoticed. Problems that could've been caught early compound over weeks.
FitCore Studio was tracking weekly KPIs—leads, new members, revenue, attendance, retention—in a Google Sheet. But the data sat unused because nobody had time to turn it into actionable insights each week.
I built a fully automated weekly reporting system that runs every Monday at 8am—no manual work required. It pulls the latest performance data from Google Sheets, sends it to an AI model for analysis, and delivers a beautifully formatted, branded report straight to the business owner's inbox.
Each report includes trend analysis, key highlights, concerns, and specific recommendations for the week ahead.
1. Schedule Trigger A schedule node fires automatically every Monday at 8:00am. The workflow wakes itself up—no manual triggering required.
2. Pull Weekly Data from Google Sheets The workflow connects to the "FitCore Studio—Weekly Performance" Google Sheet and reads all rows from the "Weekly Data" sheet. This captures historical weekly data including New Leads, Consultations Booked, New Members, Revenue (₦), Classes Held, Average Attendance, Cancellations, and Retention %.
3. Prepare Report Data—Code Node A JavaScript code node takes all rows from Google Sheets and builds a structured Groq API request. The prompt instructs the AI to write a professional report in plain text (no markdown) with clearly defined sections.
4. AI Report Generation via Groq Groq's LLaMA 3 model analyzes all weeks of data simultaneously and generates a full performance report covering: