Here’s a nifty workflow for integrating Siri shortcuts and Google Sheets via Zapier. Use it to experiment with dictating or typing text into Siri on your iPhone or other iOS device and sending it directly into Google Sheets.
About Siri Shortcuts
With iOS 12 or later, Siri Shortcuts let you quickly do everyday tasks with just a tap or by asking Siri on your iOS device. Siri will suggest Shortcuts based on your common routines. But you can also easily create your own Shortcuts.
After you add a shortcut to Siri on your iOS device, you can run the shortcut by saying “Hey Siri,” then say the personal phrase you created for the shortcut.
Zapier moves info between your web apps automatically using simple workflows called “zaps.” It’s a powerful and useful tool. More than a million people use Zapier, and the service has a fantastic security record.
However, we always urge common
Now, to the good stuff…
How To Integrate Siri Shortcuts with Zapier and Google Sheets
In January 2019 I began tracking my daily moods (or more accurately outlook on the day) and more recently I decided to track my sleep habits as well.
Unfortunately I do not have very much data for the moods yet because it’s only been a month and I have even less because it’s been two days.
I have some extra data because I’ve inconsistently tracked sleep for years, but I’m looking forward to seeing what a year or so of data will show me. Here is what I have so far:
I’m not anticipating that all of this will be useful, but I figured it’s best to have a lot of data and decide later what is useful.
Step 1: Siri Shortcut Setup
Once you’ve decided what you want to track it’s time to set up the shortcut. For this you will need a Zapier account as well in order to automatically import the data to Google Sheets.
1 – Set up your Shortcut to gather whatever data you would like. This can look like using “Ask for Input” blocks or other data gather tools, for the purpose of this tutorial I’m going to assume you’re already comfortable with Siri Shortcuts.
2 – Now head over to Zapier.com. When you get to Zapier click “Make a Zap.”
3 – Select “Webhooks by Zapier” for your trigger app.
4 – Select “catch hook” and then save and continue. Skip the optional step to pick off a child key.
5 – On the next step you will see a link. Copy that link. Now it’s time to go back to the Shortcuts app.
6 – Back in the Shortcuts app underneath all of
7 – Tap “Advanced” in the “Get Contents of URL” block. Set “Method” to “POST” and leave everything else the same.
Under “Request Body” tap “Add New Field” and select “Text”. In the “Key” give a description, this will be used as the header in your columns on google sheets. You can add as many of these as you want. In the “Text” field add your variable.
8 – Now run your Shortcut. Head back to Zapier and click the button that says “Ok, I did this”. Click continue again and then let’s add an action step.
Step 2: Zapier Setup
1 – Select “Google Sheets” for your Action App. You will need a sheet already made for this step, so if you don’t have it set up head over to Google Sheets and create a new file and name it something that makes sense. You will also need to add headers with the same name as the “Key Field” that you made up earlier in your Siri Shortcut”
2 – On the next page select “Create Spreadsheet Row.” Click next and it will ask you to sign into Google.
3 – Select the spreadsheet you created and the worksheet you would like to import the data to. You’ll then need to select the matching key term from the dropdown menu.
4 – That’s all you need to do to get the data from your shortcut to google sheets!
Click through to name your Zap and make sure it’s turned on, and then every time you run that shortcut it will be imported to Google Sheets.
From there you can use that data in any way you’d like. As you see in my screenshot above I chose to look for relationships between mood and sleep times among other things.
Further reading: How to Create Siri Shortcuts Beyond Your iPhone
Read more productivity tips from on Danwrightphotography.com
Start your free trial
Start a free trial of Tiller Money and see why "89% say spreadsheets give them more control over how they track their finances" - Inc. Magazine, "The Science Behind Feeling In Control About Your Money"