---
title: "Putting values from of all Google Sheets in Google Drive folder into a master Sheet with low process cost using Google Apps Script"
author: "Martin Hawksey"
date: 2023-02-20T21:06:15+00:00
modified: 2023-02-20T22:33:29+00:00
canonical_url: https://pulse.appsscript.info/p/2023/02/putting-values-from-of-all-google-sheets-in-google-drive-folder-into-a-master-sheet-with-low-process-cost-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/02/putting-values-from-of-all-google-sheets-in-google-drive-folder-into-a-master-sheet-with-low-process-cost-using-google-apps-script.md
categories:
  - "Intermediate"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "tanaikech.github.io"
featured_image: https://pulse.appsscript.info/files/2023/02/fig1-1.png
description: "Some clever scripting from Kanshi Tanaike to combine individual Google Sheets in a Google Drive folder into a single master sheet. To achieve this the solution uses the Google Sheets Advanced Service combined with UrlFetchApp.fetchAll() to asynchronous process the source Google Sheets. It’s reported that this method was able to process 50 source sheets in 10 seconds!!! There are some limitations to be aware of highlighted in the source post, but for a method to quickly process a lot of data this solution is definitely one to keep in mind."
---

# Putting values from of all Google Sheets in Google Drive folder into a master Sheet with low process cost using Google Apps Script

![Putting values from of all Google Sheets in Google Drive folder into a master Sheet with low process cost using Google Apps Script](https://pulse.appsscript.info/files/2023/02/fig1-1.png)

 

> [https://tanaikech.github.io/2023/02/03/putting-values-of-all-spreadsheets-in-folder-to-master-spreadsheet-with-low-process-cost-using-google-apps-script/](https://tanaikech.github.io/2023/02/03/putting-values-of-all-spreadsheets-in-folder-to-master-spreadsheet-with-low-process-cost-using-google-apps-script/)
> This is a sample script for putting the values of all Spreadsheets in a folder to the master Spreadsheet with a low process cost using Google Apps Script.

Some clever scripting from Kanshi Tanaike to combine individual Google Sheets in a Google Drive folder into a single master sheet. To achieve this the solution uses the Google Sheets Advanced Service combined with `[UrlFetchApp.fetchAll()**](https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetchallrequests)` to asynchronous process the source Google Sheets. It’s reported that this method was able to process 50 source sheets in 10 seconds!!! There are some limitations to be aware of highlighted in the source post, but for a method to quickly process a lot of data this solution is definitely one to keep in mind.

Source: [Putting Values of All Spreadsheets in Folder to Master Spreadsheet with Low Process cost using Google Apps Script**](https://tanaikech.github.io/2023/02/03/putting-values-of-all-spreadsheets-in-folder-to-master-spreadsheet-with-low-process-cost-using-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/02/putting-values-from-of-all-google-sheets-in-google-drive-folder-into-a-master-sheet-with-low-process-cost-using-google-apps-script/](https://pulse.appsscript.info/p/2023/02/putting-values-from-of-all-google-sheets-in-google-drive-folder-into-a-master-sheet-with-low-process-cost-using-google-apps-script/)*