Tuesday, 29 June 2021

Bulk create Sheets from a Google Sheet

The following Google Apps Script is designed to bulk create Sheets from rows of data within a Google Sheet and to include some of that data within the new file in specific cells. It also creates a link to the new Google Sheet back in the original file on the relevant row.

For those wanting to bulk create Google Docs from a Google Sheet please see this blog post.

Bulk create Google Sheets from a Sheet of data by looping through each row.
Screenshot of Google Sheets data

It takes data from the first four columns and will copy that into the new Google Sheet template file that is created for that row.

There is a Config sheet where you will need to specify some further information:

  1. The ID of the Google Drive folder where you wish to store the newly created Google Sheets.
  2. The ID of the template Google Sheet that is to be copied for each row.
  3. The name of the Sheet/Tab in the template file where data is to be copied to. This option tries to make the tool universal as you may have other data in the Google Sheet that needs to be left untouched.
  4. The four cell references for each piece of data that it to be copied in to the newly created Google Sheet. Again to be universal this allows you to specify exactly which cells you want the information to be put into.

Download

Bulk create Sheets from a Google Sheet download here (please use 'File' > 'Make a copy' for your own version).

No comments:

Post a Comment