Trying to append a Row instead of updating the existing one

[Facxo]

Hello guys, I was trying with some code tweaks to append a row instead of updating the existing one, but I can't figure out how. Is there anyone who can help me?

Really appreciated.

This is the code:

/**
*

• Export Facebook Ads Data to Google Sheets
• Pushes the Facebook asynchronous report to Google Sheets
• Version: 2.2
• Google Apps Script maintained by Frederic Harnois
• fred@fredericharnois.com

**/

// MODIFY YOUR SETTINGS HERE //

// url of the google sheets where the report will be
const SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/1tUZodzO9FK6uQyz8pDqAeKIAvIsmiHQ5yRYkqObJDWM/'

// name of the sheet where the report will be
const TAB_NAME = 'Report'

// DO NOT MODIFY ANYTHING BELOW //

function getFacebookReport() {

// Selects the chosen sheet and tab
const ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
const sheet = ss.getSheetByName(TAB_NAME);

// Clears the sheet
sheet.clear();

// Gets the Facebook report run ID
const cache = CacheService.getScriptCache();
const reportId = cache.get('campaign-report-id');

// Fetches the report as a csv file
const url = https://www.facebook.com/ads/ads_insights/export_report?report_run_id=${reportId}&format=csv&access_token=${TOKEN};
const fetchRequest = UrlFetchApp.fetch(url);
const results = Utilities.parseCsv(fetchRequest);

// Pastes the csv file in the sheet
sheet.getRange(1,1, results.length, results[0].length).setValues(results);

}

PS: This tool is magic!

[Facxo]

Hello, I managed to create a new row when importing data:

sheet.getRange(sheet.getLastRow()+1,1, results.length, results[0].length).setValues(results);

But now it appends the header too. How can I solve this?

[Facxo]

Hello again,

for anyone facing my same issue, I finally came to a solution:

function getFacebookReport() {

// Selects the chosen sheet and tab
const ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
const sheet = ss.getSheetByName(TAB_NAME);

// Clears the sheet
// sheet.clear();

// Gets the Facebook report run ID
const cache = CacheService.getScriptCache();
const reportId = cache.get('campaign-report-id');

// Fetches the report as a csv file
const url = https://www.facebook.com/ads/ads_insights/export_report?report_run_id=${reportId}&format=csv&access_token=${TOKEN};
const fetchRequest = UrlFetchApp.fetch(url);
const results = Utilities.parseCsv(fetchRequest);
var resultsNoHeader = results.splice(1,results.length-1)

// Pastes the csv file in the sheet
sheet.getRange(sheet.getLastRow()+1,1, results.length, results[0].length).setValues(resultsNoHeader);

}

And this should work.

Peace