Generate personalized franchise PDF letters from Excel with Google Drive and Docs
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs when someone submits an n8n form (“Franchise list Upload”). Along the way it connects Google Drive and Google Docs.
How it runs
Trigger: When someone submits an n8n form (“Franchise list Upload”).
- Extract File Data (Extract from File): extracts data from a file (xlsx)
- Loop Over Batch Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Copy to Google Drive (Google Drive): copy
- Update Google Document (Google Docs): update
- Download from Google Drive (Google Drive): download
- Upload to Google Drive (Google Drive): uses Google Drive
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 (5)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Drive
n8n-nodes-base.googleDrive - Google Docs
n8n-nodes-base.googleDocs
From the author
Quick overview This workflow collects an uploaded XLSX list of franchise owners via an n8n form, then uses Google Drive and Google Docs to generate a personalized letter for each row and saves the resulting PDF files back to a Google Drive folder. How it…