Hey everyone! I’m new to using Google Sheets and I’m stuck trying to get audience numbers from Alexa. I’m using the importxml function but it’s not working as expected.
My current formula looks like this:
=importxml(B3, "//section[@id='visitors-content']")
B3 has the website URL. The formula returns N/A instead of an error, so I think I’m close. But I can’t figure out what I’m doing wrong.
Can anyone help me fix this formula or suggest a better way to grab the Alexa audience data? I’d really appreciate any tips or advice. Thanks in advance!
I’ve encountered similar issues with importxml and Alexa data. The problem might be that Alexa’s site uses JavaScript to load content dynamically, which importxml can’t handle. A workaround I’ve found is using a third-party API service that can fetch this data for you. Alternatively, you could try web scraping tools like Parsehub or Octoparse, which can handle dynamic content better than importxml. They have learning curves but are powerful for collecting web data. If you’re set on using Google Sheets, you might need to explore more advanced solutions like Google Apps Script to make HTTP requests and parse the response.
hey there! i’ve had trouble with alexa data too. importxml doesn’t work well cuz alexa uses javascript. maybe try a browser extension like similarweb for quick stats? or check out SEMrush if u need more detailed data. they’ve got free options that might help. good luck!