| function exportSpreadsheet() { | |
| //All requests must include id in the path and a format parameter | |
| //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export | |
| //FORMATS WITH NO ADDITIONAL OPTIONS | |
| //format=xlsx //excel | |
| //format=ods //Open Document Spreadsheet | |
| //format=zip //html zipped | |
| /** | |
| * This Google Sheets script keeps data in the specified column sorted any time | |
| * the data changes. | |
| * | |
| * After much research, there wasn't an easy way to automatically keep a column | |
| * sorted in Google Sheets, and creating a second sheet to act as a "view" to | |
| * my primary one in order to achieve that was not an option. Instead, I | |
| * created a script that watches for when a cell is edited and triggers | |
| * an auto sort. | |
| * |
| /** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * | |
| * 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 | |
| * | |
| * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */ | |
| #!/usr/bin/env bash | |
| # Ubuntu Server or VM Cleaner. Safe by default; aggressive when asked. | |
| # Example safe: sudo ./clean.sh | |
| # Example aggressive: sudo JOURNAL_DAYS=3 AGGRESSIVE=1 ./clean.sh | |
| # Enable Docker image prune (images only): sudo ./clean.sh --docker-images | |
| # Tested on Ubuntu 20.04, 22.04, 24.04 (server/VM images). | |
| set -Eeuo pipefail | |
| trap 'rc=$?; echo "Error on line $LINENO: $BASH_COMMAND (exit $rc)"; exit $rc' ERR | |
| IFS=$'\n\t' |
