Compliance report collector with Google Form → Drive + MySQL

📝 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 is logged into a MySQL database. It ensures compliance documentation is properly stored, searchable and auditable without manual effort.

⚡ Quick Implementation Steps 1. Import the JSON file into n8n. 2. Set up a Google Form to POST file + metadata (reporter, category, etc.) to the /submit-report webhook. 3. Update the Set Config node with your: - MySQL connection details - Google Drive folder ID 4. Deploy and test a form submission with a file upload. 5. Each report is stored in Drive and logged to your DB.

🎯 Who’s It For - Compliance officers handling environmental or safety reports. - Admins managing documentation for inspections. - Renewable energy companies required to maintain audit-ready records. - Any org needing structured report archival & metadata logging.

🛠 Requirements | Tool | Purpose | |------|---------| | n8n Instance | Workflow automation | | Google Drive | To archive uploaded reports | | MySQL Database | To log submission metadata | | Google Forms / HTML Form | Report submission source |

🧠 What It Does - Listens for incoming POST requests with a file and metadata. - Uploads the file to a specified Google Drive folder. - Extracts metadata like: - Reporter name - Category/type - Timestamp - File name, MIME type - Logs that metadata into a MySQL table for auditing or reporting.

🧾 Sample MySQL Table Schema sql CREATE TABLE reportlogs ( id INT AUTOINCREMENT PRIMARY KEY, reporter VARCHAR(100), category VARCHAR(100), timestamp DATETIME, filename VARCHAR(255), mimetype VARCHAR(50), folderid VARCHAR(100) );

🔧 How To Set Up – Step-by-Step 1. Import the JSON into n8n. 2. Configure the following in the Set Config node: - MySQL: dbHost, dbUser, dbPassword, dbName, dbTable - Google Drive: driveFolderId 3. Update the webhook URL in your Google Form (via Apps Script or middleware). 4. Test submission with a file upload. 5. Confirm: - File lands in your Drive folder - Log entry appears in your database