---
title: "Copy template sheet to Google Sheets and reorder"
author: "Phil Bainbridge"
date: 2019-12-02T22:20:00+00:00
modified: 2019-12-02T22:18:45+00:00
canonical_url: https://pulse.appsscript.info/p/2019/12/copy-template-sheet-to-google-sheets-and-reorder/
markdown_url: https://pulse.appsscript.info/p/2019/12/copy-template-sheet-to-google-sheets-and-reorder.md
categories:
  - "Drive"
  - "Sheets"
  - "Snippet"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2019/11/Template2BSheet.png
description: "Take a template Google Sheet (containing fields for 3 signatures) and copy it into other Google Sheet files within a given Google Drive folder and then reorder those sheets so that it was the first..."
---

# Copy template sheet to Google Sheets and reorder

![Copy template sheet to Google Sheets and reorder](https://pulse.appsscript.info/files/2019/11/Template2BSheet.png)

[![Template sheet with signatures to copy to other files](https://pulse.appsscript.info/files/2019/11/Template2BSheet.png)](https://www.pbainbridge.co.uk/2019/05/copy-template-sheet-to-google-sheets.html)Screenshot of template sheet with signatures to copy to other files

> Take a template Google Sheet (containing fields for 3 signatures) and copy it into other Google Sheet files within a given Google Drive folder and then reorder those sheets so that it was the first one.

The idea was based around needing users to authorise student marks with their signature from multiple Google Sheet reports produced from a third party system.

Source: *[The Gift of Script: Copy template sheet to Google Sheets and reorder*](https://www.pbainbridge.co.uk/2019/05/copy-template-sheet-to-google-sheets.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/12/copy-template-sheet-to-google-sheets-and-reorder/](https://pulse.appsscript.info/p/2019/12/copy-template-sheet-to-google-sheets-and-reorder/)*