Android手机中的谷歌页面自动刷新

Question

我在我的Android手机上有一个google单查询很好.

=QUERY(ARRAYFORMULA(IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UNIQUE({IMPORTHTML("https://niftyinvest.com/indices","Table",1);IMPORTHTML("https://niftyinvest.com/indices","Table",2);IMPORTHTML("https://niftyinvest.com/indices","Table",3);IMPORTHTML("https://niftyinvest.com/indices","Table",4)})，"arrow_drop_up“、"")、"arrow_drop_down”、")、"*“、”“))、”选择Col1、Col4、Col7、Col3、Col6、Col9、Col10")

现在我想让它每20分钟自动刷新一次。有人能帮我吗？请记住我用的是Android手机。

Answer 1

尝试：

=QUERY(ARRAYFORMULA(IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UNIQUE({
 IMPORTHTML("https://niftyinvest.com/indices","Table",1);
 IMPORTHTML("https://niftyinvest.com/indices","Table",2);
 IMPORTHTML("https://niftyinvest.com/indices","Table",3);
 IMPORTHTML("https://niftyinvest.com/indices","Table",4)}),
 "arrow_drop_up"," "),"arrow_drop_down",""),"*",""))),
 "Select Col1, Col4, Col7, Col3, Col6, Col9, Col10", ROUND(NOW()-NOW()))

通过以下方式：

​

​