Send weekly AI summaries of Google Sheets data via Gmail using OpenAI

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.