Skip to content

Instantly share code, notes, and snippets.

View dsottimano's full-sized avatar

Dave dsottimano

57 followers · 9 following
View GitHub Profile
@dsottimano
dsottimano / url parsing thingy
Created July 26, 2020 01:47
console.log([...new Set(new URL('https://www.amazon.com/SanDisk-128GB-microSDXC-Memory-Adapter/dp/B073JYC4XM/memory').pathname.toLowerCase().split(/-|\//gi).filter(Boolean))])
//output handles dupes for casing and removes falsy values
//[ 'sandisk','128gb','microsdxc','memory','adapter','dp','b073jyc4xm' ]
@dsottimano
dsottimano / john
Created July 15, 2020 20:01
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
</head>
<body>
<div class="container">
<p style="color:red;">Sorry about the email change at the last minute, Google and Gmail decided to block this message as spam, so I can't send it to you. Yeah, I'm changing providers ;)</p>
<p>Thanks for watching my MozCon presentation! Even though it was only 30 minutes, it took me years for me to get to this point.
I’m really excited to share concepts that should help you cut out boring tasks and focus on more important things.</p>
@dsottimano
dsottimano / gist:2c8428b0bac422b3bcf08744c73b2be0
Created October 28, 2019 19:47
SERPapi for Google sheets/apps script
//note: users of this script need a valid api key from serpapi.com
//the key must be included in the object below as the serpApiKey value. For non-programmers, please ensure that your API is within quotes ("")
var GLOBAL_VARIABLES = {
serpApiKey: ""
}
/**
* Returns serpapi data for organic results
@dsottimano
dsottimano / for Hamlet - index.html
Last active February 4, 2020 12:26
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<script src="index.js"></script>
</head>
<body>
@dsottimano
dsottimano / gist:29fbfaa6795ca3a7204fa82113dfc863
Last active January 9, 2020 21:19
SMXL MILAN 2019 PRESENTATION CODE BUNDLE
//this is where you put in your api keys!
//serpApiKey from serpapi.com
//proxyCrawlToken & proxyCrawlJavascriptToken from proxycrawl.com
var GLOBAL_VARIABLES = {
serpApiKey : "",
proxyCrawlToken: "",
proxyCrawlJavascriptToken: ""
@dsottimano
dsottimano / gist:cd0d9479647e96d6b1d338222011ecee
Last active October 30, 2019 09:48
Substitute all custom function for apps script - sheets
/**
* Substitute multiple words or characters at once
* @param {"@,hello,test"} params REQUIRED The words you want to remove separated by commas ","
* @param {"a1"} text REQUIRED The string you want to subsitute from
* @param {"-"} replacement OPTIONAL The replacement string. Default is blank space
* @return Returns combination of protocols + www subdomains
* @customfunction
*/
function SUBSTITUTE_ALL(params, text,replacement) {
@dsottimano
dsottimano / gist:2af808b30de1bec51506e0855141dceb
Last active October 29, 2019 16:01
Keyword frequency table generator - apps script - google sheets
/**
* Returns a table of ngrams and their importance
*
* @param {"cars are the best"} textArray REQUIRED The corpus you want statistics from
* @param {"3"} numberOccurances OPTIONAL Show results with at least X occurrences. Default is 2
* @param {"4"} numberOfWords OPTIONAL Show statistics for one to X words. Default is 5
* @param {"false"} removeStopWords OPTIONAL true or false. False by default
* @customfunction
*/