Skip to content

Instantly share code, notes, and snippets.

View richardcmckinney's full-sized avatar
:electron:

Richard McKinney richardcmckinney

:electron:
5 followers · 27 following
View GitHub Profile
@richardcmckinney
richardcmckinney / submit.md
Created February 25, 2024 22:19 — forked from tanaikech/submit.md
Workaround for Retrieving Direct Links of All Sheets from URL of 2PACX-### of Web Published Google Spreadsheet

Workaround for Retrieving Direct Links of All Sheets from URL of 2PACX-### of Web Published Google Spreadsheet

This is a sample script for retrieving the direct links of all sheets from the URL like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml of the web published Google Spreadsheet. This sample script can be used for the following situation.

  1. The Spreadsheet is published to Web and the URL like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml is known
  2. You are not the owner of Google Spreadsheet.
  3. You don't know the Spreadsheet ID and Sheet IDs.

Under above situation, unfortunately, the direct links of each sheet cannot be directly retrieved. I think that this is the specification of Google side. So in this post, I would like to introduce a workaround for retrieving the direct links of each sheet under above situation.

@richardcmckinney
richardcmckinney / keybase.md
Created May 3, 2018 18:18
keybase.md

Keybase proof

I hereby claim:

  • I am richardcmckinney on github.
  • I am richardmckinney (https://keybase.io/richardmckinney) on keybase.
  • I have a public key ASDCG6m4sYgXG9W35Vs13sdQo_Eh9BjYgTOhq_vk-gtZzQo

To claim this, I am signing this object:

@richardcmckinney
richardcmckinney / unfavorite.js
Created March 15, 2018 09:15 — forked from ashander/unfavorite.js
Delete all your favorites (unfavorite or unlike every tweet) on twitter.com (thx to @JamieMason and @b44rd for inspiring this)
// 1. Go to https://twitter.com/i/likes
// 2. Keep scrolling to the bottom repeatedly until all your favs are loaded.
// 3. Run this in your console (open in chrome by View > Developer > JavaScript Console)
// Notes: this may take a while if you have a lot of favs/likes
// you can only access your most recent ~2000 likes.
// inspired by https://gist.github.com/JamieMason/7580315
$('.ProfileTweet-actionButtonUndo').click()
@richardcmckinney
richardcmckinney / unfollow.js
Created March 15, 2018 09:10 — forked from JamieMason/unfollow.js.md
Unfollow everyone on twitter.com
// Unfollow everyone on twitter.com, by Jamie Mason (https://twitter.com/fold_left)
// 1. Go to https://twitter.com/following.
// 2. Keep scrolling to the bottom repeatedly until all your followers are loaded.
// 3. Run this in your console.
[].slice.call(document.querySelectorAll('.unfollow-text')).forEach(function(button) {
button.click();
});
// If your browser is freezing because you follow *loads* of people, then try the version
@richardcmckinney
richardcmckinney / twitter crawler.txt
Created March 9, 2018 09:16 — forked from vickyqian/twitter crawler.txt
A Python script to download all the tweets of a hashtag into a csv
import tweepy
import csv
import pandas as pd
####input your credentials here
consumer_key = ''
consumer_secret = ''
access_token = ''
access_token_secret = ''
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
@richardcmckinney
richardcmckinney / all_aws_managed_policies.json
Created March 8, 2018 22:28 — forked from gene1wood/all_aws_managed_policies.json
A list of all AWS managed policies and they're policy documents as well as a short script to generate the list
{
"AWSAccountActivityAccess": {
"Arn": "arn:aws:iam::aws:policy/AWSAccountActivityAccess",
"AttachmentCount": 0,
"CreateDate": "2015-02-06T18:41:18+00:00",
"DefaultVersionId": "v1",
"Document": {
"Statement": [
{
"Action": [