SourcingDenis

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';

SourcingDenis

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');
  }

SourcingDenis

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');
  }

SourcingDenis

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'

SourcingDenis

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) {

SourcingDenis

/*
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 

SourcingDenis

Keybase proof

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:

SourcingDenis

SHORTCUTS

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

SourcingDenis

Most active GitHub users (git.io/top)

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)

SourcingDenis

<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 {