Marketing

Extract Google Drive files, analyze with OpenAI, and organize results in Sheets

39 nodes 302 98 Automatic trigger
Download

Workflow Description

Automation that monitors a Google Drive folder, extracts file content, analyzes it using OpenAI to generate marketing insights, then organizes and stores results in a structured Google Sheets table for review and further analysis.

How it works

  1. 1.Monitor Google Drive folder and extract new files automatically
  2. 2.Send file content to OpenAI for intelligent analysis and processing
  3. 3.Organize analyzed data and save results to Google Sheets

Use cases

  • Automatically categorize and analyze marketing content at scale
  • Extract key insights from project documents and log them systematically
  • Process customer requests from forms and generate intelligent responses

Requirements

  • Google account with Drive and Sheets access permissions
  • OpenAI API key for content analysis
  • Pre-configured Google Sheets table to receive processed data

Service Value

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

Apps Used

Google Drive Sort Form Trigger Google Sheets OpenAI

Details

Trigger Automatic trigger
Nodes 39
Apps 5
Views 302
Downloads 98

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

/

create_folder

Google Drive

#1

input_brief

Set

#2

new_lines

Set

#3

input_sections

Set

#4

section_text

Set

#5

Merge

Merge

#6

Sort

Sort

#7

Aggregate

Aggregate

#8

final_article

Set

#9

set_introduction

Set

#10

Merge1

Merge

#11

receive_topic

Form Trigger

#12

add_row

Google Sheets

#13

topic_variables

Set

#14

markdown_to_file

Convert To File

#15

split_out

Split Out

#16

section_starts_with_#

If

#17

25_percent_chance

If

#18

set_section_content

Set

#19

add_2_new_lines

Code

#20

final_article_file

Convert To File

#21

upload_fiinalArticle

Google Drive

#22

update_article_link

Google Sheets

#23

upload_outline_file

Google Drive

#24

section_paragraphs

OpenAI

#25

change_section_format

OpenAI

#26

create_outline

OpenAI

#27

Sticky Note

Sticky Note

#28

Sticky Note1

Sticky Note

#29

Sticky Note2

Sticky Note

#30

Sticky Note3

Sticky Note

#31

Sticky Note4

Sticky Note

#32

Sticky Note5

Sticky Note

#33

Sticky Note6

Sticky Note

#34

Sticky Note7

Sticky Note

#35

Sticky Note8

Sticky Note

#36

Sticky Note9

Sticky Note

#37

Sticky Note10

Sticky Note

#38

Sticky Note11

Sticky Note

#39

Similar Templates

Send Facebook messages with manual trigger

2 nodes

Generate marketing content with OpenAI and save to Airtable

30 nodes

Automated email marketing campaigns with AI-powered content generation

36 nodes

Collect emails, create documents, and publish across social media

56 nodes

Build an intelligent data server with Airtable and AI assistance

13 nodes

Extract and process Supabase data with AI intelligence

38 nodes