dnalob

Tabletop.js is a fantastic, open-source JavaScript library that lets developers easily integrate data from Google Spreadsheets into their online projects. I've used it, even contributed a minor feature, and love it for prototyping. Non-programmers love being able to update a project via Google Spreadsheets' hyper-intuitive interface.

That said, I'm extraordinarily wary of using Tabletop in production. Instead, at the Wall Street Journal, we use a bit of middleware to "prune" our Google Spreadsheets-based data and then cache it on our own servers. A few brief reasons:

Short-Term Reliability. With Tabletop, your project depends on Google not to rate-limit access to your spreadsheet. Google rate-limits access to their Spreadsheet API, though the thresholds aren't clear. If you're building an app you care about, you don't want to be i

Unfollow everyone on twitter.com

Go to https://twitter.com/YOUR_USER_NAME/following
Open the Developer Console. (COMMAND+ALT+I on Mac)
Paste this into the Developer Console and run it

// Unfollow everyone on twitter.com, by Jamie Mason (https://twitter.com/fold_left)
// https://gist.github.com/JamieMason/7580315
//

	// This script reviews your GDN placements for the following conditions:
	// 1) Placements that are converting at less than $40
	// 2) Placements that have cost more than $50 but haven't converted
	// 3) Placements that have more than 5K impressions and less than .10 CTR

	function main() {

	var body = "<h2>Google Display Network Alert</h2>";
	body += "<h3>Placements that are converting at less than $40:</h3> " ;
	body += "<ul>";

	/***************************************************************************************
	* AdWords Account Audit -- Check Ads for disapprovals -- text if there are open issues
	* Version 1.0
	* Created By: Derek Martin
	* DerekMartinLA.com
	****************************************************************************************/

	// This script was heavily inspired by Russell Savage so all credit where its due!
	// Sign up at Twilio.com and get an API key (sid) and Auth code and place here
	// Url: https://www.twilio.com/

	/***********************************************************************************************
	* AdWords Account Optimization - Review Google Display Network Site Placement Quality.
	* Analyze Display Network Placements that have accrued more than $20 of cost MTD against
	* Standard SEO metrics (PageAuthority, DomainAuthority, # of Backlinks, Age of Site) and report back
	* Any questionable placements that are strong targets for exclusion.
	* Created By: Derek Martin
	* DerekMartinLA.com
	****************************************************************************************/
	// CONSTANTS

	<!DOCTYPE html>
	<html>
	<head>
	<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8">

	<script>
	(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]\|\|function(){
	(i[r].q=i[r].q\|\|[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
	m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
	})(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

	/**
	* Removes placements ending in the tlds xyz, tk, and download.
	* @author Dawson R
	* @author Andrew B
	*/

	// Top Level Domains to exclude

	var TLDs = '.xyz, .tk, .download';

	/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
	* Quality Score Tracker v3.0
	* Written by Martin Roettgerding.
	* © 2016 Martin Roettgerding, Bloofusion Germany GmbH.
	* www.ppc-epiphany.com/qstracker/latest
	*/
	function main(){
	/*
	* The following preferences can be changed to customize this script.
	* Most of options can be set by using 1 for yes or 0 for no.

	// Port of Slides API demo by Wesley Chun to Google Apps Script
	// Source: http://wescpy.blogspot.co.uk/2016/11/using-google-slides-api-with-python.html

	function slides_template() {
	/*
	from apiclient import discovery
	from httplib2 import Http
	from oauth2client import file, client, tools
	*/

	// Limit Monthly Cost By Postal Codes in a Campaign
	//
	// Copyright 2017 - Optmyzr Inc - All Rights Reserved
	// Visit www.optmyzr.com for more AdWords Scripts and PPC Management Tools and Reports
	//
	//
	// Purpose of the script:
	// ---------------------
	// To allow you to set a broad location target to capture more traffic in a regionwhile at the same time
	// letting you limit the monthly cost for locations within the target region.