AI Agents

Extract Drive documents, classify in Sheets, and publish to WordPress

36 nodes 298 141 Automatic trigger
Download

Workflow Description

Automation that retrieves files from Google Drive, analyzes them using AI, classifies and stores data in Google Sheets, then automatically publishes articles to WordPress with distribution to multiple platforms.

How it works

  1. 1.Trigger automation manually or via webhook
  2. 2.Extract files from specified Google Drive folders
  3. 3.Analyze document content using OpenAI GPT model
  4. 4.Classify data and process in batches
  5. 5.Save classified results in Google Sheets tables
  6. 6.Publish articles automatically to WordPress, Webflow, and Strapi

Use cases

  • Manage and classify large document collections without manual intervention
  • Publish documented content across multiple web platforms simultaneously
  • Automate editorial workflows from content collection to publishing

Requirements

  • Google account with Drive and Sheets permissions
  • OpenAI API key and active WordPress account
  • Access to Webflow, Strapi, and Twitter/X optional

Service Value

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

Apps Used

OpenAI Split In Batches Google Drive Google Sheets Twitter/X Strapi WordPress Webflow LLM Chain

Details

Trigger Automatic trigger
Nodes 36
Apps 9
Views 298
Downloads 141

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

/

When clicking ‘Test workflow’

Manual Trigger

#1

OpenAI Chat Model

OpenAI

#2

Format QA Pair1

Set

#3

For Each Question...1

Split In Batches

#4

Question to List1

Split Out

#5

Questions to Object...1

Aggregate

#6

Format DisplayName + Questions1

Set

#7

Create From Text

Google Drive

#8

Define Sheets

Set

#9

Sheets To List...

Split Out

#10

Get Services

Google Sheets

#11

Single Integration Cred-only

Set

#12

Single Integration Native

Set

#13

Categories

Set

#14

For Each Sheet...

Split In Batches

#15

Execute Workflow Trigger

Execute Workflow Trigger

#16

Execute Workflow

Execute Workflow

#17

Prepare Job

Set

#18

For Each Service...

Split In Batches

#19

Update Row Status

Google Sheets

#20

Single Integration Non-native

Set

#21

If has Data

If

#22

Sticky Note

Sticky Note

#23

Needs AI Completion?1

Switch

#24

Sticky Note1

Sticky Note

#25

Switch

Switch

#26

Sticky Note2

Sticky Note

#27

Sticky Note3

Sticky Note

#28

Sticky Note4

Sticky Note

#29

Sticky Note5

Sticky Note

#30

Strapi

Strapi

#31

Sticky Note6

Sticky Note

#32

Wordpress

Wordpress

#33

Webflow

Webflow

#34

HTTP Request

HTTP Request

#35

AI Completion1

LLM Chain

#36

Similar Templates

Automated Processing of Google Drive Files with OpenAI Intelligence

7 nodes

Transform calendar events into ClickUp tasks automatically

12 nodes

Review and respond to emails with AI-powered summaries and manual approval

16 nodes

Analyze Google Sheets data and send intelligent summaries to Slack

12 nodes

Process Slack messages with AI and generate intelligent responses

11 nodes

Convert YouTube videos into published blog articles automatically

12 nodes