Compliance report collector with Google Form → Drive + MySQL
Needs changesWhat this workflow does
This workflow has 6 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, MySQL and Google Drive.
How it runs
Trigger: On Google Sheets events (row added).
- Extract googlesheet data (Function): runs custom JavaScript (legacy Function node)
- Get file uploaded metadata (Google Drive): download
- Merge: merges the data from its input branches
- Rename Fields (Edit Fields (Set)): sets or maps fields
- Log to MySQL (MySQL): uses MySQL
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Extract googlesheet data: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Extract googlesheet data | Code node, mode 'Run Once for All Items' |
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - MySQL
n8n-nodes-base.mySql - Edit Fields (Set)
n8n-nodes-base.set - Function
n8n-nodes-base.function - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge
From the author
📝 Compliance Report Collector (Google Form → Drive + MySQL) This n8n workflow automates the collection and archival of compliance reports submitted via Google Forms. Uploaded documents (PDF, DOCX, etc.) are archived into Google Drive and submission metadata…