ERPNext Intregrated with Google Sheet

[Gupta_123]

I want to fetch data from ERPNext to Google Sheets in Realtime using Google Script

function fetchERPNextData() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();

var url = ‘https://dkexports.frappe.cloud/api/resource/Material%20Request?fields=[“material_request_type”,“transaction_date”,“workflow_state”]’;

var options = {
‘headers’: {
‘Authorization’: 'Bearer ’ + ‘08ac14a7da405accf328c58ced0149c423a75a8d6dd3982f4be56d07’
}
};
var response = UrlFetchApp.fetch(url, options);
var data = JSON.parse(response.getContentText()).data;
var rows = [];
data.forEach(function(row) {
rows.push([row.material_request_type, row.transaction_date, row.workflow_state]);
});
sheet.getRange(sheet.getLastRow()+1, 1, rows.length, rows[0].length).setValues(rows);
}

Error in Snap