Google Drive >> CSV >> Google Sheet update

Questions
1

Hi. I built rather simple workflow intended to create a sheet in a Google Spreadsheet, and populate it with data from the csv file.

  • get the CSV file from the GDrive folder
  • extract current month from the file name and use it to create the sheet with the same name (in a master spreadsheet)
  • get the data from the actual CSV file
  • upload this data to the newly created sheet

It works pretty well, except it creates an empty row in the sheet (a result of merge node, which I need to have an access to a) name of the sheet and b) the data from the CSV file).

IF node doesn’t work, because when I filter the empty row out, I don’t have access to that name anymore thus I’m unable to find the sheet.

Any suggestions how to make this smoother appreciated!

Information on your n8n setup

  • n8n version: self-hosted 1.76.1
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Linux
2

Hi!

Try using the format below, where aggregate adds the data from merge input 0 to data[0] and input 1 data to data[1]. The split node has been configured to work only with the data data[1].