How Are You Feeling – A Shortcut Integrating Cronios, IFTTT, and Google Sheets

Feeling (Cronios + IFTTT) is shortcut that asks you hourly how you are feeling. Working with Cronios, the shortcuts scheduler for iOS, Feeling (Cronios + IFTTT) records your dictated text to a Google Sheet via the IFTTT Maker Webhook.

This post shows you how you can integrate four services:

  1. Google Sheets
  1. IFTTT
  1. Shortcuts
  1. Cronios

to create complex, automated actions. For a simpler version of this shortcut that just writes to a tab-delimited text file, look at Feeling (Cronios + Text).

Let’s set up each of the four services:

Google Sheets Set Up

This shortcut requires a free Google account.

  1. Go to Google Sheets.
  2. Create a new sheet.
    Give it the name `Feeling Log`. Record the Google Sheet ID (it’s the long string at the end of the URL).

IFTTT Configuration

This shortcut requires a free IFTTT account.

  1. Create a New Applet.
  1. Tap `+ this`.
  2. Choose `Webhooks`.
  3. Tap `Receive a web request`.
  4. Enter `Feeling` in the Event Name field.
  5. Tap `Create trigger`.
  6. Tap `+ that`.
  7. Choose `Google Sheets`.
  8. Tap `Add row to spreadsheet`.
  9. Enter `Feeling Log` in the Spreadsheet name field.
  10. Enter `{{OccurredAt}} ||| {{EventName}} ||| {{Value1}} ||| {{Value2}}` in the Formatted row field.
  11. Tap Create action.
  12. Tap Finish.

Shortcuts

  1. Get Cronios, if you don’t already have it.
  1. Get the Feeling (Cronios + IFTTT) shortcut.
  2. Open Feeling (Cronios + IFTTT).
  3. Go through the configuration screens. These will appear the first time you run the shortcut.
  4. Enter your IFTTT Maker Webhook API key.
  5. Enter the IFTTT Maker Event Name `Feeling`.
  6. Enter the ID of your Google Sheet.
  7. Enter the language Siri should use.
  8. Enter the voice Siri should use.
  9. Enter the language you’ll be responding in.
  10. Enter the prompt to be spoken to you prior to dictation.

Cronios Set Up

Here’s how you get it set up:

  1. Get the Feeling (Cronios + IFTTT) shortcut.
  2. Create a new cron job in Cronios.
    Set a schedule for the cron job (i.e. * 8-22 1-31 1-12 *).
    Point the cron job to run the `Feeling (Cronios + IFTTT)` shortcut.
    Enable the cron job.
    Save your changes.
  1. Run Cronios.

What you’ve done is you have set up a new scheduled shortcut that runs every hour from 8 am to 8 pm every day. As long as Cronios is running, the Feeling (Cronios + IFTTT) shortcut will run each hour. Your response will be recorded to the Google Sheet Feeling Log using the IFTTT webhook applet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.