Importhtml formula

[Betterleague]

Hi, is possible make this googlesheet formula in a virtual culumn?
…IMPORTHTML(“https://sports.yahoo.com/soccer/premier-league/scoreboard/?confId=&schedState=2&dateRange=32";"list”;3)…
i need to work with a text result.
Thanks

[Steve]

Not possible.

[Betterleague]

do you have a any suggestions for getting something like that? capture text from other web pages?

[Steve]

I do not. Perhaps @LeventK does?

[LeventK]

@Betterleague
Directly with the app, no, you cannot. You can do that with scripting and using a standalone web-app, but the results might not be instant.

[Betterleague]

ok thank you!

[Bellave_Jayaram]

It should work as a sheet formula in Gsheets and like Levent said, the data change in the sheet won’t update in the app instantly but after a sync, you can see the data. Would that not work for you?

[Betterleague]

@Bellave_Jayaram yes, this would work, but I wanted to do it in app sheets just to speed up the process