William Thompson willinspire

## Google Script Cache-Busting IMPORTHTML.md

      
              1 file
            
          
              2 forks
            
          
              3 comments
            
          
              9 stars
            
          
                willinspire
                / Google Script Cache-Busting IMPORTHTML.md
            
            
              Last active
              June 15, 2023 16:16
                — forked from ranaroussi/Google docs cache-busting importdata.md
            
              
                It is not easy to refresh the IMPORTHTML functions in Google Sheets due to cashe limitations. The resulting limitations are old data instead of new data being pulled into the Sheet upon running a Script to reload the IMPORTHTML function. This Google Script is a "Cache-Busting" function which circumvents this problem.
              
          
    // Set your variables below
SHEET_NAME="MC-Import-Data"
URL="https://coinmarketcap.com/currencies/views/all/"

// Create a trigger to refresh every 5 minutes
function myFunctionA() {
  ScriptApp.newTrigger("getData")
  .timeBased()
 .everyMinutes(5)

  
## gsrapi.sh
#! /bin/bash
################################################################################
#
#    gsrapi.sh
#    Google Search Recommendations API -- Bash Library
#    This script was created by h8rt3rmin8r on 20180916
#    Built for use by ResoNova International Consulting, LLC (ResoNova.com)
#
#    BASIC USAGE:
#    Make this script executable and pass a query to the script...
	#! /bin/bash
	################################################################################
	#
	# gsrapi.sh
	# Google Search Recommendations API -- Bash Library
	# This script was created by h8rt3rmin8r on 20180916
	# Built for use by ResoNova International Consulting, LLC (ResoNova.com)
	#
	# BASIC USAGE:
	# Make this script executable and pass a query to the script...