I was going to write up this how-to in a Google doc to share with a Facebook group I was a part of, but I figured I might as well share it.

Prep-work

  1. Create an account on Google Drive – if you have Gmail, you just need to activate Google Drive
  2. Create a folder called “shared”
  3. Create an account on IFTTT
  4. Download Workflow (app) onto your iPhone

Google Spreadsheet

  1. Open up the mail tracker spreadsheet

Do not just use this sheet (otherwise, you’d be logging your mail directly into the template everyone else would be using).

2. Make a duplicate by selecting File –\> Make a copy
3. Rename it to “Mail Tracker” (instead of “Copy of Mail Tracker”)
4. In the “Folder” field, select the “Shared” folder you’ve previously created.
5. (you can put it somewhere else, but then you’d need to remember the folder path and change it in the Workflow script)

Workflow

  1. Open this link on your iPhone
  2. Click on the “Get Workflow” button, this would open the Workflow app and save the workflow/script to the app.

  1. To activate the workflow, you just double-click the “Logging Mail” icon twice in the app. But do this after you’ve set up the IFTTT script (next section). There’s another, quicker, way to do this and I’ll show you how later.

IFTTT

  1. Click on this link to save the IFTTT rule into your account.
  2. Assuming you’re logged into your account, you should be able to add and turn on the IFTTT script

Creating a Button

To activate the Workflow script, you currently need to open the Workflow app and double-click the “Logging Mail” icon.

To make this quicker, can create an icon on your home screen that immediately activates the Workflow script.

So let’s make the icon.
1. Open Workflow app
2. Open “Logging Mail”, but clicking the icon once.
3. Click on the share sheet button:

  1. Click “Add to Home Screen” button:

  1. Follow the instructions on the screen.