Google Drive to Google Sheets Document Summarizer
detail.loadingPreview
Automates Google Drive file summarization and storage in Google Sheets.
About This Workflow
This workflow automates the process of fetching the latest document from a specified Google Drive folder, summarizing its content using an AI model, and then storing the summary along with relevant metadata in a Google Sheet. It's designed to streamline document management and information extraction.
Key Features
- Google Drive Trigger: Monitors a specific folder for new file creations.
- Google Docs Integration: Retrieves content from newly added Google Docs.
- AI-Powered Summarization: Utilizes OpenAI (GPT-4o-mini) to generate concise summaries.
- Google Sheets Output: Appends the summarized content and metadata to a designated Google Sheet.
- Metadata Inclusion: Captures user details (display name, email) and summary content.
How To Use
- Configure Google Drive Trigger: Set up the
Google Drivenode to watch a specific folder for new files. - Retrieve Document Content: The
Google Docsnode fetches the content of the newly created document. - Generate Summary: The
Generate Summary AInode uses the document content to create a summary via OpenAI. - Store in Google Sheets: The
Google Sheetsnode appends the generated summary and relevant user metadata to your specified Google Sheet.
Apps Used
Workflow JSON
{
"id": "0eab8d56-f3b2-498c-ae40-0deb12618575",
"name": "Google Drive to Google Sheets Document Summarizer",
"nodes": 21,
"category": "Document Management",
"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: 0eab8d56-f3b2...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
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.
Automate Local Business Outreach with AI-Powered Yelp Scraper
This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.