jon turner jonturneratduke

## google-sheets-dataclip-autoupdate.md

      
              1 file
            
          
              1 fork
            
          
              9 comments
            
          
              11 stars
            
          
                aGHz
                / google-sheets-dataclip-autoupdate.md
            
            
              Last active
              October 6, 2021 18:24
            
              
                Auto-updating importData of Heroku Dataclips in Google Sheets
              
          
    Dataclips URLs

Dataclips has a reliable way to construct the URL of a clip's CSV version:
https://dataclips.heroku.com/<hash>-<description>.csv

Thankfully the description is irrelevant, so we can just get the hash from the web interface
(looks like aujqawhjdmlbbwrqxutcpzzqyika) and add -1 at the end. Every time we change the

  
## ignore
# Installed Node Modules #
##########################
node_modules/

# Compiled source #
###################
*.com
*.class
*.dll
*.exe
	# Installed Node Modules #
	##########################
	node_modules/

	# Compiled source #
	###################
	*.com
	*.class
	*.dll
	*.exe