The following Google Apps Script is designed to organise a large Google Sheet of data into a specific category and then populate a Google Sheet template file with it. In this example our main data consists of these columns:
- URLs
- Last Update Time
- Creator Email
- Owner Email
- Incompatibility Reason
We want to organise the jumbled data so that we gather together all the rows of the same Owner Email address and pop these into a separate Google Sheet, which is then shared ('edit' access). Repeating this process for the next unique Owner Email address.
 |
| Collate and organise a Sheet of data by Owner Email |
