This n8n workflow automates the process of gathering and packaging audit documentation for streamlined review and sharing. It is triggered manually and performs several sequential steps to collect, enrich, and prepare evidence files, then sends them via email.
The workflow begins when a user clicks ‘Execute workflow,’ activating the process. First, it loads audit logs from a Google Sheets document, capturing key information about the audit activities. Next, it fetches relevant evidence files from Google Drive, which are linked to the audit logs.
To prepare these files for distribution, the workflow merges the audit logs and evidence files into a single data stream. It adds a ‘control_id’ to each file to facilitate identification or categorization. Afterwards, individual evidence files are downloaded from Google Drive.
The downloaded files are then compressed into a zip archive, simplifying the transfer and review process. Finally, the entire package is sent via email through Gmail, allowing stakeholders to access all necessary documentation in a consolidated format.
This workflow is ideal for audit teams needing a quick, automated way to assemble and distribute audit evidence, ensuring consistency, saving time, and reducing manual effort in documentation handling.
Reviews
There are no reviews yet.