Skip to content

Instantly share code, notes, and snippets.

@willinspire
willinspire / gsrapi.sh
Created September 16, 2018 14:05
Google Search Recommendations API -- (Bash Shell 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...
@willinspire
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)
@willinspire
willinspire / NationalGoogleTrends.sh
Last active February 27, 2023 14:40
Curl the XML data from all nationally-sorted Google search trends feeds.
################################
# NATIONAL GOOGLE TRENDS #
################################
#
# Updated: 20171123
# Created by h8rt3rmin8r
# Email: 161803398@email.tg
# PGP: h8rt3rmin8r.com
###############################################################################################################
# Curl the XML data from all nationally-sorted Google search trends feeds.
@willinspire
willinspire / codeMake.sh
Created October 17, 2019 19:42
HarTools (har2csv) deploy script (unofficial). HarTools repository: github.com/spcgh0st/HarTools
#!/usr/bin/env bash
#-----------------------------------------------------------------------------#
# [ codeMake ]
#
# Assemble the har2csv source code
#
# Build script by: h8rt3rmin8r (161803398@email.tg)
# Last updated on: 20191017
# Build script source: https://pastebin.com/raw/n85QsAw2
# HarTools source code: https://github.com/spcgh0st/HarTools
@willinspire
willinspire / macspoof.sh
Created October 24, 2018 17:20
Automatically generate and assign a new MAC address for the local system.
#! /bin/bash
################################################################################
# __
# / _|
# _ __ ___ __ _ ___ ___ _ __ ___ ___ | |_
# | '_ ` _ \ / _` |/ __/ __| '_ \ / _ \ / _ \| _|
# | | | | | | (_| | (__\__ \ |_) | (_) | (_) | |
# |_| |_| |_|\__,_|\___|___/ .__/ \___/ \___/|_|
# | |
# |_|
@willinspire
willinspire / assetnews.sh
Last active September 25, 2018 06:28
Fetch asset-linked news stories categorized by the Wall Street Journal
#! /bin/bash
#### ABOUT ####----------------------------------------------------------------#
#
# Script: assetnews.sh
# Source: http://bit.ly/assetnews
#
# Fetch asset-linked news stories categorized by the Wall Street Journal
#
# This script can be customized to fetch news stories related to any mainstream
@willinspire
willinspire / crypto-arbitrage.sh
Created September 24, 2018 06:51
Mirror the table of cryptocurrency arbitrage data provided by Cryptopia exchange (automate running this script via cron to keep it updated)
#! /bin/bash
# Cryptocurrency Arbitrage Page Builder
# Data provided by Cryptopia.co.nz
# Assembled by h8rt3rmin8r on 20180924
#
# NOTE: This bash script requires prior installation of Apache or some other web host
# software and it requires write-access to /var/www/html/index.html
# Set up the output location in a public-facing HTML page
@willinspire
willinspire / encryptStrings.sh
Created November 30, 2017 14:45
Encrypt a string within a shell script
################
# #
# #
# ENCRYPTING #
# SHELL #
# STRINGS #
# #
# #
################################################################################
#------------------------------------------------------------------------------#
JQ(1) JQ(1)
NAME
jq - Command-line JSON processor
SYNOPSIS
jq [options...] filter [files...]
jq can transform JSON in various ways, by selecting, iterating, reducing and otherwise mangling JSON documents. For instance, running the command jq ´map(.price) | add´ will take an array of JSON objects as input and return the sum of their "price" fields.
@willinspire
willinspire / SheetTimeStamper.gs
Last active September 25, 2017 19:44
A Google Apps Script for generating automated time stamping in Google Sheets
/*/////////////////////////////////////////////////////////////////////////
SHEET TIME STAMPER - (FOR USE IN GOOGLE SHEETS)
The initial configuration generates a unique time stamp on the line of
of the specified sheet ("Sheet1") whenever the corresponding cell in
column 4 is NOT empty. Included is an additional configuration which will
perform this same action on multiple columns simultaneously.
###############################