I hereby claim:
- I am sourcingdenis on github.
- I am sourcingdenis (https://keybase.io/sourcingdenis) on keybase.
- I have a public key ASBmtMD5Z2bWisLmjflGRL3cTHC0FzlME20r5n5RCyx81wo
To claim this, I am signing this object:
var API_KEY = 'YOUR_API_KEY'; | |
function runGPT() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var range = sheet.getRange('A1:B1').getValues(); | |
var cell1 = range[0][0]; | |
var cell2 = range[0][1]; | |
var prompt = cell1 + ' space ' + cell2; | |
var API_URL = 'https://api.openai.com/v1/completions'; |
function getGitHubRepoUrl() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var range = sheet.getActiveRange(); | |
var username = range.getValue(); | |
var adjacentCell = range.offset(0, 1); // adjust this if the URL is in a different column | |
var repoUrl = ""; | |
if (username.indexOf("github.com") >= 0) { | |
username = username.replace(/^.*com[/]([^/]*).*$/,'$1'); | |
} |
function getGitHubEmail() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var range = sheet.getActiveRange(); | |
var username = range.getValue(); | |
var adjacentCell = range.offset(0, 1); // adjust this if the email is in a different column | |
var email = ""; | |
if (username.indexOf("github.com") >= 0) { | |
username = username.replace(/^.*com[/]([^/]*).*$/,'$1'); | |
} |
function searchGitHubProfile() { | |
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheet = spreadsheet.getActiveSheet(); | |
var selectedRange = sheet.getActiveRange(); | |
var searchQueryValues = selectedRange.getValues(); | |
var accessToken = 'INSERT_YOUR_GITHUB_API_KEY'; | |
var headers = { | |
'Authorization': 'Bearer ' + accessToken, | |
'User-Agent': 'GoogleAppsScript' |
var reg = (o, n) => o ? o[n] : ''; | |
var cn = (o, s) => o ? o.getElementsByClassName(s) : console.log(o); | |
var tn = (o, s) => o ? o.getElementsByTagName(s) : console.log(o); | |
var gi = (o, s) => o ? o.getElementById(s) : console.log(o); | |
var delay = (ms) => new Promise(res => setTimeout(res, ms)); | |
var rando = (n) => Math.round(Math.random() * n); | |
var fixCase = (fn) => fn.replace(/\w\S*/g, txt => txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase()); | |
var parseMember = (obj, meetup) => [fixCase(obj.name).replace(/,/g, ''), `https://www.meetup.com/${meetup}/members/${obj.id}/`, obj.joined, obj.last_visited, obj.photo ? obj.photo.highres_link : '']; | |
function downloadr(arr2D, filename) { |
/* | |
INSTRUCTIONS | |
1. Open this file in notepad or something similar | |
2. Paste your list of names where it says replace names | |
3. Go to linkedin and line up a people search for your city | |
4. In google chrome. In Windows and Linux hit: Ctrl + Shift + J. On Mac hit: Cmd + Option + J. | |
5. Copy paste this whole script in to the console and hit enter | |
6. leave the window active while it collects results | |
7. You should get a tab seperated CSV that you can open in Excel |
I hereby claim:
To claim this, I am signing this object:
Key/Command | Description |
---|---|
Tab | Auto-complete files and folder names |
Ctrl + A | Go to the beginning of the line you are currently typing on |
Ctrl + E | Go to the end of the line you are currently typing on |
Ctrl + U | Clear the line before the cursor |
Ctrl + K | Clear the line after the cursor |
Ctrl + W | Delete the word before the cursor |
Ctrl + T | Swap the last two characters before the cursor |
The count of contributions (summary of Pull Requests, opened issues and commits) to public repos at GitHub.com from Tue, 06 Dec 2016 17:06:46 GMT till Wed, 06 Dec 2017 17:06:46 GMT.
Only first 1000 GitHub users according to the count of followers are taken. This is because of limitations of GitHub search. Sorting algo in pseudocode:
githubUsers
.filter(user => user.followers > 1000)
<style id="jsbin-css"> | |
@import url('https://fonts.googleapis.com/css?family=Anton|Roboto'); | |
.word { | |
font-family: 'Anton', sans-serif; | |
perspective: 1000px; | |
perspective-origin: 200px 40px; | |
} | |
.word span { |