Creating multiple google sheets from one google sheet using column data

[Eric_Messihi]

Hi!
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!
-Eric

[samliew]

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:

• How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API? - #3 by samliew
• Clear google sheet before adding new rows - #4 by samliew

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