//meta[@name='description']/@content
 
 
 //title
 
 
 //meta[@name='keywords']/@content"
 
 
 =importxml("https://davidsottimano.com/how-to-extract-title-meta-data-using-gdocs-xpath-and-importxml/","//title")
=importxml("https://davidsottimano.com/how-to-extract-title-meta-data-using-gdocs-xpath-and-importxml/","//meta[@name='description']/@content")
=importxml("https://davidsottimano.com/how-to-extract-title-meta-data-using-gdocs-xpath-and-importxml/","//meta[@name='keywords']/@content")

=CONCATENER("https://www4.bing.com/search?q=";MINUSCULE(SUBSTITUE(A2;" ";"+"));"+")
 
=IMPORTXML(A1;"//title")	ok
=IMPORTXML(A2,"//title/text()")	bad
=ImportXML(A2,"//meta[@name='Description']/@content")	ok
=ImportXML(A2,"//meta[@name='keywords']/@content"	ok
=ImportXML(A2,"//link[@rel='canonical']/@href")	
 
=ImportXML(A2,"//h1/text()")	bad

Source :
https://davidsottimano.com/how-to-extract-title-meta-data-using-gdocs-xpath-and-importxml/
https://docs.google.com/spreadsheets/d/1N-9MWJIyN3j0tVomXZhupvHCcr-aMbBEzCU2GEYGJFI/edit#gid=0