How do you put ONLY one column in a row from a website into a google sheet

Question

I'm trying to get ONLY one column in a row from a website into my google sheet. I attached some screenshots to further explain.

I would like to place the formula in row 8, column Q in my sheet. The first screenshot just shows what links me to the webpage based on what's in cell/column "A", but I still have to manually input what's in the webpage as it updates. I want the info from the webpage to automatically go into the google sheet.

I've tried

=INDEX(IMPORTHTML("https://nakedshortreport.com/company/",A8;"htable"),2,7)

=INDEX(IMPORTHTML("https://nakedshortreport.com/company/"&A8&"&in=","table",0),2,3)

=QUERY(IMPORTHTML("https://nakedshortreport.com/company/",A8, "table", 1), "SELECT row2, Col7")

But none of the formulas are working.

screenshot 1

screenshot 2

1

share a copy of your sheet – player0 Sep 09 '21 at 07:40

player0 · Answer 1 · 2021-09-12T20:55:02.040

0

try:

=QUERY(QUERY(IMPORTHTML(
 "https://nakedshortreport.com/company/"&A8; "table"; 1); 
 "select Col7"); "offset 1 limit 1"; 0)

update

site you are trying to import from uses JS and google sheets does not support importing JS elements...

edited Sep 12 '21 at 20:55

answered Sep 09 '21 at 07:57

player0

124,011
12
67
124

when I use that formula it says #N/A in the cell and shows "imported content is empty" when I hover over the cell with my mouse. – hank130 Sep 11 '21 at 07:43
@hank130 can you share a copy of your sheet? – player0 Sep 11 '21 at 19:47

score 0 · Answer 2 · answered Sep 13 '21 at 09:41

Content from this website is loaded dynamically via script, which makes it unreachable via formulas like IMPORTHTML.

You can check that by disabling JavaScript and refreshing the page: you'll get the following message:

You need to enable JavaScript to run this app.

The content is not accessible via UrlFetchApp either.

How do you put ONLY one column in a row from a website into a google sheet

2 Answers2

update

Related: