Dave Mozdzanowski davemoz

These repos are mostly personal projects, at varying stages of completeness. Enjoy!

davemoz / aws-linux-2-wordpress.sh

Created October 12, 2021 17:12 — forked from byronfriesen/aws-linux-2-wordpress.sh

Amazon Linux 2 LTS - Wordpress / PHP-FPM / NGINX / MariaDB / WP-CLI Auto Install

	#!/bin/bash

	##############################################################
	# Set Your System and Wordpress Config Preferences
	##############################################################

	export SYSTEM_USER=username # User PHP-FPM runs under

	# Database
	export WP_DB_NAME=wordpress

davemoz / Gmail data into Sheet with Google Apps Script

Last active October 5, 2024 16:35

Google Apps Script to pull data from transaction emails in Gmail, and insert into Spreadsheet

	/*
	* This Google Apps Script works by simply scraping info from transaction emails
	* sent to your Gmail account.
	* My credit cards are Capital One, Chase, and Bank of America so the email-scraping
	* regexes will need to change to work with the format of your emails.
	*
	* Once installed, you'll need to set a monthly trigger to run the createMonthlySheet()
	* function, but then it will run automatically and sort your transactions into monthly sheets.
	*
	* Any reference to the getActiveSpreadsheet() method will create a new sheet