Skip to content

Instantly share code, notes, and snippets.

View davemoz's full-sized avatar

Dave Mozdzanowski davemoz

View GitHub Profile
@davemoz
davemoz / Gmail data into Sheet with Google Apps Script
Last active April 4, 2024 09:00
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
@davemoz
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