Skip to content

Instantly share code, notes, and snippets.

@chipoglesby
Last active November 29, 2020 19:27
Show Gist options
  • Save chipoglesby/81d38c5d40d67689463d to your computer and use it in GitHub Desktop.
Save chipoglesby/81d38c5d40d67689463d to your computer and use it in GitHub Desktop.
Cost Data Upload via Google Analytic's Management API with Google Sheets
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());
}
var newData = data.join("\n");
var blobData = Utilities.newBlob(newData, "application/octet-stream", "GA import data");
try {
var upload = Analytics.Management.Uploads.uploadData(accountId, webPropertyId, customDataSourceId, blobData);
SpreadsheetApp.getUi().alert("Uploading: OK");
}
catch(err) {
SpreadsheetApp.getUi().alert("Cannot upload: Failed");
}
}
@williamjulianvicary
Copy link

I'm also looking for a resolution for "Unknown filename" @jhpacker or @krisijanPetr - did any of you uncover a fix?

Copy link

ghost commented Jul 31, 2018

Hi, did any of you find a solution how to name files via this method? Thanks

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