2 Comments

It's a funky one for sure buddy, also Happy New Year! If we look at the docs a bit closer:

IMPORTHTML(url, query, index)

url - the URL of the website to retrieve the HTML.

query - "table" or "list" this tells the Google HTML parser what data to extract.

index - which table or list on the page? some pages have multiple, so this number at the tail end tells it which one, you can test this on a page with multiple,different tables and then change the index to see how the data import changes.

Let me know if this helps!

Expand full comment

Hey, Justin. The structure of that Google Sheets query looks funky. And it yields an error when it's run in a spreadsheet. I've never seen an IMPORTHTML function that didn't have a numeral as the last character in the query (prior to the closing paren). For example =IMPORTHTML("SOMEURL", "INDEX", 2). The general structure of these kinds of queries is illustrated here: https://support.google.com/docs/answer/3093339?hl=en Unless, of course, I'm just thinking/doing something stupid.

Expand full comment