Files & Documents

Extract and organize Google Drive files data automatically

11 nodes 118 78 Automatic trigger
Download

Workflow Description

This automation template enables comprehensive Google Drive file management by extracting data from files, processing it systematically, and routing it through HTTP requests for further processing or organizing into structured notes for easy review and access.

How it works

  1. 1.Trigger the automation manually or based on a specific event
  2. 2.Extract file contents from Google Drive and process extracted data
  3. 3.Organize information into logical data structures and send via HTTP requests
  4. 4.Document results and extracted data in sticky notes for review and tracking

Use cases

  • Extract data from Excel spreadsheets stored in Drive and process automatically
  • Collect information from multiple files and send to external applications or databases
  • Automate file review and categorization based on content analysis
  • Generate reports from Drive files and save results automatically

Requirements

  • Active Google Drive account with file access permissions
  • HTTP endpoint (API) to receive extracted data (optional)
  • Supported file formats: PDF, images, and text files

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Drive

Details

Trigger Automatic trigger
Nodes 11
Apps 1
Views 118
Downloads 78

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

/

When clicking 'Test workflow'

Manual Trigger

#1

Extract from File

Extract From File

#2

Google Drive

Google Drive

#3

Call Gemini 2.0 Flash with PDF Capabilities

HTTP Request

#4

Call Claude 3.5 Sonnet with PDF Capabilities

HTTP Request

#5

Sticky Note1

Sticky Note

#6

Sticky Note

Sticky Note

#7

Define Prompt

Set

#8

Sticky Note2

Sticky Note

#9

Sticky Note3

Sticky Note

#10

Sticky Note4

Sticky Note

#11