Convert Venmo statement CSV file to QuickBooks CSV import

🧾 Say goodbye to manual Venmo-to-QuickBooks formatting! This automated workflow transforms raw Venmo CSV exports into QuickBooks-ready files and backs them up seamlessly to Google Drive or Dropbox.

⚙️ What This Workflow Does:

📤 1. Accepts a Venmo CSV Upload — Triggers on form submission to upload a .csv Venmo transaction file.

📂 2. Extracts Raw CSV Data — Reads the uploaded file and prepares it for processing.

🛠️ 3. Generates a Smart File Name — Dynamically names the output file using the transaction month and timestamp: QBVenmoYYYY-MMHHMM.csv.

🔄 4. Converts Raw Venmo Data — Filters invalid rows and transforms valid transactions into QuickBooks-friendly format:  • Standardizes field names (e.g., Amount (total) → Amount)  • Builds descriptive transaction summaries based on context (e.g., transfers vs payments)

📝 5. Creates a New CSV File — Structures the processed data into a new downloadable CSV.

☁️ 6. Saves to Google Drive — Automatically uploads the finalized file to your selected folder in Google Drive.