AI Agents

Extract and analyze Google Drive files with AI into Sheets

28 nodes 299 174 Scheduled trigger
Download

Workflow Description

Scheduled automation retrieves files from Google Drive, processes them through OpenAI for intelligent analysis, and organizes results in Google Sheets. Handles large batches efficiently, transforming unstructured documents into structured, actionable insights.

How it works

  1. 1.Trigger automation on a predefined schedule to process files automatically
  2. 2.Retrieve file list from designated Google Drive folders and retrieve content
  3. 3.Send file contents to OpenAI in batches for intelligent analysis and extraction
  4. 4.Parse and structure AI responses using output parsers for consistency
  5. 5.Record analyzed data and insights into Google Sheets spreadsheets

Use cases

  • Analyze project documents automatically and save summaries to tracking sheets
  • Process periodic reports from Drive folders and extract key metrics into dashboards
  • Classify customer files by criteria and log results with AI-generated insights

Requirements

  • Active Google account with full access to Google Drive and Google Sheets
  • Valid OpenAI API key with sufficient credits for processing volume
  • Well-organized file structure in Google Drive for reliable retrieval

Service Value

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

Apps Used

LLM Chain OpenAI Output Parser Split In Batches Google Drive Google Sheets

Details

Trigger Scheduled trigger
Nodes 28
Apps 6
Views 299
Downloads 174

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)

/

Basic LLM Chain

LLM Chain

#1

OpenAI Chat Model

OpenAI

#2

Structured Output Parser

Output Parser Structured

#3

Split Out

Split Out

#4

HTTP Request

HTTP Request

#5

Sticky Note

Sticky Note

#6

Wait

Wait

#7

HTTP Request1

HTTP Request

#8

HTTP Request2

HTTP Request

#9

Loop Over Items

Split In Batches

#10

Sticky Note2

Sticky Note

#11

Google Drive

Google Drive

#12

Google Drive1

Google Drive

#13

Generate Videos

HTTP Request

#14

Merge

Merge

#15

Aggregate

Aggregate

#16

Google Drive2

Google Drive

#17

Schedule Trigger

Schedule Trigger

#18

Google Sheets

Google Sheets

#19

Google Sheets1

Google Sheets

#20

HTTP Request3

HTTP Request

#21

Google Drive3

Google Drive

#22

Wait1

Wait

#23

Edit Fields

Set

#24

Google Drive4

Google Drive

#25

Google Drive5

Google Drive

#26

OpenAI

OpenAI

#27

Google Sheets2

Google Sheets

#28

Similar Templates

Automate Notion tasks with an intelligent AI agent powered by OpenAI

12 nodes

Analyze Google Sheets data and share insights with Slack

12 nodes

Analyze Pinterest performance and generate AI-driven content suggestions automatically

13 nodes

Generate trending Instagram content with AI-powered images

44 nodes

Convert Documents into Study Notes Using Qdrant

42 nodes

Automate Google Sheets data processing with artificial intelligence

35 nodes