Files & Documents

Automate Google Sheets updates across Drive and Slides

17 nodes 132 81 Automatic trigger
Download

Workflow Description

Automation that monitors Google Sheets changes, organizes related files in Google Drive folders, and updates Google Slides presentations automatically. Sends email notifications upon completion of all tasks.

How it works

  1. 1.Monitor Google Sheets for new or updated data entries
  2. 2.Extract and validate the updated data from the spreadsheet
  3. 3.Move associated files to organized folders in Google Drive
  4. 4.Refresh corresponding slides with the new data
  5. 5.Send email notification summarizing completed operations

Use cases

  • Auto-update sales reports in presentations from live spreadsheet data
  • Organize project files in Drive folders based on spreadsheet categories
  • Distribute updated reports to team members via email automatically

Requirements

  • Google Workspace account with Sheets, Drive, and Slides access
  • Full permissions for Google Drive, Sheets, and Slides APIs
  • Email recipients list for notifications (optional)

Service Value

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

Apps Used

Google Sheets Google Drive Google Slides Gmail

Details

Trigger Automatic trigger
Nodes 17
Apps 4
Views 132
Downloads 81

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)

/

Google Sheets Trigger

Google Sheets Trigger

#1

No Operation, do nothing

No Op

#2

Sticky Note

Sticky Note

#3

Sticky Note1

Sticky Note

#4

Sticky Note2

Sticky Note

#5

Sticky Note3

Sticky Note

#6

Extract essential data

Set

#7

Score Checker

If

#8

Sticky Note4

Sticky Note

#9

Sticky Note5

Sticky Note

#10

Sticky Note6

Sticky Note

#11

Sticky Note7

Sticky Note

#12

Copy from your template

Google Drive

#13

Replace text

Google Slides

#14

Convert to PDF

Google Drive

#15

Send to user's email

Gmail

#16

Sticky Note8

Sticky Note

#17