Automated Google Doc Summarization and Sheet Logging - n8n Workflow

• Teams who handle large volumes of documents uploaded daily and need quick summaries.


• Managers seeking automated reports on recently added documents and their content.


• Automation Engineers looking for robust n8n templates integrating Google services with AI.


• Users who need a seamless, non-manual method for creating a document knowledge log.

Managing vast repositories of documents in Google Drive can be time-consuming, especially when needing to quickly grasp the core content of new files. This advanced n8n workflow solves this by providing a hands-free solution that leverages artificial intelligence. By using a Google Drive n8n trigger, the system constantly monitors a specific folder for new uploads. Once detected, the document content is automatically fetched and passed to the OpenAI n8n node, which generates a concise summary using the highly capable GPT-4o-mini model. Finally, the summary, along with crucial metadata like the uploader’s name and email, is logged into a structured Google Sheet. This makes the summarized data immediately accessible for reporting and analysis. This specific n8n templates showcases the power of combining cloud storage operations with cutting-edge AI for business efficiency.

This automation begins with the dedicated Google Drive n8n trigger.

1. Trigger on Upload: The Google Drive n8n trigger is configured to watch a specified folder. When a file creation event occurs, the n8n workflow is initiated.


2. Retrieve Content: The output of the trigger, specifically the document ID ($json.id), is passed to the Google Docs n8n node. This node uses the ID to retrieve the full textual content of the newly uploaded document.


3. Generate AI Summary: The retrieved content is routed to the Generate Summary AI n8n node (an OpenAI LLM integration). This n8n node utilizes a defined prompt (Summarise the below content...) and the GPT-4o-mini model to condense the input text into a concise summary.


4. Log to Google Sheets: The final step involves the Google Sheets n8n node, which uses the 'Append' operation. It collects data from multiple upstream nodes to create a new row in the target spreadsheet. It captures the uploader’s Name and Email (from the initial Google Drive trigger data) and the AI-generated summary (from the Generate Summary AI n8n node) and logs them, completing the automated process. This structure is essential for robust n8n workflow development.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and import it directly into your n8n instance under the Workflows section. This provides you with the basic n8n templates structure.


2. Credentials Setup: You must configure credentials for the following services:

1. Configure Trigger: In the Google Drive n8n trigger, specify the URL or ID of the folder you wish to monitor.


2. Configure Google Sheets: In the Google Sheets n8n node, specify the Document ID and the Sheet Name where the summaries should be logged.


3. Activate: Save the n8n workflow and ensure the trigger is active so the automation can start monitoring for new files.

Google Drive (n8n trigger):
Function: Starts the n8n workflow whenever a new file is created in a designated folder, providing key metadata like file ID and user details.
Key Configuration: Event set to fileCreated, Trigger On set to specificFolder.
Google Docs (n8n node):
Function: Retrieves the actual text content from the document identified by the trigger.
Key Configuration: Operation is get. Uses an expression ={{ $json.id }} to dynamically fetch the document URL/ID from the preceding n8n node.
Generate Summary AI (OpenAI n8n node):
Function: The central AI component. It takes the retrieved document text and processes it using GPT-4o-mini to produce a summary.
Key Configuration: Model set to gpt-4o-mini. The prompt is configured using an expression to include the full document content for summarization.
Google Sheets (n8n node):
Function: Appends the final summary and collected metadata (Name, Email) to a specific row in a Google Sheet for logging and tracking.
Key Configuration: Operation set to append. Columns are explicitly mapped using data from the Google Drive n8n trigger and the Generate Summary AI n8n node output.