π¬ Send weekly AI summaries of Google Sheets data via Gmail using OpenAI
β‘ 19 views Β· π¬ Document Extraction & Analysis
Description
How it works
- Runs automatically on a weekly schedule (every Monday at 9am by default).
- Reads all rows from a Google Sheets spreadsheet containing your data.
- Aggregates the data and sends it to OpenAI to generate a concise summary report.
- Formats the report with a date-stamped subject line.
- Emails the summary to your chosen recipient via Gmail.
- Logs every sent report to a separate spreadsheet for tracking.
Turn your raw spreadsheet data into a professional weekly digest without lifting a finger.
Setup steps
- Estimated setup time: 10 minutes
- Adjust the Schedule Trigger for your preferred day and time.
- Connect your Google Sheets account and set the data spreadsheet ID and sheet name.
- Connect your OpenAI API credentials.
- Set the recipient email address in the Send Report Email node.
- Connect your Gmail account for sending.
- Create a βReport Logβ sheet with columns: date, subject, sent_at.
- Activate the workflow.
π Nodes Used
Google Sheets, Gmail, Schedule Trigger, AI Agent, OpenAI Chat Model
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File