Connect Google Drive with Gmail
Workflow Description
An intelligent automation that reads Google Drive documents using an AI agent powered by Gemini, analyzes their content through Vector Store, then sends summaries and answers directly to Gmail based on queries.
How it works
- 1.Activate the scheduled trigger to periodically scan Drive documents
- 2.Process and split documents using Text Splitter and store semantic embeddings
- 3.Route inquiries to an AI agent that uses Gemini for comprehension and response generation
- 4.Send results and summaries via Gmail to specified recipients
Use cases
- Send daily summaries of important documents to email
- Automatically answer questions related to stored Drive files
- Organize and monitor large documents with automated notifications
Requirements
- Google account with permissions on Drive and Gmail
- API key for Gemini and Pinecone Vector Store
- Email recipient list and scheduled execution frequency
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (35)
Embeddings Google Gemini
Gemini Model
Sticky Note1
Sticky Note
Sticky Note3
Sticky Note
Schedule Trigger
Schedule Trigger
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Google Gemini Chat Model
Gemini Model
Google Drive - Resume CV File Created
Google Drive Trigger
Google Drive - Resume CV File Updated
Google Drive Trigger
Download CV File From Google Drive
Google Drive
Pinecone - Vector Store forr CV Content
Vector Store Pinecone
CV File Data Loader
Document Default Data Loader
CV content - Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Chat API - webhook
Webhook
Personal CV AI Agent Assistant
Agent
Chat API Response - Webhook
Webhook
Chat Memory - Window Buffer
Memory Buffer Window
Resume lookup : Vector Store Tool
Tool Vector Store
Resume Vector Store (Retrieval)
Vector Store Pinecone
Resume Embeddings Google Gemini (retrieval)
Gemini Model
Resume Google Gemini Chat Model (retrieval)
Gemini Model
Save Conversation API - Webhook
Webhook
Save Conversation - NocoDB
Noco Db
Save Conversation API Webhook - Response
Webhook
NocoDB - get all todays conversation
Noco Db
Group Conversation By Unique Session + Email - Code
Code
Format HTML Display For email
HTML Page
Send Report To Gmail
Gmail
Sticky Note10
Sticky Note
Sticky Note11
Sticky Note