AI Agents

Connect Google Drive with Cron andMySQL

53 nodes 226 126 Scheduled trigger
Download

Workflow Description

Advanced automation template integrating Google Drive with scheduled triggers to extract and analyze documents using an AI agent powered by language models, storing structured data in MySQL while publishing insights across Twitter and Google Sheets.

How it works

  1. 1.Execute workflow automatically on a defined schedule using Cron trigger
  2. 2.Extract documents from Google Drive and process them with the default data loader
  3. 3.Split extracted text using advanced recursive character-based algorithm
  4. 4.Analyze content through an intelligent agent supported by language model chains and persist results in MySQL
  5. 5.Perform semantic search via Pinecone and generate smart responses using Gemini embeddings
  6. 6.Publish extracted insights to Google Sheets and Twitter/X for immediate team updates

Use cases

  • Periodically process client files in Drive and store summaries in database for compliance tracking
  • Monitor contracts and policy documents, automatically alerting sales teams through social media channels

Requirements

  • Active Google account with Drive, Sheets, and Docs permissions configured
  • Running MySQL server with pre-configured database and tables for data persistence
  • API keys for Gemini, Pinecone, and Twitter/X account for automated publishing workflows

Service Value

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

Apps Used

Google Drive Document Default Data Loader Schedule MySQL Google Sheets Google Docs Text Splitter AI Agent LLM Chain Twitter/X Vector Store Gemini Anthropic Lm Chat Groq Memory

Details

Trigger Scheduled trigger
Nodes 53
Apps 15
Views 226
Downloads 126

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 (53)

/

Download Doc File From Google Drive

Google Drive

#1

Doc File Data Loader

Document Default Data Loader

#2

Sticky Note

Sticky Note

#3

Cron

Cron

#4

MySQL -delete all data

My Sql

#5

MySQL - insert all from sheets

My Sql

#6

Sticky Note1

Sticky Note

#7

Google Sheets - Tech Radar

Google Sheets

#8

Code - Transform table into rows

Code

#9

Google Docs - Update GDoc

Google Docs

#10

Sticky Note2

Sticky Note

#11

Google Drive - Doc File Updated

Google Drive Trigger

#12

Content - Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#13

Google Sheets - Read TechRadar

Google Sheets

#14

Sticky Note3

Sticky Note

#15

Sticky Note4

Sticky Note

#16

Sticky Note11

Sticky Note

#17

Code - Simplify Mapping to Original Query

Code

#18

Codes - Simplify Mapping to Original Query

Code

#19

Execute Workflow - Sql Agent

Execute Workflow

#20

Execute Workflow - RAG Agent

Execute Workflow

#21

AI Agent - Output Guardrail

Agent

#22

LLM - Determine - Agent Input Router

LLM Chain

#23

Sticky Note6

Sticky Note

#24

Sticky Note7

Sticky Note

#25

Sticky Note12

Sticky Note

#26

Sticky Note8

Sticky Note

#27

Sticky Note9

Sticky Note

#28

When Executed by Another Workflow

Execute Workflow Trigger

#29

1_Get DB Schema and Tables List

My Sql Tool

#30

2_Get Table Definition

My Sql Tool

#31

3_Execute actual query

My Sql Tool

#32

AI Agent -DB Sql Agent

Agent

#33

Sticky Note10

Sticky Note

#34

Sticky Note13

Sticky Note

#35

Pinecone Vector Store (Retrieval)

Vector Store Pinecone

#36

4_RagTool

Tool Vector Store

#37

Sticky Note14

Sticky Note

#38

AI Agent - RAG

Agent

#39

Sticky Note15

Sticky Note

#40

Sticky Note16

Sticky Note

#41

Embeddings - Tech Radar Data Embedding

Gemini Model

#42

Pinecone - Vector Store for Embedding Content

Vector Store Pinecone

#43

Retrieve Embeddings - Tech Radar Vector DB

Gemini Model

#44

AI Agent - Retrieval

Gemini Model

#45

AI Chat Model - Claude 3.5 Sonnet

Lm Chat Anthropic

#46

AI Chat Model - QwQ 32b

Lm Chat Groq

#47

AI Chatmodel - Deepseek 32B

Lm Chat Groq

#48

AI Chat Model - llama3-8b

Lm Chat Groq

#49

API Response - Respond to Webhook

Webhook

#50

API Request - Webhook

Webhook

#51

Determine if is 'RAG'

If

#52

User Conversation history

Memory Buffer Window

#53

Similar Templates

Connect Gmail with Google Sheets

26 nodes

Connect OpenAI with Slack

38 nodes

Connect Slack with Gmail

39 nodes

RAG workflow for company documents stored in Google Drive

18 nodes

Connect Telegram with OpenAI

8 nodes

Insert and retrieve documents

25 nodes