Files & Documents

Monitor Google Drive files and automatically update Sheets and Slides

14 nodes 297 121 Automatic trigger
Download

Workflow Description

Automation that watches a Google Drive folder and extracts data to automatically update spreadsheets in Google Sheets and create content in Google Slides, eliminating manual data transfer between applications and saving significant operational time.

How it works

  1. 1.Trigger fires when a new or updated file is added to the monitored Google Drive folder
  2. 2.Extract data from the uploaded file using the file extraction node
  3. 3.Push the extracted data to Google Sheets to update your spreadsheet
  4. 4.Copy relevant information to Google Slides for presentation purposes
  5. 5.Merge results from multiple processing paths to consolidate outcomes
  6. 6.Log notes for audit trails and process tracking

Use cases

  • Auto-update sales reports whenever new data files are uploaded to Drive
  • Sync project data between spreadsheets and presentations without manual work
  • Generate dynamic presentations that reflect latest uploaded data in real-time

Requirements

  • Active Google Workspace account with access to Drive, Sheets, and Slides
  • Designated Google Drive folder configured for file monitoring
  • Pre-existing Google Sheets spreadsheet and Google Slides presentation in the same account

Service Value

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

Apps Used

Google Drive Google Sheets Google Slides

Details

Trigger Automatic trigger
Nodes 14
Apps 3
Views 297
Downloads 121

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

/

Download by ID

Google Drive

#1

MoveToLeadListFolder

Google Drive

#2

Add Presentation ID to Lead List

Google Sheets

#3

Get all Leads

Google Sheets

#4

Create new Sheet

Google Sheets

#5

Merge Data for new Lead Document

Google Sheets

#6

New Leads Arrived

Google Drive Trigger

#7

File Type?

Switch

#8

Combine Empty New Document with CSV Data

Merge

#9

Create Custom Presentation

Google Slides

#10

Sticky Note

Sticky Note

#11

Sticky Note1

Sticky Note

#12

Extract Information from CSV file

Extract From File

#13

Copy Presentation Template

Google Drive

#14

Similar Templates

Read and update Google Sheets data automatically

3 nodes

Monitor Google Drive files, send Gmail notifications, and log data to Sheets

19 nodes

Read and Process Binary Files Automatically

2 nodes

Generate and distribute research reports automatically with AI-powered search

26 nodes

Automated CV screening and data extraction with AI-powered analysis

17 nodes

Extract Google Drive Files and Summarize Them in Notion with OpenAI

8 nodes