Compliance Report Collector: Google Forms → Drive + MySQL

This n8n workflow streamlines the handling of compliance reports submitted via Google Forms. It listens for POST requests containing files (PDF, DOCX, etc.) and metadata like reporter name, category, and timestamp. The uploaded file is automatically archived into a specified Google Drive folder, while extracted metadata is inserted into a MySQL database table for long-term storage and querying.

Key benefits include eliminating manual data entry, ensuring all submissions are centrally stored and logged without errors, and providing an audit trail for regulatory compliance. It's ideal for compliance officers, safety admins, or renewable energy firms needing to maintain inspection records effortlessly.

Use cases span environmental reporting, procurement audits, and safety inspections. Setup is straightforward: import the workflow, configure your Google Form webhook, update MySQL credentials and Drive folder ID, then deploy. Test with a sample submission to verify file upload and DB logging.

The workflow handles file extraction, metadata parsing, Drive upload, and SQL insertion robustly, supporting scalable report management without custom coding.