I have an ads script which exports data to a sheet based on rules.

However, I only want to replace data within a certain cell range such as 'A2:J' within a Google sheet.

I know how to do this within spreadsheetApp script but unsure/struggling on Ads script/AWQL.

I have pasted the basics of the script below but really could do with insight into whether and how it is possible to push to a specific range.

function main(){ // Put your Google data sheet here var sheetURL = ''; // Enter the tab name here var tabName = ''; var QUERIES = [{'query' : 'SELECT Date, DayOfWeek, HourOfDay, Device, CampaignName, Impressions, Clicks, Cost, Conversions, ConversionValue ' +                         'FROM CAMPAIGN_PERFORMANCE_REPORT ' +             'WHERE Impressions > 0 ' +                       'DURING TODAY',                       //'DURING ' + dateRanges,             'spreadsheetUrl' : sheetURL,             'tabName' : tabName,             'reportVersion' : 'v201809'            }                       ]; //This is to gather the above query and push it to the spreadsheet stated above   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;     //Logger.log(spreadsheetUrl + " " + query);     var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);     var sheet = spreadsheet.getSheetByName(tabName);     var report = AdWordsApp.report(query, {apiVersion: reportVersion});     report.exportToSheet(sheet);   } }