Gmail and Google Drive integration

This workflow automates document summarization directly from Google Drive, processes the content using Mistral AI, and delivers a clean, styled summary via Gmail. It's ideal for professionals who need quick insights from lengthy documents without manually reading through them. ✅ Key Features: Google Drive Integration: Fetches a file (PDF/DOCX) from your Drive. AI Summarization: Uses Mistral AI to extract key points efficiently. Styled Email Output: Delivers a formatted, easy-to-read summary to your inbox with a timestamp. Error Handling: Built to skip corrupted files or missing credentials. 🔧 Nodes Breakdown: 1️⃣ Manual Trigger — Starts the workflow manually for easy testing. 2️⃣ Google Drive Node — Downloads a specified file from Google Drive (supports PDF/DOCX). 3️⃣ Mistral Cloud Chat Model Node — Connects to Mistral AI for summarization. 4️⃣ Summarization Chain Node — Breaks the file into chunks, processes content, and generates a concise summary. 5️⃣ Gmail Node — Sends the styled summary directly to the user’s inbox, with custom formatting and current time in the Lagos timezone. Extra Features: Dynamic Time Formatting: Supports Lagos timezone (easily adjustable). HTML Styling: Beautiful email formatting with headers, icons, and line breaks for clarity. Custom Email Sender Name: Branded output (e.g., "Swot.AI"). Future Expansion: Can extend to WhatsApp or Slack with minor tweaks. Use Cases: Legal teams summarizing contracts. Content creators extracting highlights from research papers. Business analysts getting insights from reports on-the-go. Customization Tips: Change the timezone (Africa/Lagos) to match your preferred location. Add error-handling nodes for missing files or API failures. Swap Mistral AI with OpenAI for different summarization behavior. Why To Use This Workflow? This automation saves hours of manual reading. It’s perfect for personal productivity, legal analysis, content creation, or business reporting. With clean formatting and a professional email summary — your team will get instant insights in seconds!

Intelligent Email Support System with Vector Database Overview This n8n workflow automates email support using AI and vector database technology to provide smart, context-aware responses. It seamlessly integrates email automation and document management, ensuring efficient customer support. 📌 System Components ✉️ Email Support System Email Monitoring & Classification Gmail trigger node monitoring inbox AI-powered email classification Intelligent routing (support vs non-support inquiries) AI Response Generation LangChain agent for response automation OpenAI integration for NLP-driven replies Vector-based knowledge retrieval Automated draft creation in Gmail Vector Database System Supabase vector store for document management OpenAI embeddings for vector conversion Fast and efficient similarity search 📂 Document Management System Google Drive Integration Monitors specific folders for new/updated files Automatic document processing Supports various file formats Document Processing Pipeline Auto file download & text extraction Smart text chunking for better indexing Embedding generation via OpenAI Storage in Supabase vector database 🔄 Workflow Processes 📧 Email Support Flow Monitor Gmail inbox for new emails AI classification of incoming messages Route support emails to AI response generator Perform vector similarity search for knowledge retrieval Generate personalized AI-driven response Create email drafts in Gmail 📁 Document Management Flow Monitor Google Drive for new/updated files Auto-download and process documents Clean up outdated vector entries for updated files Extract and split document text efficiently Generate OpenAI embeddings Store processed data in Supabase vector DB ⚙️ Setup Instructions 1️⃣ Prerequisites Supabase** account & project OpenAI API key** Gmail account** with OAuth2 setup Google Drive API** access n8n installation** 2️⃣ Supabase Database Setup -- Create the vector extension create extension if not exists vector; -- Create the documents table create table documents ( id bigserial primary key, content text, metadata jsonb, embedding vector(1536) ); -- Create an index for similarity search create index on documents using ivfflat (embedding vector_cosine_ops) with (lists = 100); 3️⃣ Google Drive Setup Create & configure two monitored folders: RAG folder for new documents documents Assign correct folder permissions Add folder IDs to the workflow 4️⃣ Document Processing Configuration Set up triggers for file creation and file updates Configure text extraction: Define chunk size & overlap settings Set document metadata processing 🔍 Maintenance & Optimization 📌 Regular Tasks Monitor system performance Update the knowledge base regularly Review AI response quality Optimize vector search parameters Clean up outdated document embeddings ✅ Best Practices Document Organization Maintain structured folders & naming conventions Keep knowledge base content updated System Optimization Track AI classification accuracy Tune response times & chunk sizes Perform regular database maintenance 🛠️ Troubleshooting Email Issues Verify Gmail API credentials Check AI service uptime Monitor classification performance Document Processing Issues Ensure correct file permissions Validate extraction & embedding processes Debug vector database insertions

Personal Portfolio CV Rag Chatbot - with Conversation Store and Email Summary Target Audience This template is perfect for: Individuals looking to create a working professional and interactive personal portfolio chatbot. Developers interested in integrating RAG Chatbot functionality with conversation storage. Description Create a stunning Personal Portfolio CV with integrated RAG Chatbot capabilities, including conversation storage and daily email summaries. 2.Features: Training: Setup Ingestion stage Upload your CV to Google Drive and let the Drive trigger updates to read your resume cv and convert it into your vector database (RAG purpose). Modify any parts as needed. Chat & Track: Use any frontend/backend interface to call the chat API and chat history API. Reporting Daily Chat Conversations: Receive daily automatic summaries of chat conversations. Data stored via NocoDB. 3.Setup Guide: Step-by-Step Instructions: Ensure all credentials are ready. Follow the notes provided. Ingestion: Upload your CV to Google Drive. The Drive triggers RAG update in your vector database. You can change the folder name, files and indexname of the vector database accordingly. Chat: Use any frontend/backend interface to call the chat API (refer to the notes for details) . [optional] Use any frontend/backend interface to call the update chat history API (refer to the notes for details). 3.Tracking Chat: Get daily automatic summaries of chat conversations.Format email conversations report as you like. You are ready to go!

🎦🚀 YouTube Video Comment Analysis Agent This n8n workflow is designed to help YouTube creators analyze video details and comments to generate a comprehensive and actionable report. The workflow provides insights into video performance, audience engagement, and viewer feedback, helping creators identify trends, interests, and opportunities for future content creation. ✨ Key Features Video Performance Analysis: Extracts metrics like views, likes, and comments to evaluate the video's success. Comment Sentiment Analysis: Determines the tone of comments (positive, neutral, or negative) to understand audience sentiment. Recurring Themes Detection: Identifies common topics or questions in comments to highlight viewer interests. Engagement Drivers: Pinpoints what aspects of the video resonated most with viewers. Actionable Recommendations: Offers strategies for creating follow-up content or improving future videos. Keyword Suggestions: Extracts frequently mentioned terms for better discoverability on YouTube. Collaboration Opportunities: Suggests potential partnerships based on viewer feedback or related channels. 🛠️ How to Use Set Up Workflow Variables: Add your GOOGLE_API_KEY and the VIDEO_ID of the YouTube video you want to analyze in the "Workflow Variables" node. Ensure your Google API key has access to the YouTube Data API. Run the Workflow: Trigger the workflow manually or through another workflow using the "Execute Workflow Trigger" node. The workflow will fetch video details and comments using pagination to ensure all data is captured. Generate Insights: The workflow processes video details and comments to create a detailed report with actionable insights. Outputs include sentiment analysis, engagement drivers, content opportunities, and audience profiling. View or Share Results: The report is converted into Markdown and can be emailed via Gmail or saved to Google Drive as a document. 🌟 Value from This Workflow Gain a deeper understanding of your audience's preferences and feedback. Identify trends and engagement drivers to replicate success in future videos. Discover new content opportunities based on viewer questions and suggestions. Improve discoverability by leveraging keyword suggestions extracted from comments. Build stronger connections with your audience by addressing their needs effectively.

This n8n workflow is designed to automate the aggregation, processing, and reporting of community statistics related to n8n creators and workflows. Its primary purpose is to generate insightful reports that highlight top contributors, popular workflows, and key trends within the n8n ecosystem. Here's how it works and why it's important: How It Works Data Retrieval: The workflow fetches JSON data files from a GitHub repository containing statistics about creators and workflows. It uses HTTP requests to access these files dynamically based on pre-defined global variables. Data Processing: The data is parsed into separate streams for creators and workflows. It processes the data to identify key metrics such as unique weekly and monthly inserters/visitors. Ranking and Filtering: The workflow sorts creators by their weekly inserts and workflows by their popularity. It selects the top 10 creators and top 50 workflows for detailed analysis. Report Generation: Using AI tools like GPT-4 or Google Gemini, the workflow generates a Markdown report summarizing trends, contributors, and workflow statistics. The report includes tables with detailed metrics (e.g., unique visitors, inserters) and insights into why certain workflows are popular. Distribution: The report is saved locally or uploaded to Google Drive. It can also be shared via email or Telegram for broader accessibility. Automation: A schedule trigger ensures the workflow runs daily or as needed, keeping the reports up-to-date. Why It's Important Community Insights**: This workflow provides actionable insights into the n8n community by identifying impactful contributors and popular workflows. This fosters collaboration and innovation within the ecosystem. Time Efficiency**: By automating data collection, processing, and reporting, it saves significant time and effort for community managers or administrators. Recognition of Contributors**: Highlighting top creators encourages engagement and recognizes individuals driving value in the community. Trend Analysis**: The workflow helps uncover patterns in usage, enabling better decision-making for platform improvements or feature prioritization. Scalability**: With its modular design, this workflow can be easily adapted to include additional metrics or integrate with other tools.

Transcript Evalu8r – AI-Powered Transcribing and Transcript Analysis Workflow Overview Transcript Evalu8r is an AI-powered transcript analysis workflow that automates the processing, visualization, and evaluation of transcribed conversations. This n8n workflow template is designed to help users quickly analyze sentiment, extract topics and intents, generate key insights, and enhance transcript navigation. It is ideal for customer service teams, legal professionals, researchers, content creators, and businesses seeking actionable intelligence from recorded conversations. Key Features 🔹 Automated Transcript Processing Audio-to-Text Conversion** – Upload an audio file and generate transcripts. File Upload Management** – Track file uploads with real-time progress indicators. Transcript Selection** – Browse and select previously analyzed transcripts from a dropdown. Download Transcripts* – Export transcripts in various formats (Google Docs and JSON*). Error Handling** – Detects and alerts users about upload or processing failures. 🔹 Advanced UI Components Interactive Transcript Viewer** – Displays full transcripts with: Timestamps and speaker identification. Clickable words for easy navigation. Auto-scrolling to highlight the active portion of the transcript. Key Points & Action Items Summary** – AI extracts: Critical insights from conversations. Actionable follow-ups detected in the discussion. Speaker Labeling* – Dynamically assigns real speaker names* instead of generic placeholders (e.g., "Speaker 1"). Collapsible Sections* – Enables users to expand/collapse* transcript details, key insights, and analysis sections. 🔹 AI-Powered Conversation Analysis Sentiment Analysis & Visualization** Dynamic sentiment graph tracks emotional shifts. Color-coded speaker sentiment tracking: 🔵 Positive ⚫ Neutral 🔴 Negative Time-based sentiment tracking – Shows sentiment fluctuations across the conversation. Topic & Intent Recognition** Automated Topic Extraction – Identifies key themes discussed. Hierarchical Topic Organization – Groups related topics for structured insights. Intent Classification – Recognizes whether statements reflect: Questioning Commands Decision-making Information seeking Confidence Scoring – Displays confidence levels for topic and intent detection. Speaker Contribution Metrics** Talk-time percentages per speaker. Interruption detection – Highlights moments where speakers cut each other off. Word Frequency Analysis – Identifies commonly used terms and phrases. 🔹 Seamless Workflow Automation API Integration* – Connects with transcription engines like OpenAI Whisper, AWS Transcribe, and Deepgram*. Webhook Support** – Automates workflows when new transcripts are available. Batch Processing* – Handles multiple transcript analyses* simultaneously. Export & Reporting** – Sends insights to Google Sheets, Notion, Airtable, or Slack. How It Works Upload an audio file or select a pre-existing transcript. Transcript Processing: Speech-to-text conversion (if required). AI-driven sentiment, topic, and intent analysis. Visualizations & Insights: Review sentiment charts, speaker contributions, and key topics. Extract action items and critical takeaways. Download results or trigger automated follow-ups. Use Cases ✅ Customer Support Review – Detect customer concerns and analyze sentiment trends. ✅ Podcast & Video Content Analysis – Summarize episodes and extract key themes. ✅ Sales Call Insights – Identify common objections and customer pain points. ✅ Market Research – Extract trends from focus groups and discussions. ✅ Legal Compliance Monitoring – Track policy violations in recorded conversations. Setup Instructions Import the Transcript Evalu8r workflow into your n8n instance. Connect DeepGram Speech to Text API. Configure workflow parameters (sentiment thresholds, topic extraction settings). Run the workflow to analyze and visualize transcript data. Review insights and export as needed. Why Use Transcript Evalu8r? 🚀 Automate tedious transcript analysis 💡 Unlock hidden insights in conversations 📊 Visualize conversations with interactive sentiment tracking ⚡ Boost efficiency with AI-powered automation 🔗 Seamlessly integrate with your existing workflows Requirements n8n instance** (cloud or self-hosted) API key for DeegGram API

Summary This template uses the item handling nodes, and expression-support in n8n, without using a Code node, to extract multiple attachments from a GMail (trigger input) message/event, and (conditionally) upload each of them to Google Drive. Note: There is another template titled Get Multiple Attachments from Gmail and upload them to GDrive that does basically the same thing, but it uses a Code node. Details Using Split Out instead of Code The “secret” to how this works is that n8n supports a special input field name $binary that references the entire set of (multiple) binary data sub-elements in a single input item. It may look like an expression, but in this case it is a “fixed” (literal) value used as the Fields to Split Out parameter value. Dealing with names that are prefixed/suffixed with an Index The next challenge with multiple attachments from a GMail message is that each one is still assigned different name like "attachment_0", "attachment_1", etc. This makes it tricky to reference them in a generic way. However, once n8n splits the items out, the binary in each item is always the first (i.e. index-zero / [0]) and ONLY key/value. So, that makes it possible get the key-name and attributes of the corresponding value indirectly with some clever expression syntax. Input Data Field Name -> Expression: {{ $binary.keys()[0] }} - This returns the name, regardless of whether it is "attachment_0", "attachment_1", or whatever else. Attachment file name: -> Expression: {{ $binary.values()[0].fileName }} Attachment file name extension: -> Expression: {{ $binary.values()[0].fileExtension }} Attachment file type: -> Expression: {{ $binary.values()[0].fileType }} Attachment file size (e.g. string "100 kB"): -> Expression: {{ $binary.values()[0].fileSize }} Attachment file size (numeric): -> Expression: {{ $binary.values()[0].fileSize.split(' ')[0].toNumber() }} Attachment mime type: -> Expression: {{ $binary.values()[0].mimeType }} Attachment id (storage GUID): -> Expression: {{ $binary.values()[0].id }} Flow Control Since each of the attachments becomes a single item, it is relatively straightforward to introduce other n8n nodes like If, Switch, or Filter and route each single attachment item into different workflow paths. The template demonstrates how each attachment binary could be routed based on its file size, as an example.

Who this is for This template is for everyone that wants to download their n8n Cloud invoices automatically as a PDF instead of downloading them manually. How it works This workflow checks your Gmail inbox for new n8n invoice emails from n8n's payment provider Paddle. Once it finds something, it converts the URL into a PDF using pdflayer and saves it in Google Drive. Setup Setup your Gmail and Google Drive credentials Create a free account at https://pdflayer.com/ Insert your pdflayer API key into the Setup node Insert the URL to the wanted drive folder into the setup node (make sure to remove everything after the ?) How to adjust it to your need Instead of saving the PDF in Google drive, you could also save it in your local system, any other storage provider or send the PDF automatically to the right person in your company.

This is a simple template to show how to extract multiple email attachments and return them as an iterable output. How it works: The Gmail Trigger node detects any new email that has attachments. The Code node will then extract them as binary files and attaches them to the item. They can then be uploaded via the Google Drive node. Setup steps: add your Gmail Credentials add your Google Drive Credentials Follow the official n8n Documentation for help Feedback & Questions If you have any questions or feedback about this workflow - Feel free to get in touch at [email protected]

This workflow reads PDF textual content and sends the text to OpenAI. Attachments of interest will then be uploaded to a specified Google Drive folder. For example, you may wish to send invoices received from an email to an inbox folder in Google Drive for later processing. This workflow has been designed to easily change the search term to match your needs. See the workflow for more details. Prerequisites OpenAI credentials. Google credentials. How it works Triggers off on the On email received node. Iterates over the attachments in the email. Uses the OpenAI node to filter out the attachments that do not match the search term set in the Configure node. You could match on various PDF files (i.e. invoice, receipt, or contract). If the PDF attachment matches the search term, the workflow uses the Google Drive node to upload the PDF attachment to a specific Google Drive folder.

Upload invoices from Gmail to Google Drive daily

This simple workflow allows you to get an mp4 attachment from gmail email and then upload it to Google Drive to get attachment webview link.