Apr 8 (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
A community built to master no-code AI automations. Join to learn, discuss, and build the systems that will shape the future of work.
Leaderboard (30-day)
1
🔥
+2493
2
🔥
+1133
3
+1057
4
🔥
+887
5
🔥
+723
Powered by