Google Sheets IMPORTXML - Scrape Exhibitor List
Screenshot of company names: Trying to scrape company names for my CRM (Google Sheets), but getting Formula Parse Error.
Website: https://exhibitormanual.oceanbusiness.com/
Tried to change child/class as a xpath quary parameter. Tried also IMPORTHTML.
Used code: =importxml ("https://exhibitormanual.oceanbusiness.com/", "//*[@id="drts-platform-render-66fc2684827da-2-post-20696"]/div/div/div[2]/div1/a")
Formula parse Error.
Solution
Here's one approach which pulls the 293 company names spread across 2 pages; some unwanted titles(top 11) are pulled as well. You can mess around with the code if you want a more targeted xpath:
=reduce(tocol(,1),sequence(2),lambda(a,c,vstack(a,importxml("https://exhibitormanual.oceanbusiness.com/?_page="&c&"&num=200&sort=post_title","//*[@title]"))))
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- Split cell with dates and find matching dates on headers
- How can I determine if a respondent's email address is unique in a list?
- ARRAYFORMULA in GOOGLE SHEETS
- Add title row with ARRAYFORMULA in Google Sheets
- API call to directory.members.insert failed with error: Resource Not Found: groupKey
- How to find common words in two columns in Google Sheets
- Get list of unique words without numbers and symbols from paragraph range in Google Sheet?
- Apps Script Delete Image
- App Script to download specific cells in Google Sheet to PDF
- Export Google Docs comments into Google Sheets, along with highlighted text?
- INDIRECT function in an INDEX-MATCH-MATCH
- How to write to a "Google Spreadsheet" from Excel 2003 VBA
- How to use date with LIKE inside query?
- Know if the cell is being used in any formula
- Auto-Resize column in Google Sheet
- autoResizeColumns Takes Too Long to Process
- autoResizeColumn works incorrectly not works as expected
- How to copy a range of data to another google sheet using google apps script?
- How to get a list of unique unknown words from a google sheet
- How can I get the date index match and run script
- Google Sheets - returning Nth result with multiple matching criteria
- Save Google sheet data onEdit in other sheet update duplicate data
- IF Status Formula Google Sheet Approval
- Unable to open Google xlsx spreadsheet / Also Google Drive permission Blocked
- Turn a list of dates into Fridays Only
- Calculate difference of values in specific range of time in Excel
- Select from series of columns without blanks and then where Google Sheets query
- Allow user with edit privileges to run scripts on a spreadsheet owned by me
- Delete last row with value then find