Skip to content
EN
العربيةEnglishEspañol
AI Agents

Extract Google Drive Documents, Analyze with AI, and Store Results in MySQL

28 nodes 534 211 Scheduled trigger
Download

Loading workflow…

Workflow Description

A scheduled automation that retrieves documents from Google Drive, analyzes them using an AI agent powered by Gemini, splits lengthy texts, stores insights in MySQL and Google Sheets, and publishes summaries to X. Combines document extraction, intelligent processing, and multi-platform storage.

How it works

  1. 1.Schedule periodic execution using Cron
  2. 2.Extract and automatically load Google Drive file contents
  3. 3.Analyze documents with AI agent and LLM chains via Gemini
  4. 4.Split long texts for efficient processing
  5. 5.Save results to MySQL database
  6. 6.Publish summaries to Google Sheets and X

Use cases

  • Automatically monitor and summarize team documents
  • Extract structured data from documents into databases
  • Analyze reports and contracts with AI, then share insights

Requirements

  • Google account with access to Drive, Sheets, and Docs
  • MySQL database (local or cloud-hosted)
  • Google Gemini API key or Gemini Pro account

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 Text Splitter Google Sheets Code Twitter/X AI Agent LLM Chain Gemini Vector Store Anthropic Lm Chat Groq Webhook If Memory

Details

Trigger Scheduled trigger
Nodes 28
Apps 17
Views 534
Downloads 211

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

/

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

Sticky Note2

Sticky Note

#8

Google Drive - Doc File Updated

Google Drive Trigger

#9

Content - Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#10

Google Sheets - Read TechRadar

Google Sheets

#11

Sticky Note3

Sticky Note

#12

Sticky Note4

Sticky Note

#13

Sticky Note11

Sticky Note

#14

Code - Simplify Mapping to Original Query

Code

#15

Codes - Simplify Mapping to Original Query

Code

#16

Execute Workflow - Sql Agent

Execute Workflow

#17

Execute Workflow - RAG Agent

Execute Workflow

#18

AI Agent - Output Guardrail

Agent

#19

LLM - Determine - Agent Input Router

LLM Chain

#20

Sticky Note6

Sticky Note

#21

Sticky Note7

Sticky Note

#22

Sticky Note12

Sticky Note

#23

Sticky Note8

Sticky Note

#24

Sticky Note9

Sticky Note

#25

When Executed by Another Workflow

Execute Workflow Trigger

#26

1_Get DB Schema and Tables List

My Sql Tool

#27

2_Get Table Definition

My Sql Tool

#28

3_Execute actual query

My Sql Tool

#29

AI Agent -DB Sql Agent

Agent

#30

Sticky Note10

Sticky Note

#31

Sticky Note13

Sticky Note

#32

Sticky Note14

Sticky Note

#33

Sticky Note15

Sticky Note

#34

Sticky Note16

Sticky Note

#35

Embeddings - Tech Radar Data Embedding

Gemini Model

#36

Pinecone - Vector Store for Embedding Content

Vector Store Pinecone

#37

AI Chat Model - Claude 3.5 Sonnet

Lm Chat Anthropic

#38

AI Chatmodel - Deepseek 32B

Lm Chat Groq

#39

AI Chat Model - llama3-8b

Lm Chat Groq

#40

API Response - Respond to Webhook

Webhook

#41

API Request - Webhook

Webhook

#42

Determine if is 'RAG'

If

#43

User Conversation history

Memory Buffer Window

#44

Similar Templates

Build an intelligent agent with OpenAI memory and tools

6 nodes

Building a Multi-Tool Intelligent Agent with OpenAI

9 nodes

Extract and summarize search results with Gemini AI

17 nodes

Process Chat Messages with Intelligent Agent and Batch Splitting

13 nodes

Control Spotify playback with intelligent Telegram commands

13 nodes

Silent Null & PairedItem Range Output Auditor

8 nodes
Stay in the loop

Fresh workflows, straight to your inbox

Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.

  • New workflows
  • Clear overviews
  • Setup guides

Be first to discover what is new

Your name, your email, and one confirmation.

Email confirmation · Unsubscribe anytime