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 1. **Weekly Monday 9 AM 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](https://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:** AI 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.