Import Sheets to BigQuery
Google scripts: format columns with loops and arrays
function loopit_percentages() { var percentcols = ['D', 'E','F'] for (var k = 0; k<= percentcols.length -1; k++) { for (var i = 1; i<=20;i++) { var rng = percentcols[k] + i.toString() Logger.log(rng) SpreadsheetApp.getActiveSheet().getRange(rng).setNumberFormat("0.00%") }}}
function…