AI Agents

Extract Google Drive documents and send AI-powered summaries via Gmail

35 nodes 311 146 Scheduled trigger
Download

Workflow Description

Automation that retrieves documents from Google Drive, analyzes them using Gemini AI, stores extracted data in a vector store, and sends structured summaries via Gmail on a scheduled basis. The agent processes text, generates insights, and maintains conversation memory for context-aware responses.

How it works

  1. 1.Trigger automation on schedule and load documents from Google Drive
  2. 2.Split and embed text content using Gemini, then store vectors in Pinecone
  3. 3.Query vector store through AI agent to generate intelligent summaries
  4. 4.Store results in Noco DB and deliver summaries to recipients via Gmail

Use cases

  • Automatically summarize reports from shared folders and distribute them weekly to team members
  • Extract key data from contracts and legal documents, then email summaries to stakeholders
  • Collect meeting notes from Drive and send action items summaries to participants

Requirements

  • Google Workspace account with access to Google Drive and Gmail APIs
  • Valid Gemini API key and configured vector store (Pinecone)
  • Noco DB instance for storing and managing extracted data

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Gemini Google Drive Vector Store Document Default Data Loader Text Splitter AI Agent Memory Noco Db Gmail

Details

Trigger Scheduled trigger
Nodes 35
Apps 9
Views 311
Downloads 146

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (35)

/

Embeddings Google Gemini

Gemini Model

#1

Sticky Note1

Sticky Note

#2

Sticky Note3

Sticky Note

#3

Schedule Trigger

Schedule Trigger

#4

Sticky Note4

Sticky Note

#5

Sticky Note5

Sticky Note

#6

Sticky Note

Sticky Note

#7

Sticky Note6

Sticky Note

#8

Sticky Note7

Sticky Note

#9

Sticky Note8

Sticky Note

#10

Sticky Note9

Sticky Note

#11

Google Gemini Chat Model

Gemini Model

#12

Google Drive - Resume CV File Created

Google Drive Trigger

#13

Google Drive - Resume CV File Updated

Google Drive Trigger

#14

Download CV File From Google Drive

Google Drive

#15

Pinecone - Vector Store forr CV Content

Vector Store Pinecone

#16

CV File Data Loader

Document Default Data Loader

#17

CV content - Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#18

Chat API - webhook

Webhook

#19

Personal CV AI Agent Assistant

Agent

#20

Chat API Response - Webhook

Webhook

#21

Chat Memory - Window Buffer

Memory Buffer Window

#22

Resume lookup : Vector Store Tool

Tool Vector Store

#23

Resume Vector Store (Retrieval)

Vector Store Pinecone

#24

Resume Embeddings Google Gemini (retrieval)

Gemini Model

#25

Resume Google Gemini Chat Model (retrieval)

Gemini Model

#26

Save Conversation API - Webhook

Webhook

#27

Save Conversation - NocoDB

Noco Db

#28

Save Conversation API Webhook - Response

Webhook

#29

NocoDB - get all todays conversation

Noco Db

#30

Group Conversation By Unique Session + Email - Code

Code

#31

Format HTML Display For email

HTML Page

#32

Send Report To Gmail

Gmail

#33

Sticky Note10

Sticky Note

#34

Sticky Note11

Sticky Note

#35

Similar Templates

Automate data processing in Google Sheets with AI intelligence

22 nodes

Summarize daily meetings automatically with Gemini

9 nodes

Intelligent Chat with Multiple Data Sources Using AI Agents

12 nodes

Smart Telegram Responses Powered by OpenAI

21 nodes

Automate Google Sheets data processing with AI agents

11 nodes

Convert images to patterns with AI processing

5 nodes