Skip to content

Instantly share code, notes, and snippets.

View danahmadi's full-sized avatar

Dan Ahmadi danahmadi

View GitHub Profile
@danahmadi
danahmadi / delete unnamed google sheets filter views
Created November 13, 2020 17:23
Delete Unnamed Filter Views in Google Sheets
//Drop into script editor and save (update your sheet name in range below)
// Make sure to go to Resources/Advanced Google Services/ and enable Google Sheets API access
// Then click run in the script editor
// Say goodbye to those pesky "Filter 834" views
function delete_unnamed_filters() {
var substr = "Filter";
var arr_filterViewId = [];
@danahmadi
danahmadi / gist:2d06c5790b84dc597c2f255aba1ed83e
Created August 10, 2018 00:54
Outreach Bizible Filters for Sales Activity
Outreach Calls:
CrmTask.Subject contains [Outreach] [Call] [outbound] [CC
Outreach Emails:
CrmTask.Subject does not contain *Out of Office*, *Automatic*, *Accepted*, *auto*, *declined*, *update*, *accept*, *ooo*, *oof*, *delayed*, *out of office*, *new time proposed*, *pto*, *no longer*, *out of the office*, *slow to respond*, *delay*, *tentative*, *invitation*, *webinar*, *digest*, *blog*, *waiting*, *unsubscribe*, *time off*, *traveling*, *stop*, *slow* and CrmTask.Subject contains [Outreach] [Email] [In]
@danahmadi
danahmadi / gist:483cb8b4d24a2ea06acb73c68adeb145
Created April 4, 2018 20:05
URL Parameter-based HTML Content Replacement with Clearbit
<script>
//extract all url parameters
function getURLParameter(name) {
return decodeURIComponent((new RegExp('[?|&]' + name + '=' + '([^&;]+?)(&|#|;|$)').exec(location.search) || [null, ''])[1].replace(/\+/g, '%20')) || null;
}
//pull out interesting parameters
company = getURLParameter('company');
company_name = getURLParameter('company_name');
//conditionally replace HTML content and inject values from those parameters