Files & Documents

Automate Google Sheets data synchronization with Google Drive folders

28 nodes 280 129 Automatic trigger
Download

Workflow Description

This template connects your Google Sheets spreadsheets with Google Drive folders, automatically reading data from sheets and organizing files based on spreadsheet content. Perfect for automating file management, data export, and folder organization in the cloud without manual intervention.

How it works

  1. 1.Trigger automation manually or when spreadsheet updates
  2. 2.Read data from specified worksheets and columns
  3. 3.Process and structure data using code logic
  4. 4.Create or update files and folders in Google Drive
  5. 5.Log results and maintain automation history

Use cases

  • Automatically create separate Google Drive folders for each spreadsheet row
  • Export important data from sheets and save as files in the cloud
  • Organize projects and documents based on categories in your spreadsheet
  • Sync task lists between Google Sheets and project folder structures

Requirements

  • Google Workspace account with full permissions on Sheets and Drive
  • An existing spreadsheet containing data to be processed
  • Basic understanding of data formats and desired folder structure

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets Google Drive Read Write File

Details

Trigger Automatic trigger
Nodes 28
Apps 3
Views 280
Downloads 129

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

/

When clicking ‘Test workflow’

Manual Trigger

#1

Generate Image

HTTP Request

#2

Get image

HTTP Request

#3

Sticky Note

Sticky Note

#4

Update image background URL

Google Sheets

#5

Image-to-Video

HTTP Request

#6

Wait image 2 min

Wait

#7

Wait video 5 min

Wait

#8

Get Video

HTTP Request

#9

Sticky Note1

Sticky Note

#10

Generate Audio

HTTP Request

#11

Get data from Google Sheet

Google Sheets

#12

Update Sound background URL

Google Sheets

#13

Update video background URL

Google Sheets

#14

Sticky Note2

Sticky Note

#15

Upload Sound to Google Drive

Google Drive

#16

Save Video Background Locally1

Read Write File

#17

Get Binary Video Background

HTTP Request

#18

Save Music Background Locally1

Read Write File

#19

Prepare Overlay Text (Quote & Author)1

Code

#20

Generate Final Video Clip1

Execute Command

#21

Initiate YouTube Resumable Upload

HTTP Request

#22

Read output file

Read Write File

#23

Upload Video to YouTube

HTTP Request

#24

Update Quote Upload Status

Google Sheets

#25

Sticky Note3

Sticky Note

#26

Sticky Note4

Sticky Note

#27

Sticky Note5

Sticky Note

#28