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

Extract Google Drive files, analyze with AI, and populate Google Sheets

24 nodes 528 164 Scheduled trigger
Download

Loading workflow…

Workflow Description

Scheduled automation that retrieves files from Google Drive, analyzes their content using Gemini, structures the extracted data, and populates Google Sheets with results while creating related tasks in Linear automatically.

How it works

  1. 1.Fetch files from a specified Google Drive folder
  2. 2.Analyze each file's content using Gemini AI model
  3. 3.Parse and format results according to the defined structure
  4. 4.Insert formatted data into Google Sheets tables
  5. 5.Create priority tasks in Linear for relevant items
  6. 6.Log records and errors back to the spreadsheet

Use cases

  • Process large document volumes and convert them into organized datasets
  • Analyze reports, invoices, and categorize them automatically
  • Monitor Drive folders and extract sensitive data in an organized manner

Requirements

  • Active Google account with Drive and Sheets permissions
  • Google Gemini API key configured
  • Linear account for task integration and creation

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 Wait HTTP Request Google Sheets Merge Schedule Filter Set Aggregate Linear Manual Trigger LLM Chain

Details

Trigger Scheduled trigger
Nodes 24
Apps 15
Views 528
Downloads 164

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

/

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

Build an intelligent Slack agent with conversation memory

10 nodes

Monitor GitHub repositories and auto-publish updates to X

15 nodes

Extract Google Analytics insights and deliver AI-powered reports to Telegram

13 nodes

Automate Google Sheets with AI Agent Commands

11 nodes

Intelligent data processing and classification in Airtable

15 nodes

Intelligent Knowledge Base Conversations via Slack

20 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