Transforms raw Venmo transaction CSVs into QuickBooks-ready files with smart naming and backups to Google Drive or Dropbox.
This n8n workflow automates the conversion of Venmo statement CSV files into a format compatible with QuickBooks imports. It starts by accepting an uploaded Venmo CSV via a form trigger, extracts the data, filters invalid rows, and transforms fields like 'Amount (total)' into standardized QuickBooks columns. A dynamic filename is generated using the transaction month and timestamp (e.g., QB_Venmo_YYYY-MM_HHMM.csv) for easy organization.
The workflow then creates a new CSV with descriptive trans
Platform
n8n
Category
Business Intelligence
Price
$12.99
Creator
Bryce Yu
venmo
quickbooks
csv-conversion
accounting
expense-management
google-drive
dropbox
finance-automation
data-transformation
business-intelligence
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.