Files & Documents

Sync Google Sheets data with Google Drive files

17 nodes 132 77 Automatic trigger
Download

Workflow Description

An automation workflow that connects Google Sheets with Google Drive, enabling automated reading and processing of spreadsheet data, then storing results or related files directly in Drive based on specified conditions.

How it works

  1. 1.Trigger the workflow manually or on a scheduled basis
  2. 2.Retrieve data from the specified Google Sheets spreadsheet
  3. 3.Process the data and apply conditional logic as needed
  4. 4.Upload results or output files to the designated Google Drive folder
  5. 5.Log the operation status and execution details

Use cases

  • Automatic backup of spreadsheet data into organized Drive folder structures
  • Batch processing of spreadsheet rows with result file generation in Drive
  • Periodic sync of spreadsheet updates with archived copies in cloud storage

Requirements

  • Connected Google account with valid authentication credentials
  • Accessible Google Sheets spreadsheet with data to process
  • Designated Google Drive folder for storing files and results
  • Proper permissions configured on both applications

Service Value

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

Apps Used

Google Sheets Google Drive

Details

Trigger Automatic trigger
Nodes 17
Apps 2
Views 132
Downloads 77

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

/

When clicking ‘Test workflow’

Manual Trigger

#1

Get status

HTTP Request

#2

Wait 60 sec.

Wait

#3

Schedule Trigger

Schedule Trigger

#4

Sticky Note3

Sticky Note

#5

Sticky Note4

Sticky Note

#6

Completed?

If

#7

Update result

Google Sheets

#8

Set data

Set

#9

Sticky Note5

Sticky Note

#10

Sticky Note6

Sticky Note

#11

Sticky Note7

Sticky Note

#12

Get new image

Google Sheets

#13

Create 3D Image

HTTP Request

#14

Get Url 3D image

HTTP Request

#15

Get File 3D image

HTTP Request

#16

Upload 3D Image

Google Drive

#17