I simply need to extract 3 columns of data from a CSV containing multiple columns (say 12) in a specific order - clean up the data format - and then write to a new sheet.
I have a flow:
Start: n8n form submission (to upload csv)
→ extract from csv
→ edit field (to set 3 columns to extract)
→ Google Sheet (to append data)
→ Code (to cleanup trailing apostrophes)
→ convert to file
→ Send Gmail (with CSV attached).
Credentials required for Sheets and Email or set correctly. The flow executes perfectly. The only changes made to SWITCH test environment to production, is to ACTIVATE flow and to use the PRODUCTION URL in the n8n form.
Yet the production environment works without error, but outputs an empty file - just the three headers with no content. This does not happen in test, where I get the CSV file in my email perfectly.
There are NO ERROR Messages in either flow.
Information on your n8n setup
instance information
Debug info
core
1.77.3
Source Code
GitHub - n8n-io/n8n: Fair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations.
License
Sustainable Use License + n8n Enterprise License
Instance ID
1194af871ae887fe6358d9a1a8c9b0b90d1d711fa93d2166d28460cb411a9a25
- n8nVersion: 1.77.3
- platform: docker (cloud)
- nodeJsVersion: 20.18.2
- database: sqlite
- executionMode: regular
- concurrency: 5
- license: community
- consumerId: 00000000-0000-0000-0000-000000000000
storage
- success: all
- error: all
- progress: false
- manual: true
- binaryMode: filesystem
pruning
- enabled: true
- maxAge: 168 hours
- maxCount: 2500 executions
client
- userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/132.0.0.0 safari/537.36 edg/132.0.0.0
- isTouchDevice: false
Generated at: 2025-02-11T05:09:28.863Z