AI Agents

Extract Drive files, analyze content, and log to Sheets automatically

34 nodes 303 135 Scheduled trigger
Download

Workflow Description

A scheduled automation that retrieves files from Google Drive, analyzes their content using Gemini to extract key information, processes them in batches, and automatically records structured data in Google Sheets while creating linked tasks in Linear.

How it works

  1. 1.Trigger on schedule, retrieve file list from Google Drive with metadata
  2. 2.Process files in batches and analyze content using Gemini language model for data extraction
  3. 3.Parse results, format data, insert rows into Google Sheets, and create corresponding tasks in Linear

Use cases

  • Automatically document and catalog project files stored across Google Drive
  • Extract and consolidate important data from multiple files into a centralized Sheets ledger
  • Track action items extracted from files by syncing them with Linear project management

Requirements

  • Google account with access to Google Drive and Google Sheets
  • Gemini API key enabled in Google Cloud Console
  • Linear workspace account connected for task creation and tracking

Service Value

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

Apps Used

Google Drive Gemini Output Parser Split In Batches Google Sheets Linear LLM Chain

Details

Trigger Scheduled trigger
Nodes 34
Apps 7
Views 303
Downloads 135

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

/

Base Image

Google Drive

#1

Google Gemini Chat Model

Gemini Model

#2

Structured Output Parser

Output Parser Structured

#3

Sticky Note

Sticky Note

#4

Sticky Note1

Sticky Note

#5

Sticky Note2

Sticky Note

#6

Sticky Note3

Sticky Note

#7

Loop Over Items

Split In Batches

#8

Wait

Wait

#9

Download Screenshot

HTTP Request

#10

Upload to Drive

Google Drive

#11

Update Base Image

Google Sheets

#12

Merge

Merge

#13

Schedule Trigger

Schedule Trigger

#14

Get URLs with Missing Base Images

Google Sheets

#15

Run Webpage Screenshot

HTTP Request

#16

Run Webpage Screenshot1

HTTP Request

#17

Has Changes

Filter

#18

Combine Row and Result

Set

#19

Wait1

Wait

#20

Aggregate

Aggregate

#21

Create Report

Linear

#22

When clicking ‘Test workflow’

Manual Trigger

#23

Get Webpages List

Google Sheets

#24

For Each Webpage...

Split In Batches

#25

Sticky Note4

Sticky Note

#26

Sticky Note5

Sticky Note

#27

Sticky Note6

Sticky Note

#28

Sticky Note7

Sticky Note

#29

Download New Screenshot

HTTP Request

#30

Combine Screenshots

Merge

#31

Sticky Note8

Sticky Note

#32

Sticky Note9

Sticky Note

#33

Visual Regression Agent

LLM Chain

#34

Similar Templates

Automate Google Sheets with Intelligent AI Agent

11 nodes

Analyze screenshots using OpenAI vision capabilities

9 nodes

Build an intelligent assistant for Google Drive document queries

50 nodes

Analyze Google Sheets data and send intelligent summaries to Slack

12 nodes

Intelligent AI agent answering customer questions from WooCommerce knowledge base

25 nodes

AI Agent in Slack with Retrieval-Augmented Generation

21 nodes