#1 – Récupérer automatiquement le site web à partir du nom de l’entreprise
=CONCATENER("https://www4.bing.com/search?q=";MINUSCULE(SUBSTITUE(A2;" ";"+"));"+")



https://www4.bing.com/search?q=cartoflex

=IMPORTXML(C1; "//li[@class="&CAR(34)&"b_algo"&CAR(34)&"][1]/h2/a/@href")	→ fail
=IMPORTXML(C2; "//li[@class=’b_algo’][1]/h2/a/@href")	→ fail
=IMPORTXML(C1; "//li[@class=""b_algo""][1]/h2/a/@href")	→ fail
=IMPORTXML(R13;"//li[@class='b_algo']//div[@class='b_title']//h2//a/@href")	→ fail https://forum.excel-pratique.com/sheets/recuperation-d-une-url-du-resultat-sur-bing-151822


=importxml("https://www.qwant.com/?q=cartoflex&t=web";"//p[@class='url']")	// marche pas
=importXML(D1;"//p[@class='url']")


function HTML_BODY(url) {
  const requete = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
  const code = requete.getResponseCode().toString();
  return code[0] == 2 ? requete.getContentText().match(/<body.*<\/body>/si) || 'Erreur : pas de balise body' : 'Erreur ' + code;
}

function HTML_BODY(url) {
  const requete = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
  const code = requete.getResponseCode().toString();
  return code[0] == 2 ? (requete.getContentText().match(/<body.*<\/body>/si) || ['Erreur : pas de balise body'])[0].slice(0, 20000) : 'Erreur ' + code;
}

https://forum.excel-pratique.com/sheets/recuperation-d-une-url-du-resultat-sur-bing-151822