刷新按钮/自动更新Google US preADSHEET [英] Refresh Button / Auto Update GOOGLE SPREADSHEET

问题描述

我希望你能帮助我。我一直试图让这个工作相当长一段时间。

I hope you can help me. I have been trying to get this working for quite some time.

这是我在API从网站将其导入到谷歌小号preadsheets VIA importjson（）

I am taking the API from a website import it into google spreadsheets VIA importjson()

ImportJSON（ http://api.796.com/v3 /futures/ticker.html?type=weekly ）

ImportJSON("http://api.796.com/v3/futures/ticker.html?type=weekly")

https://gist.github.com/chrislkeller/5719258

我没有问题，导入JSON数据到谷歌小号preadsheet，现在困难的部分是使数据的更新，我真的想它来自动更新，但即使是立即更新按钮将是巨大的。

I have no problem importing the json data into google spreadsheet, now the hard part is making the data update, I would really like it to auto update but even a "update now" button would be great.

谢谢，
 这已被我发疯。
BV

Thanks, This has been driving me nuts. BV

推荐答案

您只需要添加的时候触发
https://developers.google.com/apps-script/understanding_triggers

You can just add the time trigger https://developers.google.com/apps-script/understanding_triggers

这篇关于刷新按钮/自动更新Google US preADSHEET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！