Skip to content

Instantly share code, notes, and snippets.

View NeutronStarsAreHeavy's full-sized avatar

Ryan NeutronStarsAreHeavy

  • Edinburgh, United Kingdom
View GitHub Profile
@NeutronStarsAreHeavy
NeutronStarsAreHeavy / RegularIntervalIMPORTXML.gs
Created March 22, 2019 02:08
Google Script to force update IMPORTXML cell function and populate into new row at regular time intervals.
// by u/NeutronStarsAreHeavy for Revoke Article 50 Petition Tracker.
// Function to check time, so that the save data function executes at specified times. Triggered every minute (set-up in GSuite Developer Hub)
function checkTime() {
var now = new Date();
var minute = now.getMinutes();
if (minute == 00 || minute == 15 || minute == 30 || minute == 45) {
// execute saveData
saveData();