This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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 = []; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 |