Automate Google Doc Summaries to Google Sheets
detail.loadingPreview
Streamline your document management by automatically summarizing new Google Docs and storing them in Google Sheets. This workflow saves you time and effort in extracting key information.
About This Workflow
This n8n workflow, developed by WeblineIndia, automates the process of handling new Google Docs. It's designed to monitor a specific Google Drive folder for newly created documents. Upon detection, it retrieves the document's content, utilizes an AI model (OpenAI GPT-4o-mini) to generate a concise summary, and then appends this summary, along with the document's author and modification details, to a designated Google Sheet. This ensures that valuable insights from your documents are readily available and organized.
Key Features
- Automatic Google Drive Monitoring: Detects newly created Google Docs in a specified folder.
- AI-Powered Summarization: Leverages OpenAI to condense document content into key takeaways.
- Seamless Google Sheets Integration: Appends summarized data and relevant metadata to your spreadsheets.
- Customizable Data Mapping: Easily define which information is stored in your Google Sheet.
How To Use
- Google Drive Trigger: Configure the
Google Drive Triggernode to watch a specific folder forfileCreatedevents. Ensure your Google Drive account is authenticated. - Google Docs Node: Connect the
Google Docsnode to retrieve the content of the newly created document. Use the dynamicdocumentURLparameter to link it to the output of the Google Drive trigger. - OpenAI Node: Set up the
Generate Summary AInode with your desired OpenAI model (e.g.,gpt-4o-mini). Configure themessagesparameter to prompt the AI to summarize the content retrieved from the Google Docs node. - Google Sheets Node: Configure the
Google Sheetsnode toappenddata. Define thedocumentIdandsheetNamefor your target spreadsheet. Map the output from the AI summary and the Google Drive trigger (for author details) to the desired columns in your Google Sheet.
Apps Used
Workflow JSON
{
"id": "126893ca-613e-46e5-b8aa-b88b4dbacf4d",
"name": "Automate Google Doc Summaries to Google Sheets",
"nodes": 19,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 126893ca-613e...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.