Skip to content
FlowHub
FluxonLab
Google Drive
Security & Compliancefree

Complete Automated n8n Workflows Backup & Restore Solution with Preserved Folder Structure

by Adam ABDELMOUMNIUpdated Aug 2026
RequiresGoogle DriveGoogle DriveGoogle SheetsGoogle Sheets
Share Post Share
HRn8n login API1HRget subfolder(s) structureget subfolder(s…MeMergeSearch if folder already existsSearch if folde…Ifif folder not found => create itif folder not f…SeAttach the parentFolder if anyAttach the pare…Ifif parentFolder emptyif parentFolder…Create folder under the parentFolderCreate folder u…SOSplit Out3MeMerge1MeMerge2Sewf_id + wf_nameSeroot folder : backup_n8nroot folder : b…MeMerge3MeMerge6AgAggregate3SOSplit Out1RDRemove DuplicatesRemove Duplicat…Serename fieldsSerename fields1Serename main_root_folder fieldsrename main_roo…Create folder under the static "backup_n8n" folderCreate folder u…Serename fields2Serename fields3Seget directParentFolderNameget directParen…IfSplit root vs subfoldersSplit root vs s…MeMerge4RDRemove Duplicates1Remove Duplicat…Serename fields4Serename fields5Serename fields6IfIf there parentFolder.isEmpty()If there parent…RDRemove Duplicates2Remove Duplicat…MeMerge5Serename fields7Upload file to its folderUpload file to …Seroot folder : backup_n8n1root folder : b…IfIf parentFolder is nullIf parentFolder…IfIf resource == "folder"If resource == …CoDefine & assign folder's fullPath valueDefine & assign…HRget all workflowsget all workflo…SOextract each workflowextract each wo…Create backup folder "n8n_backup_folder_structure_ddMMyyyy_HHmmss"Create backup f…SoSort to get root folders firstSort to get roo…Sedefine full_path lengthdefine full_pat…SIOne run per folderOne run per fol…HRget all workflows1get all workflo…Fikeep only workflows not archivedkeep only workf…Fikeep only workflows not archived1keep only workf…Seadd wf_folder_nameadd wf_folder_n…Coremove the [] wrapper to re-create imported wf laterremove the [] w…Sen8n-auth for n8n APIn8n-auth for n8…CTConvert workflow to JSON fileConvert workflo…Upload file to gdrive main root folderUpload file to …Sen8n instance/project access detailsn8n instance/pr…HRcreate n8n table "folders"create n8n tabl…HRcreate n8n table "workflows"create n8n tabl…Co"folders" table columns list"folders" table…Co"workflows" table columns list"workflows" tab…HRget projectIdHRadd columns to "folders" tableadd columns to …HRadd columns to "workflows" tableadd columns to …DTget all folders2DTadd backup_folder google_id to "folders"add backup_fold…DTAdd data about folder : google_folder_id1Add data about …DTget parent_google_folderid valueget parent_goo…DTget all folders1DTparentFolderDTUpsert row(s)4DTUpsert row(s)5DTGet row(s)3DTget main root folder details1get main root f…DTget related folder details1get related fol…DTadd workflow file and folder google IDs2add workflow fi…DTadd workflow file and folder google IDsadd workflow fi…DTAdd data about folder : google_folder_idAdd data about …Seexclude field "id"exclude field "…DTPurge data in "folders"Purge data in "…DTInsert data into table "folders"Insert data int…DTGet all foldersDTInsert "full_path" value for each folderInsert "full_pa…DTMatch workflow with folder detailsMatch workflow …DTInsert workflow details into "workflows" tableInsert workflow…DTGet the parentFolderName if it existsGet the parentF…Seget parentFolderId if it existsget parentFolde…HRGet each workflow JSON dataGet each workfl…HRGET each workflow JSON dataGET each workfl…AgAggregateDTInsert one row in "folders" for the main_root_backup_folderInsert one row …HRget n8n table "id"get n8n table "…SOSplit OutHRget n8n table "id"1get n8n table "…SOSplit Out2FiFilter on "folders" tableFilter on "fold…FiFilter on "workflows" tableFilter on "work…DTPurge data in "workflows"Purge data in "…SILoop Over ItemsCoone item per workflow at main_root_folderone item per wo…Create gsheet "workflows_folders_backup_details"Create gsheet "…Move file to backup drive folderMove file to ba…DTfolders detailsDTworkflows detailsworkflows detai…DTGet "main_root_folder_google_folder_id"Get "main_root_…Copy data to sheet "workflows"Copy data to sh…Copy data to sheet "folders"Copy data to sh…HRn8n login API2HRcreate n8n table "folders_restore_backup"create n8n tabl…Co"folders_restore_backup" table columns list"folders_restor…HRadd columns to "folders_restore_backup" tableadd columns to …FiFilter on "folders_restore_backup" tableFilter on "fold…DTPurge data in "folders_restore_backup"Purge data in "…DTInsert data into table "folders_restore_backup"Insert data int…SefullPath length1FiFilterAgAggregate1SeAttach the parentFolder if any1Attach the pare…Ifif parentFolder empty1if parentFolder…SIOne run per folder1One run per fol…DTGet the parentFolderName if it exists2Get the parentF…Seget parentFolderId if it exists1get parentFolde…DTGet the parentFolderName if it exists3Get the parentF…MeMerge7HRcreate n8n folder3create n8n fold…DTUpsert row(s)3HRcreate n8n folder4create n8n fold…Coadd "active" key to JSON : mandatory1add "active" ke…HRcreate main backup n8n foldercreate main bac…HRCreate workflow JSON file into backup n8n folderCreate workflow…Get row(s) in sheetGet row(s) in s…Fiexclude "main_root_backup_folder"exclude "main_r…Search for the backup folder in DriveSearch for the …Get related gsheet "workflows_folders_backup_details"Get related gsh…SoOrder by full_path length ASCOrder by full_p…Get all n8n folders from the backupGet all n8n fol…Get workflows detailsGet workflows d…DTGet folders_restore_backup detailsGet folders_res…Download JSON wf filesDownload JSON w…EFExtract JSON from filesExtract JSON fr…Seexclude some fields before create workflowexclude some fi…Serename fields8Sen8n-auth for n8n API1n8n-auth for n8…Sen8n instance/project access details1n8n instance/pr…HRget projectId1HRget n8n table "id"2get n8n table "…SOSplit Out4Serename fields9Serename fields10Serename fields11DTUpsert row(s)MeMerge8RDRemove Duplicates3Remove Duplicat…AgAggregate4MaRestore workflows triggerRestore workflo…ScBackup workflows schedulerBackup workflow…
1/5
FLOWS
STEPS · 116
Runs on a schedule

On manual or scheduled run, exports n8n workflows to Google Drive preserving folder structure and logs them in Google Sheets.

Tags

manualadvancedGoogle DriveGoogle SheetsDevOps
Connects
googledriveGoogle DrivesheetsGoogle Sheets
CategorySecurity & Compliance
Triggermanual
Complexityadvanced
Nodes154
AddedJun 14, 2026