Scraping company names for my CRM but getting Formula Parse Error
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.
Formula:
=importxml ("https://exhibitormanual.oceanbusiness.com/", "//*[@id="drts-platform-render-66fc2684827da-2-post-20696"]/div/div/div[2]/div[1]/a")
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]"))))
- Stacking output of Google Sheets Queries together - Top 3 Dishes per Restaurant
- Why does this reverse loop give me an error in Google Apps Script?
- How to generate random data of birth dates using google spreadsheets for a specific years?
- Extract certain character set from cell
- How can I get adjacent values from one sheet and sum them up based on the content of another cell in the current sheet?
- How to add work hours to a date with time?
- Google Spreadsheet ||Typeerror : cannot read property '0'
- How can I copy over records from one tab to another for a specified criteria?
- google sheets IMPORTXML for currency prices
- Scraping last 12 month's data for a webpage with dynamic form fields using Google Apps Script
- Sheets, conditional formatting
- Google Sheets onEdit function
- Google Doc onOpen will not fire when spreadsheet is accessed
- Scraping company names for my CRM but getting Formula Parse Error
- Using IMPORTXML to scrape dropdown data from webpage
- Google Sheet IMPORTRANGE Error "Import Range internal error" When Range is just a column
- Importing a table from website into google sheets
- How can I create a conditional path to another section in google form base on what user put in their short answer?
- Append cell range to end of different row based on column 1 values
- Google spreadsheet query formula - join like
- list of dates associated with name
- Excel or Google Sheets: Sum based on criteria in another column
- How to organise form responses in Google Spreadsheets
- Sort range by order of values in separate column
- Drag and copy range vertically from spreadsheet google
- Extract matching data from varying number of row
- Highlighting duplicates over multiple rows using conditional formatting
- How can I do dynamic / dependent drop downs in Google Sheets?
- Sort Query Totals for rows in Google Sheets
- Google Sheets export format set to CSV, downloads xlsx