google sheets script sample export csv file in C drive
function convertRangeToCsvFile_(csvFileName, sheet) { try { var data = sheet.getDataRange().getDisplayValues(); if (data.length > 1) { var rows = []; data.forEach(row => { var cols = []; row.forEach(col => { cols.push(`"${col.replace(/"/g, '""')}"`); }); rows.push(cols.join(',')); }); return rows.join('\n'); } } catch(err) { Logger.log(err); Browser.msgBox(err); } }