title: Google sheets import XML using Xpath
body: <p>I am trying to import a specific value from a webpage into Google Sheets, such as- <a href="https://solscan.io/tx/5y4ybv6EaiYWJd7xp4paubiHtsTqyt5VfdEWm5NGrrMTiXh3uSCy1qktJkqhHc3njbXi6B7vp8M9EU6pvgDkM6pb" rel="nofollow noreferrer">https://solscan.io/tx/5y4ybv6EaiYWJd7xp4paubiHtsTqyt5VfdEWm5NGrrMTiXh3uSCy1qktJkqhHc3njbXi6B7vp8M9EU6pvgDkM6pb</a></p>
  <p>The value I am trying to import is USDC (in this example 222.83 is the value)</p>
  <p>I am trying to use ImportXML using the Xpath of the element</p>
  <pre><code>//*[@id=&quot;rc-tabs-0-panel-1&quot;]/section[1]/div/div[7]/div[2]/div[2]/div[2]/div[1]/b/text()[1]
  </code></pre>
  <p>by using the following formula</p>
  <pre><code>=IMPORTXML(URL,&quot;//*[@id='rc-tabs-0-panel-1']/section[1]/div/div[7]/div[2]/div[2]/div[2]/div[1]/b/text()[1]&quot;)
  </code></pre>
  <p>However I get the error - 'Imported content is empty.'</p>
  <p>Any help would be appreciated!</p>