Grab first URL off a Google search result
I'm trying to use the following formula to retrieve the first URL off a Google search result, but I'm getting the error that Imported content is empty. :
=IMPORTXML("https://www.google.com/search?q=cnn&num=1", "//cite")
It looks like the result URL is contained within an cite tag in the results page, but the formula isn't working as expected. I expected this formula would return https://www.cnn.com. Same formula with //h3 as XPath does return the title.
Any idea what I am doing wrong?
Issue:
The cite tag is generated dynamically via script, making it unreachable to formulas like IMPORTXML.
You can see that's the case if you disable JavaScript and refresh the page. You won't see that element anymore.
Workaround:
The URL is also available in a div that is sibling of the h3 element containing the title. This element is not injected dynamically via script, so it can be accessed by IMPORTXML. Retrieve that instead:
=IMPORTXML("https://www.google.com/search?q=cnn&num=1", "//h3/following-sibling::div")
Related:
- A CoinMarketCap App-Script modification to read multiple tickers in google sheets
- Google App Script - Sorry unable to open the file at present
- Google App Script - Json response parsing
- Run a function published in Webapp from a Google site
- How do you resolve a "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues" error
- Google Apps Script getBackgrounds for colour custom function
- Google App Script published as a web app not working?
- Gemini API: "InvalidSignature" in App Scripts
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- How to remove Warning "This application was created by another user, not by Google" in Google Apps for Education
- Create connected drop-downs in google sheets where value can be present only in one drop-down
- Custom sort order according to cell value
- Find and print last edit dates of preexisting rows in a sheet (Google Sheets)
- Google Apps Script creates sheets version of excel file
- If var isnumber, for script
- How do I edit the response of a form submission in Google Forms/Sheets?
- How do I stop Google AppScripts (Sheets) from creating two protected range entries
- paragraph.clear() caused bookmark.getPosition() to shifted
- Transfer Data from one sheet to another
- How to get attachments in Gmail with Google Apps Script that are only attached to the messege itself
- Google App Script to imitate File - Import csv file into a sheet using a custom menu item
- How do i allow a CORS requests in my google script?
- List google drive folder contents where folder is name is based on cell value [solved]
- Adding a for/next loop to existing script [solved]
- Apps Scripts - .getLastColumn() works once in a for loop then errors out
- Error with Docs.Documents.batchUpdate() but the method throws the error after it completes
- Can I find the value of a cell B49 that changes value according to the value of the cell F2 ( in Google sheet)
- What is the GoogleJsonResponseException error when trying to get Drive.comments.list()?
- How to access the cell next to the selected cell in Google sheet using script?
- How to make the cancel Button work in Google App Script Browser Input Box