AI Agents

Connect Google Sheets with Google Drive

22 nodes 197 119 Automatic trigger
Download

Workflow Description

An automation template that monitors Google Sheets for new data, uses an AI Agent powered by OpenAI to analyze and process information, translates content across multiple languages via Google Translate, and stores organized results in Google Drive automatically.

How it works

  1. 1.Monitor Google Sheets for new entries and trigger automation on each update
  2. 2.Process sheet data through an intelligent AI Agent using OpenAI's language model
  3. 3.Automatically translate extracted text into multiple languages with Google Translate
  4. 4.Structure and parse analysis results into a consistent formatted output
  5. 5.Save processed files and final results to a designated Google Drive folder

Use cases

  • Automate analysis and multilingual processing of large datasets from spreadsheets
  • Create organized archives of analyzed reports in cloud storage for compliance and documentation
  • Enable data-driven decision making by automatically extracting and translating key information

Requirements

  • Active Google Workspace account with permissions to Sheets and Drive resources
  • OpenAI API key to enable artificial intelligence capabilities for data analysis
  • Pre-populated Google Sheets document containing source data for processing

Service Value

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

Apps Used

Google Translate AI Agent OpenAI Output Parser Google Sheets Google Drive

Details

Trigger Automatic trigger
Nodes 22
Apps 6
Views 197
Downloads 119

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

/

Sticky Note3

Sticky Note

#1

Google Translate

Google Translate

#2

AI Agent

Agent

#3

OpenAI Chat Model

OpenAI

#4

Structured Output Parser

Output Parser Structured

#5

Merge

Merge

#6

Trigger Added Row

Google Sheets Trigger

#7

No Operation, do nothing

No Op

#8

Upload Picture

Google Drive

#9

Get Picture

HTTP Request

#10

Call API Pexels

HTTP Request

#11

Take initialText

Set

#12

Extract Image Link

Set

#13

Final Merge

Merge

#14

Extract Pinyin and Example

Set

#15

Extract Fields

Set

#16

initialText is empty?

If

#17

Sticky Note

Sticky Note

#18

Sticky Note1

Sticky Note

#19

Sticky Note2

Sticky Note

#20

Add Results in Sheet

Google Sheets

#21

Sticky Note4

Sticky Note

#22