AI Google Doc Summarizer & GSheets Logger Agent

Unlock Automated Document Insights with this AI Agent

Never let key information get lost in lengthy documents again. This AI-driven workflow monitors your Google Drive for new Google Docs, intelligently extracts their content, generates concise summaries using OpenAI's powerful language models, and then neatly organizes these summaries along with document metadata (like the last modifying user's name and email) into a designated Google Sheet. It's an AI Agent with a core ability in document summarization and data logging.

Key Features & Benefits

• Automated Document Ingestion: Triggers automatically when new Google Docs are added to a specific Google Drive folder.
• AI-Powered Summarization: Leverages OpenAI (e.g., GPT-4o-mini) to generate accurate and concise summaries of document content.
• Metadata Extraction: Captures key details like the document's last modifying user and their email address.
• Centralized Logging: Stores summaries and metadata directly into a Google Sheet for easy access, review, and team collaboration.
• Enhanced Productivity: Saves significant time by automating the manual process of reading, summarizing, and cataloging documents.
• Extensible AI Capabilities: The underlying AI model can access tools like Wikipedia and a Calculator for potentially richer context understanding during summarization (powered by Langchain).
• Customizable: Easily adapt the watched folder, AI model, summarization prompt, and Google Sheet destination to fit your specific needs.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a suitable model (e.g., gpt-4o-mini).
• Google Cloud Platform account with:
  • Google Drive API enabled.
  • Google Docs API enabled.
  • Google Sheets API enabled.
• Google Service Account credentials for n8n to access Google Drive and Google Docs (recommended for server-to-server interaction).
• Google OAuth2 credentials for n8n to access Google Sheets.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Google Drive ' Trigger node:
   • Set up 'Google API' credentials using your Service Account JSON key.
   • In 'Folder To Watch', select the Google Drive folder you want to monitor for new .gdoc files.
4. Configure the 'Google Docs' node:
   • Ensure the 'Google API' credentials (Service Account) are correctly configured (usually inherits from the trigger if using the same credential name).
5. Configure the 'Generate Summary AI' (OpenAI) node:
   • Select or create your OpenAI credentials using your API Key.
   • Verify the 'Model ID' (e.g., gpt-4o-mini) is selected.
   • The default prompt Summarise the below content\n {{ $json.content }} is set. You can customize it under Messages > values > content if needed.
6. Configure the 'Google Sheets' node:
   • Select or create your 'Google Sheets OAuth2 API' credentials.
   • Enter the 'Document ID' of the Google Sheet where summaries will be stored.
   • Select the 'Sheet Name' (e.g., Sheet1).
   • Under 'Columns', ensure the mapping is correct. It should be pre-filled to map:
     • Name: ={{ $('Google Drive ').item.json.lastModifyingUser.displayName }}
     • Email : ={{ $('Google Drive ').item.json.lastModifyingUser.emailAddress }}
     • Summarise Conetent data : ={{ $json.message.content }}
   • Adjust column names or expressions as needed to match your sheet.
7. Ensure all credentials are correctly set and test each node individually if possible.
8. Activate the workflow.