Copy and Paste Range Values from one Google Sheet into another with Google Apps Script

Here is a link to the starter template:
https://docs.google.com/spreadsheets/...

You can get the written tutorial here, along with some bonus material on formatting imported data:
https://yagisanatode.com/2022/02/22/c...

In this tutorial, we cover how to paste a complete set of Google Sheets range values from one Google Sheet to another with Google Apps Script. This tutorial is essentially an Apps Script alternative to the Google Sheets IMPORTRANGE function.

00:00 Intro
00:16 Apps Script over IMPORTRANGE
00:36 Setting up your Google Sheets
02:04 Writing the runsies() function
06:45 The importRange() function
16:53 testing the script
17:26 Applying to multiple import range instances
18:14 Adding a time trigger
19:32 Other approaches

You can find out more about how to append and manipulate Google Sheets data in these tutorials:
- Google Apps Script – Copy Selected Columns in One Sheet and Add Them To The Bottom of Different Selected Columns in Another - https://yagisanatode.com/2018/11/17/g...
- Google Apps Script: Get the last row of a data range when other columns have content like hidden formulas and check boxes [updated Dec 2021] - https://yagisanatode.com/2019/05/11/g...
- Google Apps Script Course – Part 1: 2D Array Data Transformation of Single Question Item Data to Total Count of Choices in Google Sheets - Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets - https://yagisanatode.com/2019/12/22/g...
- Creating Unique Ranges from 2D Arrays in Google Apps Script - https://yagisanatode.com/2020/10/26/c...
- Google Apps Script: Add and removed Google Sheets columns based on a search array - https://yagisanatode.com/2020/03/28/g...

If you like the video, check out my website:
https://yagisanatode.com/

Here is the link to just Google Apps Script tutorials:
https://yagisanatode.com/google-apps-...

Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager

#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Spreadsheets