Creating multiple google sheets from one google sheet using column data

I’m new to Make so please bare with me if there is a simple solution to this. I haven’t begun this process yet so no screenshots.

I’m in the process of parsing data from a Google sheet. The sheet itself is massive (31 columns, 200,000+ rows)

I want to filter the rows by grouping it in alphabetical order and create new sheets for every group (Sheet for A’s, B’s, etc.)

What might be a good method of doing this? What would the best starting module?
Thank you!

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of five modules:

Insert the field/column with the group identifier here


You might need to try different types of aggregators to suit the purposes of the Batch Insert Values step, e.g.:

For the Batch/Bulk insert step, here’s some examples:

Give it a go and let us know if you have any issues!