Make a Copy of a Google Sheet with Apps Script

Опубликовано: 11 Март 2025
на канале: Yagisanatode -Scott-

6,286

In this tutorial, we cover how to duplicate Google Sheets spreadsheets, with Google Apps Script.

1. First, we will use the 'copy' method in the SpreadhseetApp API that will save your file in My Drive.
2. Next, we will explore how to create a new spreadsheet with the DriveApp API and save that file in the same drive as the source sheet.

To the Starter Sheet!: https://docs.google.com/spreadsheets/...

You can learn more about duplicating Sheets, sheet tabs and ranges in the playlist below: • Copy Spreadsheets, Sheet Tabs and Ran...

00:00 Intro
00:47 Make a Copy of A Spreadsheet
05:04 Copy to Same folder as Source Google Sheet

** My Site **
https://yagisanatode.com/

** More on Google Apps Script **
https://yagisanatode.com/google-apps-...

** Products **
Create and Publish Google Workspace Add-ons with Google Apps Script: Master Class https://yagisanatode.com/products/cre...

Courses *
https://yagisanatode.com/products-cat...

Google Workspace Tools *
https://yagisanatode.com/products-cat...

Google Workspace Add-ons *
https://yagisanatode.com/products-cat...

#googleworkspace #googleappsscript #GoogleSheets #GoogeDrive #SpreadsheetApp #DriveApp #admin #googleWorkspace #businessadministration @googleworkspacedevs