function main() {
  exportReportToSpreadsheet();
}

function exportReportToSpreadsheet() {
  var spreadsheet = SpreadsheetApp.create('Shopping Performance');
  var report = AdWordsApp.report(
    'SELECT CampaignName, Clicks, Impressions, Cost, Brand, CategoryL1, CategoryL2, CategoryL3, CategoryL4, CategoryL5 ' +
    'FROM   SHOPPING_PERFORMANCE_REPORT ' +
    'WHERE  Impressions > 0 ' +
    'DURING LAST_30_DAYS');
  report.exportToSheet(spreadsheet.getActiveSheet());
}