Generate weekly document digests from Google Docs with GPT-4 and email delivery
Needs changesWhat this workflow does
This workflow has 9 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Docs, Google Drive and Gmail.
How it runs
Trigger: On a schedule (legacy Cron node).
- Prepare Docs List (Code): runs custom JavaScript code
- Get Doc Content (Google Docs): get
- Get Doc Metadata (Google Drive): get
- Process Doc Data (Code): runs custom JavaScript code
- Aggregate Updated Docs (Code): runs custom JavaScript code
- Generate AI Summary (OpenAI): create (chat)
- Prepare Email Content (Code): runs custom JavaScript code
- Send Summary Email (Gmail): send
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in Weekly Monday 9AM Trigger: replace with Schedule Trigger.
- OpenAI (legacy) in Generate AI Summary: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Weekly Monday 9AM Trigger | Schedule Trigger |
| OpenAI (legacy) Generate AI Summary | OpenAI node (AI section) |
Nodes used (6)
- Cron
n8n-nodes-base.cron - Code
n8n-nodes-base.code - Google Docs
n8n-nodes-base.googleDocs - Google Drive
n8n-nodes-base.googleDrive - OpenAI
n8n-nodes-base.openAi - Gmail
n8n-nodes-base.gmail
From the author
📄 AI Summarize Weekly Google Docs Updates → Send Email This workflow automatically reviews selected Google Docs every week, checks for updates, and generates a professional weekly summary email using AI. It’s perfect for keeping your team or leadership…