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!