[SOLVED] Extract CSV from API and Upload to Google Sheets 😖
Hey everyone! I’m trying to build a workflow in n8n that does the following: 1. Makes an API request to Lemlist to export leads in CSV format. 2. Converts the CSV to JSON. 3. Uploads the data to Google Sheets. 🔍 The issue I'm facing: - The HTTP Request node (using Lemlist API credentials) doesn’t allow me to change the Response Format to "File", so the CSV is returned as a plain string, not as a binary file. - Because of that, the Extract from File node throws an error, since it expects a binary input (data), but there’s none. - I tried parsing the CSV manually using a Function node, but it's becoming messy and unreliable with complex CSVs (commas inside values, quoted fields, etc.). ❓ What I’m looking for: - A solid method to parse the CSV string to JSON inside n8n without data issues. Any help or pointers would be massively appreciated! 🙏Thanks in advance.