Generate Weekly Document Digests from Google Docs with GPT-4 and Email Delivery

📄 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 informed without manually digging through multiple documents.

⚙️ How It Works

Weekly Monday 9AM Trigger
A Cron node runs every Monday at 9 AM (adjustable).
Ensures summaries arrive at the start of the workweek.

Prepare Docs List
A Code node defines which Google Docs to monitor.
Includes doc IDs, names, and categories (e.g., Projects, Meetings, Updates).
Sets a 7-day date range for updates.

Fetch Google Docs & Metadata
Retrieves document content and metadata (last modified, user, version).
Filters only docs that have been updated in the past week.

Process Doc Data
Extracts plain text content from Google Docs.
Cleans and normalizes text for summarization.
Collects key details: word count, modified by, last updated date.

Aggregate Updated Docs
Gathers all updated docs into one combined content block.
Prepares context for the AI model to create a weekly digest.

Generate AI Summary
Uses GPT-4 to generate a business-style weekly summary.
Includes:
Executive summary
Key updates by document
Important changes
Action items
Next week’s focus

Prepare Email Content
Formats the AI response into both plain text and HTML email.
Adds a list of updated documents with last modified info.

Send Summary Email
Sends the final summary to the configured team emails via Gmail.
Subject line includes the date range for easy reference.

🛠️ Setup Steps

1. Google Docs Setup Add document IDs in the Prepare Docs List node.
   Enable the Google Drive API in your Google account.
   Connect Google OAuth credentials in n8n.

2. OpenAI API Key Get your key from platform.openai.com.
   Add it to your n8n credentials.
   Uses GPT-4 for high-quality summaries.

3. Email Recipients Update the Gmail node with your team’s email addresses.
   Customize the subject line and template if needed.

4. Schedule Default: Every Monday at 9 AM.
   Adjust the Cron node if you prefer a different time.

📧 Example Output

Subject: 📄 Weekly Document Updates Summary – 08/22/2025 – 08/29/2025

Body (excerpt):
Dear Team, Here's your weekly document updates summary:

Executive Summary:

Project Status Doc updated with new timelines. Meeting Notes highlight three key decisions from leadership. Team Updates document includes two new hires and onboarding tasks. Key Updates by Document: • Project Status Doc (Projects) - Updated by Alice on 08/27 • Meeting Notes (Meetings) - Updated by Bob on 08/28 • Team Updates (Updates) - Updated by Sarah on 08/29 Action Items:

Confirm revised project deadlines. Follow up on onboarding checklist. This summary was automatically generated by your n8n workflow.

⚡ With this workflow, you’ll never miss important document changes — your team gets a clear, AI-generated weekly digest straight in their inbox.