Split Multiple Items into Spreadsheet

Hello everyone,

I am quite new to n8n and have already tried a bit.
I am currently facing the challenge that I have to implement the following:

There are >1000 items in an Excel list.
Content approx. company name, contact person, zip code, purchased item, quantity, date of purchase.

These must be sorted according to the name of the company and all entries of these companies must be split into individual spreadsheets.

I have already tried split, combine, loop over etc. but I can’t really find a way to cut out the companies from the file and divide them into one or more spreadsheets.

Do you have an Tip for me?

  • n8n version: latest
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

1 Google sheets - read rows, return all rows
2. Set node - Options fields to exclude - put the name of the column to exclude
3. Google Sheets - append in another sheet without column