Skip to content

Instantly share code, notes, and snippets.

@mhawksey
Created March 30, 2012 15:15
Show Gist options
  • Star 9 You must be signed in to star a gist
  • Fork 9 You must be signed in to fork a gist
  • Save mhawksey/2252211 to your computer and use it in GitHub Desktop.
Save mhawksey/2252211 to your computer and use it in GitHub Desktop.
Google Apps Script to combine data from different sheets (used in http://mashe.hawksey.info/?p=13130)
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
}
}
}
@jcconnell
Copy link

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