markelliot’s gists

markelliot / cal-sync.gs

Last active March 2, 2022 19:43

	/* This script will synchronize two Google-hosted calendars as a Google Apps Script.
	*
	* Personal events will show on your work calendar by default with the label "Blocked (Personal)".
	* Work events will show on your personal calendar by default with the label "Blocked (Work)".
	*
	* The description of the "Blocked" events contains an identifier that allows the script to update
	* event times if they change.
	*
	* Note that this script will not copy or update events where:
	* - you have not accepted the invite

markelliot / appendRowsToSheet.js

Created June 8, 2021 02:15

Appends rows to a Google Sheet using the specified OAuth2 token and spreadsheet id.

	/**
	* Appends the row matrix to the specified range in the identified sheet.
	*
	* @param {string} token an OAuth2 token scoped for write to the Google sheets APIs
	* (scope must include "https://www.googleapis.com/auth/spreadsheets") and with access
	* to the underlying Google Sheet. The Sheet should be shared with the service user's
	* email address.
	* @param {string} spreadsheetId the spreadsheet's identifier, which you can glean
	* from the Google Sheets URL, extracted from the pattern:
	* https://docs.google.com/spreadsheets/d/([A-Za-z0-9_-]+)/edit#gid=0

markelliot / getGoogleAuthToken.js

Last active July 22, 2025 01:17

Converts Google service user OAuth2 credentials into an access token in Cloudflare-compatible JS

	/**
	* Get a Google auth token given service user credentials. This function
	* is a very slightly modified version of the one found at
	* https://community.cloudflare.com/t/example-google-oauth-2-0-for-service-accounts-using-cf-worker/258220
	*
	* @param {string} user the service user identity, typically of the
	* form [user]@[project].iam.gserviceaccount.com
	* @param {string} key the private key corresponding to user
	* @param {string} scope the scopes to request for this token, a
	* listing of available scopes is provided at

markelliot / keybase.md

Created August 15, 2019 15:51

I hereby claim:

I am markelliot on github.
I am markelliot (https://keybase.io/markelliot) on keybase.
I have a public key whose fingerprint is 5FD1 F002 5836 8F86 3DF0 1BD2 EE57 1B77 7CE7 3A72

To claim this, I am signing this object:

markelliot / map_257.js

Last active August 29, 2015 14:20

markelliot / map_256.js

Created May 4, 2015 03:42

Mark Elliot markelliot