# Creating multiple google sheets from one google sheet using column data

**URL:** <https://community.make.com/t/creating-multiple-google-sheets-from-one-google-sheet-using-column-data/28356>\
**Category:** Beginner Questions\
**Tags:** google-sheets\
**Created:** [February 22, 2024, 6:45pm UTC](https://community.make.com/t/creating-multiple-google-sheets-from-one-google-sheet-using-column-data/28356 "2024-02-22T18:45:01Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [February 23, 2024, 2:28am UTC](https://community.make.com/t/creating-multiple-google-sheets-from-one-google-sheet-using-column-data/28356/3 "2024-02-23T02:28:18Z")

</div>

Welcome to the Make community!

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

 ![Screenshot_2024-02-23_100211](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/3/c345acf31859b741ada156d23b070501e00ea697.png)

Insert the field/column with the group identifier here

![Screenshot_2024-02-23_100226](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/802fd2153dc9f2a6a165f6cb391bf69fa56f6e1a.png)

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

 ![Screenshot_2024-02-23_100200](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/4/34f3e7e18552361dc0cec8980d16037cc4ae96c3.png)

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](https://community.make.com/t/how-to-bulk-update-non-consecutive-rows-in-google-sheets-using-the-batchupdate-api/24544/3)
- [Clear google sheet before adding new rows - #4 by samliew](https://community.make.com/t/clear-google-sheet-before-adding-new-rows/26843/4)

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

---

_[View the full topic](https://community.make.com/t/creating-multiple-google-sheets-from-one-google-sheet-using-column-data/28356)._
