Monday, March 19, 2018

Spreadsheet Tasker Plugin

I collect various types of data on my phone such as sleep data using Tasker. Traditionally, I've saved the data to a local file on my phone (typically a csv) and then used an app to transfer that data file to Google Drive.

I recently found a Tasker plugin app called Spreadsheet Tasker Plugin that will communicate directly with a Google spreadsheet. This approach is much easier.

In the case of my sleep data, each time I complete a sleep instance, it adds a row to a Google sheet with the data.

I have my phone set up via Tasker to start a sleep instance when the phone is oriented face-down and end the sleep instance when it no longer orients face down. I have a timer built in so that it only records the data after 30 minutes to avoid accidental downward orientations or instances where I haven't fallen asleep yet.

The paid version offers off-line buffering which stores the data if you aren't connected until a connection is made.

Google Play Store: Spreadsheet Tasker Plugin