1ndrei

function myFunction() {
let url = "https://*********/rest/7/*******/crm.lead.add.json/"
// let data = {'TITLE': 'Testing lead'}
let data = {
'fields':{'TITLE': 'Testing lead'}
}
let options = {
'method': 'post',
'contentType': 'application/json',
'payload': JSON.stringify(data)
};

UrlFetchApp.fetch(url, options)
}

=query(importrange(“ключ_таблицы”;”Контакты!A1:J”); "select * where Col9 contains 'мой'")

Перепишите так:
cell.setFormula('" "&"' + str+'"');

или так:

cell.setFormula('""&"' + str+'"');