📄 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

1. Weekly Monday 9AM Trigger

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

2. 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.

3. Fetch Google Docs & Metadata

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

4. 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.

5. Aggregate Updated Docs

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

6. 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

7. Prepare Email Content

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

8. 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.