Index new Google Drive folder files into Google Sheets automatically
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Config (Edit Fields (Set)): sets 3 fields: targetFolderId, indexSpreadsheetId, indexSheetName
- List files and folders (Google Drive): work with file folder
- Get Existing Index Rows (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Filter Already Indexed Files (Code): runs custom JavaScript code
- Prepare Index Row (Code): runs custom JavaScript code
- Append Row to Index Sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge
From the author
Description: Automatically catalog the contents of any Google Drive folder into a Google Sheets spreadsheet — capturing file names, types, extensions, Drive links, and timestamps in one click. Ideal for teams or individuals who need a living, auditable…