New sheet from another google sheet data

Questions
1

Hi, I am extremely new to n8n and I would like to ask for the community help.

I have a google sheet that has around 1,5K rows of data, filtered by country (around 69 countries). I would like to separate and group the data per country so I can extract it and create 1 new spreadsheet per country.

So far, I have tried multiple iterations and the closest one, could only create 1 spreadsheet for 1 country but the loop stopped. Any ideas would be appreciated.

For help N8N
For help N8N904×363 40.7 KB

2

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:
3

Hi @Michael_S1

Thanks for posting here and welcome to the community! :tada:

That’s a fun one! I think you don’t even need a loop for that, I had a quick play-around and you could also use something like this:

I haven’t tested it and it might not work perfectly, but at least I hope it will give you some inspiration :slight_smile:

Merry Christmas! :christmas_tree:

4

Hello! Thank you very much for your support, apologies for the late reply. Indeed, got some inspiration. Still not perfect on my side but got something started!

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.