Skip to content

Instantly share code, notes, and snippets.

View jimtalksdata's full-sized avatar
🤓

jimtalksdata

🤓
View GitHub Profile
@jimtalksdata
jimtalksdata / ImportJSON.gs
Created March 14, 2018 23:18
Google sheets - ImportJSON
/*====================================================================================================================================*
ImportJSON by Brad Jasper and Trevor Lohrbeer
====================================================================================================================================
Version: 1.4.0
Project Page: https://github.com/bradjasper/ImportJSON
Copyright: (c) 2017 by Brad Jasper
(c) 2012-2017 by Trevor Lohrbeer
License: GNU General Public License, version 3 (GPL-3.0)
http://www.opensource.org/licenses/gpl-3.0.html
------------------------------------------------------------------------------------------------------------------------------------
@jimtalksdata
jimtalksdata / RefreshImports.gs
Created March 14, 2018 23:17
Google sheets - RefreshImports
/**
* Go through all sheets in a spreadsheet, identify and remove all spreadsheet
* import functions, then replace them a while later. This causes a "refresh"
* of the "import" functions. For periodic refresh of these formulas, set this
* function up as a time-based trigger.
*
* Caution: Formula changes made to the spreadsheet by other scripts or users
* during the refresh period COULD BE OVERWRITTEN.
*
* From: https://stackoverflow.com/a/33875957/1677912
04a5b6d5f052d2ed2b22a9dc61a31b7359234258c9d0d2cdd1535a63d84dae7f55090d7325acbf4acf4190ab913c324c1c7082046e95b5ba6d698843cc28982186;romanornr