How To Create An Automatic Monthly Google Ads Pacing Sheet

				
					function main() {

  // Select the accounts to be processed (all of them).
  var accountIterator = MccApp.accounts()
  .get();
 
  // Set the Spreadsheet that you want to add data to.
  var SPREADSHEET_ID = 'PASTE YOUR SHEET ID HERE';
  var SHEET_NAME = 'Monthly Spend';
 
  // Open sheet in spreadsheet
  var ss = SpreadsheetApp.openById(SPREADSHEET_ID);
  var sheet = ss.getSheetByName(SHEET_NAME);
 
  // Clear yesterdays contents
  sheet.clearContents();
 
  // Add heading rows
  sheet.appendRow(['Name', 'Account ID', 'Cost']);
 
  // First we take the accountIterator variable from before
  while (accountIterator.hasNext()) {
    // And, for each account, we save the data into another variable
    var account = accountIterator.next();
    // Switch to the account you want to process.
    MccApp.select(account);
    // Now we can do something
    // Generate account level query
    var report = AdWordsApp.report(
      'SELECT ExternalCustomerId, Clicks, Impressions, Cost, Ctr ' +
      'FROM ACCOUNT_PERFORMANCE_REPORT ' +
      'DURING THIS_MONTH');
    // Get the results and save them into a variable
    var rows = report.rows();
    while (rows.hasNext()) {
      var row = rows.next();
      var cost = row['Cost'];
      var id = row['ExternalCustomerId'];
    }
   
    Logger.log(account.getName() + ", " + id + ", :" + cost);
    sheet.appendRow([account.getName(), id, cost]);
  }

 
 
  Logger.log(ss.getName());

}