Using Google Apps Script and Google docs
While Google mail’s compliance footers are great for legal compliance, Google currently don’t offer an easy way to set signatures for all your users that are based on user specific variables. I had a quick look at the existing offerings but I also noticed that due to the openness of Google’s APIs it's easy to pull data from a Google spreadsheet and push out the signatures to users across a domain. Giving us:- Centrally managed user data in a simple spreadsheet
- A legal compliance footer enforced on all outbound emails
- A quickly customisable signature with contact details that can be edited/updated by users (no more waiting for IT to update your contact details)
As Google Apps Script doesn't connect to the Google email settings API directly, this also makes use of Google Apps Script's support of oauth to securely authenticate from Google Apps Script to the Google email settings API. This post includes setup instructions and an overview of how it works, if you just want the code feel free to skip to the end...
