AdWordsApp

var QUERIES = [{'query' : 'SELECT AdGroupId, Id, Conversions, ConversionTypeName ' +
                'FROM   KEYWORDS_PERFORMANCE_REPORT ' +
                'DURING LAST_30_DAYS',
                'spreadsheetUrl' : 'https://docs.google.com/spreadsheets/d/1dTabZccccccc/edit#gid=0',
                'tabName' : 'Conversion Types',
                'reportVersion' : 'v201809'
               },
               {'query' : 'SELECT CampaignName, Clicks, Impressions, Cost ' +
                'FROM   CAMPAIGN_PERFORMANCE_REPORT ' +
                'WHERE  Impressions > 10 ' +
                'DURING LAST_30_DAYS',
                'spreadsheetUrl' : 'https://docs.google.com/spreadsheets/d/1dTabZzzzzzzzzzzzSB77pw/edit#gid=0',
                'tabName' : 'Campaigns',
                'reportVersion' : 'v201809'
               }
              ];


function main() {
  for(var i in QUERIES) {
    var queryObject = QUERIES[i];
    var query = queryObject.query;
    var spreadsheetUrl = queryObject.spreadsheetUrl;
    var tabName = queryObject.tabName;
    var reportVersion = queryObject.reportVersion;
    var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
    var sheet = spreadsheet.getSheetByName(tabName);
    var report = AdWordsApp.report(query, {apiVersion: reportVersion});
    report.exportToSheet(sheet);
  }
}