This app was mentioned in 51 comments, with an average of 1.76 upvotes
Yeah I will throw the necessary files in a Google drive folder and share a link tomorrow. It's 1 scene, 1 task, 2 html files for the graphs, and the gsheet. I'll try to put a basic walk-through of how to set it up.
You will need this Google Spreadsheet plugin
Very easy to do this using Tasker and the <strong>Tasker Spreadsheet Plugin</strong>. That integrates directly with Google Sheets and the free version of the plugin will take care of all basic functions like getting timestamp data into a field.
All you need to do is:
%TIMES
in for the cell value. (This is a unix timestamp).
And as a single-click solution each time you click the shortcut - Tasker will write the timestamp to the Google Sheet. Of course you can add lots of additional data along with the timestamp if needed, and you can/should add an Alert > Flash
action and/or vibrate to confirm to you that the Task was completed.
Regarding using the Sheets API or scripts, etc. - it is my opinion that doing it that way, while possible - will cause you short term insanity. Go with the plugin method ;)
Yes! To get the Google Spreadsheet information - the easiest solution is to use the <strong>Spreadsheet Tasker Plugin</strong>.
Then when the data returns to Tasker, you can use something like KWLP or Zooper etc (which show up in Tasker as plugins also) to get your data out to the related widget.
Regarding the Spreadsheet Plugin, I know /u/northcoffee is always working to improve it, so perhaps adding an option to a "Delete a row" is on the horizon there.
As far as other methods, anything involving sheets is going to require interacting with the Sheets API, which isn't the easiest API to deal with by any means.
AutoWeb currently has Sheets integration, and you could try adding Delete to it if you're handy with API's. Probably this API call has something to do with deletion.
If you're just trying to keep a log of backup times in a table format, then the easiest way to do it is with Spreadsheet Tasker Plugin (free).
To weigh in on the topic I have a budget tracking task that doesn't work around a daily budget, but does push purchases to a spreadsheet via a graphical interface. I use the free Spreadsheet Tasker Plugin to push the variables onto the sheet, it has a very simple means of updating a sheet that allows you to plug variables right in and an equally simple means of pulling the value of a particular cell on a sheet to a variable.
For another profile I use to track my projected earnings from my part-time job I use the above plugin to have a updated sum of my earnings above my clock in/out button. All the math to come to the number is done on a sheet and then pulled by the plugin.
So I guess what I'm saying is, with Spreadsheet Tasker Plugin, you could have it that on a purchase it sends the %TIME, %DATE, %purchaseamount into a row in a sheet, and then within the sheet have that amount deducted from your $25 budget. At the end of the day you can have the remaining budget pulled from the sheet to add to a running amount in some way or something like that, Tasker can easily store variables of that kind and if you wanted to you could just push them into another spreadsheet for safe keeping.
The difficulty I see you having is how to clear your daily purchases from the sheet when you want your budget to reset with the new day, because you don't want yesterday's purchases to mess with today's math. Liker others here I can throw a profile together for you that does everything up until this, but you may have to clear the spreadsheet yourself each morning, something that you might be ok with but would bug the hell outta me.
This is the play store link for the plugin. I have a similiar time tracking profile. When in the certain location ( or I can do it manually) AutoNotification creates a persistent notification with Start / Stop / Cancel buttons. Every time it starts and stops it records them as a JSON with the help of AutoTools. At the end of the the day it creates another notification to show total time. If you are interested I can share it.
Sounds good, and also there is a Google Sheets plugin for Tasker that isn't that difficult to use. - <strong>Spreadsheet Tasker Plugin</strong>
Can you create the to-do list in Sheets instead of Docs? Sheets is great for lists anyhow.
If you can, there's a great plugin for Tasker that can read and write extensively to/from Google Sheets - <strong>Spreadsheet Tasker Plugin</strong>
Made a task which plays a random Turret sound from Portal 2.
Bashed my head with trying to make a wake on lan task which would be made with a shell command, no luck.
Also started using the Google sheet tasker plugin and sadly it does not support updating a sheet with another sheet. Would be usefull, becuase if i want to update a row, and there is no connectivity, i couldnt save it and upload it later.
On the backend, what exactly do you want to use/create to store the data?
Right now the options are basically a flat text file through regular Tasker, or a Google Sheet using the Sheets plugin, or an SQLite database using the SQLite plugin.
You could try this spreadsheet plugin and see if it's easy enough to set up for what you want. Tasker can send email, but I believe you have to send it yourself and it only composes. There's a few different options for emails (Email Me or some scripting). If you don't want to text, I'd say try the spreadsheet.
If that doesn't work, you could create the URLs and save them in a variable and send one message at the end of the day.
The Google Sheets part will require some amount of effort on his part, he'll either need to download Spreadsheet Tasker Plugin, give someone access to his Google account, or follow some instructions.
Also, is your friend willing to buy AutoTools in addition to Tasker? I don't think that anyone will help unless he is willing to.
Also it likely won't look as pretty as the apple version, but should be much more configurable. Like being able to trigger it from a swipe or a notification.
Interacting directly with Google Sheets is one of the most convoluted processes on the planet.
The best suggestion is to use the <strong>Spreadsheet Tasker</strong> Google Sheets plugin. Makes everything super simple, and the basic version is free.
The most easy soulution is using Spreadsheets Tasker Plugin (it's working, don't worry). That's the first half. You simply need to upload that excel file to google drive (or Google Spreadsheets). I think it automatically converts to Google Spreadsheets file so you can read it on the web. But from this part, Spreadsheets Tasker Plugin comes into play. When you set it up, it will read your spreadsheet (that you uploaded on GSheets earlier) and write every cell into separate variable. Then use AutoWeb to set up inserting into GCalendar. Simply open it and browse for APIs -> find GCalendar ->Import it. Tasker -> Plugins -> AutoWeb -> Web Service -> Configuration -> Api -> Calendar. Api Action -> Event Add and from this point just set variables etc.
There are some in the /r/tasker sidebar. This is achievable with a Spreadsheet Tasker Plugin action, and some AutoTools web screen actions.
The hardest part should be to setup the AutoTools actions. After you get the task setup then you just make a Tasker widget and click it when you want to upload your data. I could write a template task for you.
Also you could use UiTask (free) instead of AutoTools.
Oh then definitely global variables. Or you could use spreadsheet plugin to store them In a Google sheet. This would be useful if the scene is ran on a separate phone than the 8am task or you wanted them saved in a safer place.
You need the Spreadsheet Tasker Plugin Spreadsheet Update action. You can also start a timer with the system timer action.
You should save the time in a variable, then you can update the Sheet, and start a timer.
I don't know how to use autovoice though, not sure if that was a question.
Here's a download link - just open it on your phone and it should import into Tasker.
As/u/mawvius mentioned look into Spreadsheet Plugin. It just may do the trick for you.
For the notifications read this: https://www.reddit.com/r/GooglePixel/comments/a8ksge/just_switched_to_android_and_pixel_for_the_first/eccn5pj
For saving to Google Sheets I use Spreadsheet Tasker Plugin. It's fairly straightforward. Select a Sheets document from your account, set the sheet to add to, give it some content via variables. That's about it.
You can use this plugin (Spread Sheet Plugin) to write in Google sheet.
​
You can use either Cell Near or GPS or Wifi connected state to trigger that task. You a boolean to trigger this task only the first time.
The most direct solution is to use the <strong>Spreadsheet Tasker Plugin</strong> which is reliable and the developer is also here on reddit.
You should download and test if adding data to your sheet will make it update (like you are thinking with IFTTT). If not and you have to use IFTTT to trigger the update, you can still use this plugin to retrieve all the data you want, in multiple formats based on how you need the data structured.
You need to create an excel file located on your Google Drive with the needed value headers. Call type / Date / Time / Number / Name
You also need the Spreadsheet Tasker plugin. It's on the play store. https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin&hl=ro
Incoming calls:
New profile - State - Phone - Call - Incoming
Task 1 - Wait 500 ms
Task 2 - Plugin - Spreadsheet Tasker plugin - Spreadsheet update - Select Google account - Select file - Select sheet
Rows - Incoming;%CDATE;%CTIME;%CNUM;%CNAME
Output mode : append row. Offline buffering checked
Outgoing calls:
New profile - State - Phone - Call - Outgoing
Task 1 - Wait 500 ms
Task 2 - Plugin - Spreadsheet Tasker plugin - Spreadsheet update - Select Google account - Select file - Select sheet
Rows - Outgoing;%CODATE;%COTIME;%CONUM;%CONAME
Output mode : append row. Offline buffering checked
The task is in the exit section
Received text mesages (excel file headers: number / name / date / time / message)
New Profile - Event - Phone - Received text
Task 1: Wait 500 ms
Task 2: Plugin - Spreadsheet Tasker plugin - Spreadsheet update - Select Google account - Select file - Select sheet
Rows: %SMSRN;%SMSRF;%SMSRD;%SMSRT;%SMSRB
Output mode : append row. Offline buffering checked
So you want to retrieve data from a Google spreadsheet?
In that case the easiest way is to use the <strong>Spreadsheet Tasker Plugin</strong>. It has a query function.
As for displaying it on a map, that function is avalbile within the <strong>AutoLocation</strong> plugin. I believe it requires GPS coordinates though.
There is a plugin called <strong>Spreadsheet Tasker Plugin</strong> that let's you update/query spreadsheets. That should help you do what you want :-}
I'll toss in one other solution that looks at it from a different standpoint, and will even let you rename the device(s) anytime you'd like:
If you're going to be sending data to a google spreadsheet (assuming with the <strong>Spreadsheet Tasker Plugin</strong> plugin) you can also pull/read data from a sheet as one of your first Task actions.
You can have the device look up its name from a google sheet that you've listed the names in , based on either or both of the following Tasker vars:
%DEVTID
"Returns the unique telephony-based ID for the device (e.g. he IMEI, the MEID, or the ESN)."
%SIMNUM
"The serial number of the SIM card, if one is present and accessible."
So you could have the phone retrieve its 'name' from a spreadsheet that you have, that contains the ID in one column, along with a matching name (you've designated) in another column. Just an idea ;) This would also be useful if you're using such a Task on several peoples devices, and for some reason the person changes their device name in "About device".
What Tasks/Actions exactly are you using to do the update? You posted all the errors but nothing about your Task.
Also - are you using the Google Sheets plugin for Tasker?
That spinning music record sounds pretty cool.
For the sqlite tasker plugin you don't need root. You can use it to create your own database and query and change it without root. You only need root when trying to access another app's database.
I used to use gtasks, but it didn't do EXACTLY what I want. And, like you, I also enjoy creating things myself and learning that way. I'd like to create a todo list that only displays tasks that are due within the next 7 days. I also want those tasks colour coded (e.g. green for tasks that are more than 5 days out and red for overdue tasks). I also want it to display how many days until a task is due instead of the date on which it is due. Finally, I also want to have recurring tasks that automatically add to the list at a pre-specified time interval (e.g. pay rent on the 25th day of each month). I couldn't find something that does exactly that, so I've been trying to figure out a way to do it myself.
One thing that did kind of work for me is using a Google Sheet to handle the task sorting by date. I ended up not using it since I couldn't get the recurring tasks to work properly but it may just work for you. You can set up a Google sheet and then query specific cells and post to specific cells using the Spreadsheet Tasker Plugin:
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin&hl=en
Sorry, I forgot to mention it in my first post. Let me know if you'd like more detail and I'll dig up my old spreadsheet and try to explain what I've done to get the whole thing to work.
I think your acquisition of plugins should be need-based. So if you need to do something that you find you can't do with regular Tasker, then look for a plugin to help. Like if one day you find you want to integrate Tasker with Google Sheets - use the <strong>Spreadsheet Tasker</strong> plugin.
However rather than 'needing' a specific plugin - there are some plugins that just make things easier to do using the plugin than regular Tasker. For example - if you want to create Lists/Menus/Icon Grids/Dialogs/etc - you can design your own Tasker Scenes without using or needing a plugin. However the "Scene Editor" in Tasker itself isn't that easy to work with. In fact some people hate it.
A much easier way to create the above items is to use <strong>AutoTools</strong>, or the <strong>Snackbar</strong> and <strong>Material Design</strong> plugins. I use these plugins constantly and rarely dive into Tasker's Scene Editor anymore - it's just too time consuming, especially trying to populate lists with dynamic data.
Overall there are many plugins to explore. In fact here is a giant list of Tasker plugins and 3rd Party Apps that have Tasker integration. As many have free and/or trial versions sometimes it's fun just to download them and check them out.
As a quick shout-out to the devs of some plugins I mentioned here, credit to /u/northcoffee for the "Spreadsheet Tasker" plugin. He's the only one on Earth to have taken on the challenge of creating a Google Sheets plugin and succeeded.
Also kudos to /u/nickm_27 for "Snackbar" and "Material Design". Nick put a lot of time into the plugins and took tons of feedback in the process from the Tasker community and especially from members of this subreddit while creating and testing these plugins.
I think I have what you're looking for ;)
Two Tasks to download:
* First Task is this main Task named "Log App Usage"
* Second Task is a timer Task called by the first one, named "Log App Time"
* Now just make a single Profile that triggers on Event > Variable Set: %WIN
and link it to that first Task ("Log App Usage")
As it is currently setup - it will log how many times an app is opened along wtih cumulative time in each app (as total seconds), and store all that info in a Global Variable named %AppUsageData
which when you look at it has this data format:
APPNAME--COUNT--TOTALTIME
Example of %AppUsageData
after a few apps have been opened:
EXAMPLE:
Google Play Store--3--120 Messages--2--65 Facebook--5--360
All times are in total seconds. So in the above example the Play Store was opened 3 times for a total of 2 minutes (120 seconds). There is an action in the first Task to put in excluded app names (based on their %WIN value) that you want to exclude from the list, like your homescreen, and Tasker, and anything else you don't want in your data.
The first Task also has some actions in there where you can have it write the data to a text file instead of (or in addtion to) the Global Variable. You could easily put this info into Google Sheets if you made a Task using the Spreadsheet Tasker plugin that pulls that data generated above. Check it out!
Not sure what search terms you tried but if you don't have access to a search engine like Google in your country and don't want to use the 3rd party Spreadsheet Tasker Plugin, you can do this using the Google Sheets API either managed using AutoWeb, or simply natively in Tasker.
I think this is feasible - Perhaps this plugin in tasker should be able to help you? https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin&hl=en_IN
Take a look at "Spreadsheet Tasker Plugin", it works! https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin
In a nutshell it would work something like this:
A Profile would be set to a certain time period (when you usually wake up) as well as a "Screen On" context.
That would trigger a Task that pulls the data from wherever your data source is, and show a Tasker Scene with the information.
An additional display option would be the Snackbar/Material Design plugins. Either way - the To-Do Item List would be in an array, and you give that array to the Scene or the plugin, and it displays it.
To add/remove items you'd need to create a system whereby clicking on (or swiping etc) an item would clear it from the list (by deleting it from the array and writing the updated array back to where you're storing the data).
And that's the outline in a nutshell. Plugins that will be helpful:
Should be doable with Google sheets using this plugin
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin
Spreadsheet Tasker Plugin, hope you get it to work!
Oh shit, I thought you were being sarcastic 😂
How are you going about yours?
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin
It still works for me. Have you uninstalled any Google services etc?
I know you want to do it yourself, but there is a spreadsheet plugin for Tasker as well.
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin
Still able to get this though. Try this link.
Google Sheets or you can use this plugin Spreadsheet Tasker Plugin
Spreadsheet Tasker Plugin should come in handy.
Welcome to Tasker! The project you mention should be fairly straightforward. First of all though, you may want to get familiar with Tasker by watching some of these videos, regarding workflow and how everything works in general.
To specifically answer your question, you'd make a Profile for "Received Text", and specify the sender as whatever number your bank sends from. You link that Profile to a Task, where the message will be available in the variable %SMSRB
. Depending on exactly which xxxx
numbers you want from the message, you can use the "Variable Search" action to pull/parse your desired data from the message.
Lastly you'd use the <strong>Spreadsheet Tasker Plugin</strong> to upload the information to the Google Sheet of your choosing. Overall the whole thing is just one Profile context and a Task with two actions. However it's a bit more complex because of dealing with the data.
"spreadsheet tasker plugin" is the one I've been using. No complaints at all
There's a Google Sheets for Tasker read/write plugin now.
will do, ty
edit: this is what i found, it seems like exacly what I need for the task!
https://play.google.com/store/apps/details?id=com.uitcon.spreadsheettaskerplugin&hl=en