Copy and Update Google Apps Script to Multiple Files: GAS104

August 20, 2024

Copy and Update Google Apps Script to Multiple Files: GAS104

Introduction

If you are looking for a solution to copy or update your scripts to multiple files on your Google Drive without publishing your project to Google Workspace Marketplace, you may find the right place. In this Google Apps Script project, I am sharing this app. You can easily copy the script from a source file to multiple targets by using Google Apps Script API.

YouTube

Check this video if you prefer to watch the video instructions.

Instructions (6 Steps)

Follow the steps below to set up your own project.

Step 1

Make a copy of my project to your Google Drive, the attached script will be included in the copy.

GAS104 Copy & Update Scripts to Multiple Files

Step 2

Create a Google Cloud project (GCP) and enable Google Apps Script API in the cloud project. Follow the guide below if you are not familiar with this process.

A Complete Guide to Setup GCP for GAS

Step 3

Open the Apps Script project from the copied Google Sheets by going “Extensions > Apps Script”, connect the Google Cloud Project in the settings by using the GCP project number.

Step 4

Make sure Google Apps Script API is enabled by going to the link below.

https://script.google.com/home/usersettings

Step 5

Complete the authorization requirement by clicking either “Fetch Scripts” or “Copy Scripts” button in the Master tab. Follow the guide below if you are not familiar with the process.

A Complete Guide to Authorize GAS Project

Step 6

Enter the URL of the source of the Apps Script file you want to copy in cell “B6”.

Copy from Script ID or URL From - The ID or URL of the script file which should be copied from
To the Target Files - The URLs of any Google Sheets, Docs, Slides, Forms in column F
Fetch Scripts - The script fetches the all script files from the source file
Copy Scripts - Copy the selected script files to the target files

* Only the selected file will be copied to the target