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