Apr '25 (edited) • Support Needed 💻
[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:
- Makes an API request to Lemlist to export leads in CSV format.
- Converts the CSV to JSON.
- 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.
2
5 comments
[SOLVED] Extract CSV from API and Upload to Google Sheets 😖
skool.com/ai-automation-society
Learn to get paid for AI solutions, regardless of your background.
Leaderboard (30-day)
1
+5560
2
🔥
+3948
3
+3572
4
+2212
5
+1101
Powered by