As a game designer and writer, I use fantasynamegenerators.com a lot. I'd like to find a way to import results from these name generators into Google Sheets. I've had some success with other sites, but I'm having no luck here.
This is as far as I've gotten:
- Use developer tools to inspect <https://www.fantasynamegenerators.com/username-generator.php>
- Copy XPath for desired content
//*[@id='result']
- Enter formula in Google Sheets
IMPORTXML(https://www.fantasynamegenerators.com/username-generator.php,"//*[@id='result']/text()")
- I got an "Imported content is empty" error, so I tried a couple XPath variations, including
//*[@id='result']/text()
None of that did the trick, still getting the same error.
Based on this post, I'm guessing that I'm encountering the same issue ("the content is loaded using jQuery") but I can't confirm this because I know nothing about jQuery. I also have no idea how to track down the URL for the jQuery content, as suggested.
Any help is appreciated! If I can find a solution it'll open up a lot of options for my workflow.