An iOS Shortcut can add data to a Google Sheet

I followed this short guide by Thiago Alves for sending arbitrary data to Google Sheets from iOS via an iOS Shortcut and a Google Form and it worked like a charm.

In brief, here are the steps:

1. Create a Google Form
2. Link it to a Google Sheet
3. Copy the pre-filled link to your form and edit it to end with &submit=Submit and say formResponse instead of viewform 
4. Use a “Text” shortcut action to insert your data into that link
5. Use a “Get contents of URL” action to send your data to your form results sheet

A response link for a form with one question will look something like this:

https://docs.google.com/forms/d/e/<form-id>/formResponse?usp=pp_url&entry.<question-id>=<answer>&submit=Submit

Here’s what my shortcut to save the current URL looks like: