labnol

// 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();
});

labnol

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all GSuite services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, Analytics and more.

A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.

1. Google Apps Script Code Samples by Amit Agarwal
2. Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
3. Awesome Google Scripts by Amit Agarwal
4. Google Developer Experts - Follow Apps Scr

labnol

// You create your bookmarklet by instantiating
// a new Bookmarklet function, then pass in the options like so.
// This example checks to see if the var is already defined, and makes
// sure not to overwrite it. This could happen if the user clicks on
// the bookmarklet more than once.

var MyBookmarklet = MyBookmarklet || new Bookmarklet({
  // debug: true, // use debug to bust the cache on your resources
  css: ['/my/style.css'],
  js: [],

labnol

// Do whatever you'd like with the script! Show it off, mod it up, post it places, or whatever. :)
// (If you do, I wouldn't mind a Twitter shoutout at @_slinehan when appropriate!)

$imageURL = "URL HERE";
$image = imagecreatefromjpeg($imageURL);

$width = imagesx($image);
$height = imagesy($image);

// First, let's resize the image to something manageable while maintaining aspect ratio.

labnol

// INSTRUCTIONS:
// 1. Start a new form in Google docs
// 2. Go to Tools > Script editor from the spreadhseet
// 3. Paste in the below code
// 4. Go to Triggers > Current script's triggers
// 5. Add a new trigger
// 6. Select "onFormSubmit" then "On Form Submit" from the third select box. Click save.
// 7. Save the script and go back to your spreadsheet. You should see a "WHD Options" menu.
// 8. Click WHD Options > Ticket settings and enter the API key (from WHD's user setting screen) and the URL to your "Create Ticket" post. The script will automatically append "?apiKey=xxx" to the end of this URL.
// 9. Use the email settings in the WHD Options if you want to email users with their WHD ticket. 

labnol

/**
 * POST data from a Google Spreadsheet to a remote URL, via menu option Add-ons > Post values
 * See: http://www.google.com/google-d-s/scripts/guide.html for more info
 */

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var r = sheet.getRange("B5");

function onOpen() {

labnol

var DateTime = function() {
  var now = new Date();
  this.year = now.getFullYear();
  this.month = ('00' + now.getMonth()).slice(-2);
  var monthEndDate = new Date(this.year, this.month, 0);
  this.startDate = this.year + '-' + this.month + '-01';
  this.endDate = this.year + '-' + this.month + '-' + monthEndDate.getDate();
}

var Profile = function(profileName, tableId) {

labnol

/*   
   All code apart from getPlusones()
   Copyright 2011 Martin Hawksey 

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

labnol

// Part of this code up to END OF (c) is:
/*   
   Copyright 2011 Martin Hawksey

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

labnol

// The rest of this code is currently (c) Google Inc.

// setRowsData fills in one row of data per object defined in the objects Array.
// For every Column, it checks if data objects define a value for it.
// Arguments:
//   - sheet: the Sheet Object where the data will be written
//   - objects: an Array of Objects, each of which contains data for a row
//   - optHeadersRange: a Range of cells where the column headers are defined. This
//     defaults to the entire first row in sheet.
//   - optFirstDataRowIndex: index of the first row where data should be written. This