我在這里存放了從 Google Analytics 獲得的代碼，我的目標是將執行日志中的結果保存到我的 Google 作業表檔案中。我對日志中的內容已經很滿意了，只需將結果顯示為谷歌表格資料。
這是我的代碼：
function listAccounts() {
var accounts = Analytics.Management.Accounts.list();
if (accounts.items && accounts.items.length) {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = sheet.getSheetByName('DATA');
for (var i = 0; i < accounts.items.length; i ) {
var account = accounts.items[i];
Logger.log('Account Name: ' account.name);
Logger.log('Account Id: ' account.id);
//Logger.log('Account Name "%s", id "%s".', account.name, account.id);
}
} else {
Logger.log('No accounts found.');
}
}
感謝您的幫助。
uj5u.com熱心網友回復：
如果你只是想在一張紙上寫下你得到的東西Logger.log()，那么你可以這樣做：
function listAccounts() {
//your log sheet, use getActive() if it's the same sheet
var logSheet = SpreadsheetApp.openById('sheetid').getSheetByName('Sheet name');
var accounts = Analytics.Management.Accounts.list();
if (accounts.items && accounts.items.length) {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = sheet.getSheetByName('DATA');
for (var i = 0; i < accounts.items.length; i ) {
var account = accounts.items[i];
Logger.log('Account Name: ' account.name);
Logger.log('Account Id: ' account.id);
logSheet.appendRow(['Account Name: ' account.name, 'Account Id: ' account.id]);
//Logger.log('Account Name "%s", id "%s".', account.name, account.id);
}
} else {
Logger.log('No accounts found.');
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/418063.html
標籤：