Skip to content

Instantly share code, notes, and snippets.

@aroyrev
aroyrev / httpGetTemplate.gs
Created May 25, 2020 03:30 — forked from mogsdad/httpGetTemplate.gs
Google Apps Script template functions for external host communication with UrlFetchApp. See https://mogsdad.wordpress.com.
/** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* httpGetTemplate.gs
*
* A pair of template functions for external host communication with
* UrlFetchApp, including parameter encoding and error handling.
*
* From: gist.github.com/mogsdad/a76c32231a2b91ff8b59
*
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
@aroyrev
aroyrev / sed cheatsheet
Created February 28, 2020 00:02 — forked from ssstonebraker/sed cheatsheet
Sed Cheatsheet
FILE SPACING:
# double space a file
sed G
# double space a file which already has blank lines in it. Output file
# should contain no more than one blank line between lines of text.
sed '/^$/d;G'
hashtag_list = ['travelblog', 'travelblogger', 'traveler']
# prev_user_list = [] - if it's the first time you run it, use this line and comment the two below
prev_user_list = pd.read_csv('20181203-224633_users_followed_list.csv', delimiter=',').iloc[:,1:2] # useful to build a user log
prev_user_list = list(prev_user_list['0'])
new_followed = []
tag = -1
followed = 0
likes = 0
@aroyrev
aroyrev / script_stages_slack.py
Created December 23, 2019 03:40 — forked from clubapplets-server/script_stages_slack.py
Script to automatically send the content of a gsheet to your slack via webhook
# -*- coding: utf8 -*-
# !/usr/bin/env python3
"""
ApplETS Script Stages Slack automatically sends a reminder on Slack about
internships available for ApplETS scientific club. Crontab it if you
want to make it every a definite period of time.
Copyright 2015 ApplETS applets@ens.etsmtl.ca
@aroyrev
aroyrev / cheatsheet.ps1
Created July 4, 2019 06:22 — forked from pcgeek86/cheatsheet.ps1
PowerShell Cheat Sheet / Quick Reference
Get-Command # Retrieves a list of all the commands available to PowerShell
# (native binaries in $env:PATH + cmdlets / functions from PowerShell modules)
Get-Command -Module Microsoft* # Retrieves a list of all the PowerShell commands exported from modules named Microsoft*
Get-Command -Name *item # Retrieves a list of all commands (native binaries + PowerShell commands) ending in "item"
Get-Help # Get all help topics
Get-Help -Name about_Variables # Get help for a specific about_* topic (aka. man page)
Get-Help -Name Get-Command # Get help for a specific PowerShell function
Get-Help -Name Get-Command -Parameter Module # Get help for a specific parameter on a specific command
@aroyrev
aroyrev / google-apps-script.md
Created July 2, 2019 02:18 — forked from labnol/google-apps-script.md
How to Learn Google Apps Script - The best resources for learning Google Apps Script, the glue that connects GSuite services including Gmail, Google Drive, Calendar, Maps, Analytics and more.

Learning Google Apps Script

The best place to learn more about Google Script is the official documentation available at developers.google.com. Here are other places that will help you get up to speed.

  1. Google Apps Scripts - Snippets by +Amit Agarwal
  2. Apps Script Starter - Create Google Apps Script projects locally inside VS Code.
  3. Digital Inspiration by +Amit Agarwal - Google Addons
  4. Awesome Google Scripts by +Amit Agarwal
  5. Build with Google Apps Script - Setup a local development environment for Apps Script
  6. Apps Script Webinars - YouTube - by +Eric Koleda
@aroyrev
aroyrev / NerdBot
Created July 2, 2019 01:49 — forked from venetucci/NerdBot
🤓 A Google Apps Script to use with Slack webhooks - allows you to post to a spreadsheet from Slack, and receive a confirmation message in Slack. Full tutorial with Slack integrations: https://medium.com/p/a-bot-to-help-you-read-your-way-through-next-4-years-7ba9d80066fc
function testNewItemPost() {
var request = {
parameters: {
token: "[]",
user_name: "michelle",
text: "add: Rural America; Hillbilly Elegy; J.D. Vance; From a former marine and Yale Law School graduate, a powerful account of growing up in a poor Rust Belt town that offers a broader, probing look at the struggles of America’s white working class; https://www.amazon.com/gp/product/0062300547/ref=pd_bxgy_14_2?ie=UTF8&pd_rd_i=0062300547&pd_rd_r=MG2AV2PZZVEXNYZ1Y84V&pd_rd_w=xCKNl&pd_rd_wg=55Iya&psc=1&refRID=MG2AV2PZZVEXNYZ1Y84V;"
}
};
doPost(request);
}
@aroyrev
aroyrev / python-post-json.py
Created June 10, 2019 22:24 — forked from thepacketgeek/python-post-json.py
POST JSON from Python with Requests
import requests
url = "http://localhost:8080"
data = {'sender': 'Alice', 'receiver': 'Bob', 'message': 'We did it!'}
headers = {'Content-type': 'application/json', 'Accept': 'text/plain'}
r = requests.post(url, data=json.dumps(data), headers=headers)

Server side printing with Google Cloud Print API from a PHP application

It took me quite some time to figure out how to print properly from a web application. I will explain here how I did it, so you don't have to spend the same time.

Authorization

Google Cloud Print API uses OAuth 2.0 for authorization.

As explained [here][1] on the Google Developer page, the best way to use OAuth with the Google API is with a Google service account. Create a service account as explained on the Google Developer page.

To use OAuth a library is required. Google has published the [Google API PHP client library][2]. If you want to use the examples from the Developer pages, you need to use version 1 of the library. In this article I use version 2 of the library.

@aroyrev
aroyrev / slackpost.sh
Created April 26, 2019 00:19 — forked from mattak/slackpost.sh
post message to slack
#!bash -e
TOKEN= # slack token is generate from: https://api.slack.com/web
CHANNEL= # name of channels or group
MESSAGE= # message
NICK= # bot name
IS_PRIVATE= # 1 or 0
if [ $IS_PRIVATE -eq 1 ]; then
API_TYPE=groups