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.