ryanpraski

function main(){
    
    // Set up the parameters  and variables
    var sheetName = '<name>'; // The name of the sheet (not the Spreadsheet) we want to write the data e.g Sheet1
    var tableId = '<table id>'; // The id of the view to query the data from e.g ga:123456
    var startDate = 'yyyy-MM-dd'; // The start date of the query with the appropriate format e.g 2018-04-01 (1 April 2018)
    var endDate = 'yyyy-MM-dd'; // The end date of the query with the appropriate format e.g 2018-04-30 (30 April 2018)
   
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = spreadsheet.getSheetByName(sheetName);

ryanpraski

//Replace xxx with your values as necessary.

function googleAnalyticsReporting() {
  projectId = "xxx";
  datasetId = "xxx";
  tableId = 'xxx';
  data = [];
  yesterday = new Date();
  yesterday.setDate(yesterday.getDate() - 1);
  yesterday = Utilities.formatDate(yesterday, 'UTC', "yyyy-MM-dd");

ryanpraski

function uploadData() {
    var accountId = "xxxxxxxx";
    var webPropertyId = "UA-xxxxxxxx-x";
    var customDataSourceId = "xxxxxxxx";
    var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var maxRows = ss.getLastRow();
    var maxColumns = ss.getLastColumn();
    var data = [];
    for (var i = 1; i <= maxRows; i++) {
        data.push(ss.getRange([i], 1, 1, maxColumns).getValues());