URGENT: Converting CSV to a new Google Spreadsheet

Questions
, ,
1

Hi everyone,

This is extremely urgent. I’m trying to set up an n8n workflow to download convert a csv file and create a new Google Spreadsheet and append the data from the csv to that spreadsheet. Sounds easy but I am really getting desperate over this.

Key Details:

  • I’m using the Google Drive Trigger to fetch the file, and want to download that file as csv and then create a new spreadsheet for later use. The problem ist that I cant get it to properly format the data. The CSV file has “,” as delimiter.

My Workflow (Exported JSON):

Information on your n8n setup

  • n8n version: 1.69.2
  • Database (default: SQLite): QLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted in google cloud
  • Operating system: Windows10
2

Tried a different solution. Problem here is that the Convert to XLSX hands no output/empty output.

3

This is what I would do

1 Like
4

Hi @Kiremit, I put this one together and tested it with a sample CSV - it works fine. Hope, this helps. Cheers, Ingo