Record software licences in Numbers

I am partway through my exodus from 1Password, brought on by their change to a cloud-based subscription service. 

One of the features of 1Password I used was the recording of Software Licence details.

I decided to create a process whereby I can record the details of software licenses in Numbers, automating as much as possible the extraction of details from the emails I receive on making software purchases.

Generally, software licenses are granted using the name of the purchaser and an email address. This workflow will extract the Date (typically this will be the purchase date), Recipient Name (or default name if not found), Recipient Email address, and a link to the email message and then create a new record in the Numbers document.

The email message will be tagged via MailTags (Purchases in my case) and then moved to a folder for archiving. The Mail window will switch to the folder used to archive the messages.

Mail and Numbers will then be displayed in a split-screen via a Shortcut so the additional data (eg Software name, Licence, etc)  can be entered into Numbers. 

This process is actually easier than using 1Password due to the automation and can be easily be adapted for other email archiving requirements.

The code is below if you would like to try out this process. Click on the following links to get the Numbers template and Shortcut.

The video below demonstrates the process

Comments

Post a Comment

Popular posts from this blog

Mail message to Reminders Item and Trello Card

Image
 Wanting to keep track of work tasks and not wanting to use the employer supplied task manager (Outlook) I created the following workflow to create a Reminders item and Trello Card from an email I send to my personal email account.  Here are the steps that you need to follow to replicate this workflow. 1. Modify the Applescript Configuration to suit your needs, eg Trello email etc The Applescript needs to be saved in the following location /Users/(User Name)/Library/Application Scripts/com.apple.mail  I use the method of using a standard Applescript rather than one designed specifically for Mail Rules as I find the Mail Rules version does not run reliably.  2. If you want to use Reminders Tags, create a Shortcut as follows 3.  Create a Rule to trigger the Applescript if a Mail message is received using your nominated Task Tag, *** in my case.  4. Create an email and prepend *** to the Subject. If you want to set a due date beyond today, just add a number in the Subject line. Send the
Read more

Obsidian Daily Digest Shortcut

Image
Now that Shortcuts is available on the Mac as well as iOS devices, I am slowly switching, where possible, my workflows over to Shortcuts , making them cross-platform.   This Shortcut duplicates most of my Obsidian Daily Journal workflow that predominately relied on Applescript, making it unusable on my iPhone and iPad.   The output for pasting into my Obsidian daily note will list all of today's Calendar events and the open Reminder tasks. There are links to the apps that can be used on all devices.   If the routine is run on my Mac (which I typically do each morning), it will send the details of the Calendar events and Reminder tasks as an email to my work address.  The Shortcut can be downloaded here.  Hope it gives you some ideas on automating a similar process to suit your needs.
Read more

Apple Mail Rule Updater

Image
Apple Mail has the best Rules function compared to 3rd Party apps, but updating them is cumbersome. I have created the Applescript below that makes it easy to update Rules by adding one of the following parameters based on the selected Mail message(s) Email address Domain name Subject keyword Message content keyword In this example, I received a Twitter email regarding a post by Federico Viticci. I selected the message and invoked my Email Conflict Palette and chose option 7 I am then prompted to select the Rule to update and the Rule type to use. In this example  I ran each option, using "Gruber" as the keyword.  Note the Rule needs to exist first; you can create it using a dummy rule to get started. Here is the Rule after processing the email message. ZZZZ was the dummy entry. I find that I can process most of my Mail automatically with the use of Rules and this update routine makes the maintenance of the Rules system so much easier. I hope you find this approach of use; a
Read more