Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Google Apps Script to combine data from different sheets (used in
function combineData(){
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheets = doc.getSheets(); // get all the sheets
var outSheet = doc.getSheetByName("combined"); // set where we want to write the results
for (i in sheets){ // loop across all the sheets
if (sheets[i].getSheetName().substring(0,9) == "followers"){ // if sheetname starts with 'follower' then
var target = sheets[i].getSheetName().substring(12); // extract users name for target column
var data = getRowsData(sheets[i]); // get extisting data from current sheet
for (j in data){
data[j]["target"] = target; // create a target column with the users name
insertData(outSheet, data); // insert data in 'combined' sheet
Copy link

jcconnell commented Jul 26, 2017

Where is the insertData function referenced here?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment