AI-Powered Weekly Document Digest & Email Delivery - n8n Workflow

• Project Managers needing efficient weekly status updates without manually reviewing documents.


• Teams using Google Docs heavily for meeting notes, status reports, or technical documentation.


• Anyone looking for advanced examples of combining AI APIs with Google Workspace automation within an n8n workflow environment.

Keeping track of changes across numerous shared documents is a significant time sink for busy teams. This robust n8n workflow solves that problem by running a sophisticated, scheduled automation. The system monitors a defined list of Google Docs, pulls the content of only those documents modified in the last week, and aggregates the information. The powerful OpenAI n8n node (leveraging GPT-4) then processes this extensive data, distilling it into a concise, professional executive summary. This highly functional n8n template ensures that stakeholders receive a targeted, actionable weekly email digest, maximizing team efficiency and ensuring no crucial updates are missed. This advanced n8n automation eliminates manual review processes entirely.

The entire process is initiated by a robust n8n trigger, the Cron n8n node, which is set to run every Monday at 9 AM (UTC).

1. Trigger and Preparation: The initial n8n trigger fires. A dedicated Code n8n node ('Prepare Docs List') defines the list of Google Document IDs to monitor and calculates the exact 7-day period for checking updates.


2. Data Retrieval: For each document ID, the workflow concurrently uses the Google Docs n8n node to fetch the content and the Google Drive n8n node to retrieve metadata (specifically, the modifiedTime).


3. Filtering and Extraction: The 'Process Doc Data' Code n8n node is the flow control gate. It checks the modification time against the defined weekly window. If the document was not updated, it is discarded. If updated, the plain text is extracted and cleaned.


4. Aggregation: The 'Aggregate Updated Docs' Code n8n node collects all relevant content from the filtered documents and combines them into one large text item, perfectly formatted for the AI prompt.


5. AI Summarization: The core logic runs in the OpenAI n8n node. It sends the aggregated content to GPT-4 along with detailed instructions, requesting a structured business summary (Executive Summary, Action Items, etc.). This ensures high-quality output from the n8n workflow.


6. Email Finalization: The 'Prepare Email Content' Code n8n node formats the AI summary into a professional email, creating both plain text and HTML versions, along with a list of the documents that contributed to the summary.


7. Delivery: The Gmail n8n node sends the final weekly digest email to the predefined list of recipients, completing the automated n8n node sequence.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n template: Copy the provided JSON code and import it directly into your n8n instance.


2. Google Credentials: Set up OAuth2 credentials for both the Google Docs n8n node and the Google Drive n8n node. Ensure the connected account has read access to all target documents.


3. OpenAI API Key: Configure your OpenAI credential. Note that the workflow specifies the gpt-4 model for optimal summary quality, which requires access to that model.


4. Configure Document IDs: Open the 'Prepare Docs List' Code n8n node and replace the placeholder document IDs (DOCID1_HERE, etc.) with the actual IDs of the Google Docs you wish to monitor.


5. Set Recipients: Update the 'Send Summary Email' Gmail n8n node with the correct recipient email addresses.


6. Activate: Save and activate the n8n workflow. It will run automatically based on the Cron n8n trigger schedule.

Weekly Monday 9AM Trigger (Cron n8n trigger):
Function: Serves as the primary n8n trigger, scheduling the entire operation to run reliably every Monday morning.
Key Configuration: Uses the cron expression 0 9 1.
Prepare Docs List (Code n8n node):
Function: Defines which Google Docs should be monitored and calculates the exact start and end timestamps for the weekly review period.
Get Doc Content (Google Docs n8n node):
Function: Retrieves the full content of the specified Google Document using an expression based on the data passed by the previous n8n node.
Process Doc Data (Code n8n node):
Function: Filters out documents that have not been modified in the last week and performs data manipulation to clean and extract the raw text content for AI processing.
Aggregate Updated Docs (Code n8n node):
Function: Collects all items that passed the filter and concatenates their content into a single prompt string for the AI.
Generate AI Summary (OpenAI n8n node):
Function: Sends the combined document content to the gpt-4 model with a precise system and user prompt to generate a structured, executive-level weekly summary. This is the core intelligence of the n8n workflow.
Send Summary Email (Gmail n8n node):
* Function: Sends the final, formatted AI-generated digest email to the required stakeholders, concluding the execution of this powerful n8n template.