Skip to main content

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

Workflow preview

Send weekly AI summaries of Google Sheets data via Gmail using OpenAI preview
Open on n8n.io

Overview

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.