Output Any Google Ads Scripts Report to a Sheet

/*

    _   ___ _   _ _____ ___   _     
   /_\ / __| | | |_   _/ _ \ (_)___ 
  / _ \ (__| |_| | | || (_) || / _ \
 /_/ \_\___|\___/  |_| \___(_)_\___/


*/

var config = {
    accountIds: ['151-492-2039', '489-048-0776'], // A comma-separated list of Google Ads account IDs. Max 50. Ignore if running in a single account.
    query: 'SELECT AccountDescriptiveName, Clicks, Cost, Date FROM ACCOUNT_PERFORMANCE_REPORT DURING LAST_30_DAYS', // A Google Ads Scripts report query
    spreadsheet: 'https://docs.google.com/spreadsheets/d/12pgsJQDbqbPdrZLBFbmQEyk47yQ8TidAmwKDLgMAmqQ/', // The URL of the spreadsheet this will be output to
    sheetName: 'Data', // The name of the sheet (i.e. the tab) of the spreadsheet into which the data will be added
};

function main() {
    try {
        AdsManagerApp.accounts().withIds(accountIds).executeInParallel('getReports', 'processAccounts');
    } catch (e) {
        Logger.log(e);
        var data = getReports();
        outputReports(data);
    }
}

function getReports() {
    Logger.log('Now running in ' + AdsApp.currentAccount().getName());
    var data = [];
    var report = AdsApp.report(query);
    var rows = report.rows();
    while (rows.hasNext()) {
        var row = rows.next();
        var dimensions = Object.keys(row).filter(function (attr) {
            if (typeof row[attr] === 'string') return attr;
        });
        var rowObj = {};
        dimensions.forEach(function (dimension) {
            rowObj[dimension] = row[dimension];
        });
        data.push(rowObj);
    }
    return JSON.stringify(data);
}

function processAccounts(results) {
    var allData = [];
    for (var i = 0; i < results.length; i++) {
        var result = results[i].getReturnValue();
        allData = allData.concat(JSON.parse(result));
    }
    outputReports(allData);
}

function outputReports(data) {
    var output = [];
    var headers = Object.keys(data[0]);
    output.push(headers);

    data.forEach(function (row) {
        var arrayRow = [];
        for (var cell in row) {
            arrayRow.push(row[cell]);
        }
        output.push(arrayRow);
    });

    var spread = SpreadsheetApp.openByUrl(spreadsheet);
    var sheet = spread.getSheetByName(sheetName);
    sheet.clearContents();
    sheet.getRange(1, 1, output.length, output[0].length).setValues(output);
}