Description Automatically packages audit-ready evidence files matched to control IDs from ISO 42001 or other frameworks. Fetches logs from Google Sheets, finds corresponding files in Google Drive, compresses them into a ZIP archive, and sends via email — no manual formatting required. Who’s It For: Compliance teams preparing audit documentation GRC consultants managing multiple clients Internal auditors requiring traceable evidence How It Works: Trigger manually or on schedule (e.g., daily) Read

Description Automatically packages audit-ready evidence files matched to control IDs from ISO 42001 or other frameworks. Fetches logs from Google Sheets, finds corresponding files in Google Drive, compresses them into a ZIP archive, and sends via email — no manual formatting required. Who’s It For: Compliance teams preparing audit documentation GRC consultants managing multiple clients Internal auditors requiring traceable evidence How It Works: Trigger manually or on schedule (e.g., daily) Reads audit logs from Google Sheets Searches Google Drive for files matching controlid Downloads matched files Zips them into an archive Sends the archive via email (Gmail or SMTP) Requirements: Gmail or SMTP node for email delivery Google Sheets connected (OAuth2) Google Drive connected (OAuth2) Google Sheet Requirements: Columns: controlid, description, evidencestatus, lastupdated One row per control ID or log entry Headers must be in the first row Log sheet must be shared with your service account or n8n-connected user File Templates: AuditAutoPackSheetTemplate.xlsx Evidence files in Google Drive named using control ID (e.g., ISO42001-5.1.pdf) Customization Tips: Adjust ZIP archive name in the “Zip Files” node Customize email subject, body, and recipient Use a different Drive folder per client or audit phase Ethics & Compliance: Ensures audit trail and evidence traceability Prevents unauthorized edits or file mismatches Setup Instructions Copy the provided Google Sheet template (linked in File Templates). Fill in your audit logs (columns: controlid, description, status, lastupdated). Connect Google Sheets node using OAuth credentials. In the Gmail node: Set recipient email (e.g., youremail@example.com) Choose “Send binary data” and attach ZIP Trigger via Cron node (e.g., daily) or manually (Optional) Connect Drive or S3 node to store a backup copy Supports: ISO 42001 AI Governance PCI DSS v4.0 NIST CSF / SOCI Act ACSC Essential Eight
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.