I have a few web address’s for =ImportHTML and I was following a guide from here to achieve an auto update Apps Script.
The website I’m referencing is: https://support.geckoboard.com/hc/en-us/articles/206260188-Using-Google-Sheets-IMPORTHTML-function-to-display-data-in-Geckoboard
This is an example of one of the imports I’m using:
When I paste just that into google sheets, it does work.
Step 5: Replace with the table position of the page. The web address I’m using doesn’t have a table reference. “//G/@Q” . I’m not sure how to adjust it to work to my address?
The error messages I’ve gotten in sheets:
Formula Parse Error, Function IMPORTHTML parameter 3 expects number values. But ‘//g/@q’ is a text and cannot be coerced to a number.
I’d appreciate the help