Send weekly AI summaries of Google Sheets data via Gmail using OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail
What it does
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, sentat. - Activate the workflow.