Google Keep & Tasker

2,227 views
Skip to first unread message

kreator837

unread,
Jan 25, 2014, 4:38:45 AM1/25/14
to tas...@googlegroups.com
Not sure if this is possible, but I'd like to have Google Keep pop up my shopping list whenever I am in the shopping centre. I am currently using AutoLocation (when I'm in the shops) and AutoLaunch to launch Google Keep. However, I'd like Keep to start at my shopping list page instead of the first page. At the moment, I am having to navigate manually to the shopping list note. 

What should I be doing to get Keep to start at the shopping list note?

Thanks in advance. 

Matt R

unread,
Jan 25, 2014, 1:14:44 PM1/25/14
to tas...@googlegroups.com
Easiest would be to use the "launch activity" function of the secure settings plugin to see if an activity exists for it that you can launch right into.

Matt

Spool Accounts

unread,
Jan 30, 2014, 6:58:17 AM1/30/14
to tas...@googlegroups.com
Thanks Matt R
It can launch in but still just goes to the first page. I can't get it to launch to the list that I want. Any other ideas?

Matt R

unread,
Jan 30, 2014, 12:45:33 PM1/30/14
to tas...@googlegroups.com
You can try looking at the android manifest with something like Android System Info app, but I think it's unlikely you'll find any launchable activities that don't already show up in the Secure Settings plugin.

Matt

Rory Harnisch

unread,
Jun 4, 2014, 1:33:28 PM6/4/14
to tas...@googlegroups.com
You can actually do this with a bit of SQL database and regex knowledge. I've pasted a few of the actions that I use below. It pulls, from the database, the "unchecked" items from your specific Google Keep checklist and strips away the newline and white spaces. You will be left with a standard tasker array (%Groceries()) for you to use whoever you please. You will have to modify the XML below for your particular list but mine works just fine.
 
The way I use it is the following: Every time I'm within the AutoLocation geofence for my grocery store, a  custom notification (using AutoNotification) pops up on phone which can be clicked to pull up my list on my pebble (using AutoPebble). I can even pull up this list right on my pebble, as long as I'm within the grocery store geofence, without clicking on the notification from my phone. The list acts like a checklist in that when ever I select an item, it creates a new list without that clicked item so as to check it off my list. It's a pretty neat and useful tool. Hope this helps.
 
<TaskerData sr="" dvi="1" tv="4.3u4m">
<Task sr="task188">
<cdate>1401902123175</cdate>
<edate>1401902431606</edate>
<id>188</id>
<nme>Grocery List From keep</nme>
<pri>10</pri>
<Action sr="act0" ve="5">
<code>123</code>
<Str sr="arg0" ve="3">system/xbin/sqlite3 /data/data/com.google.android.keep/databases/keep.db " SELECT text_search_tree_entities_content.c0title, list_item.text, list_item.list_parent_id, list_item.is_checked FROM text_search_tree_entities_content, list_item WHERE c0title = 'Grocery List' AND list_parent_id = 1 AND is_checked = 0";</Str>
<Int sr="arg1" val="0"/>
<Int sr="arg2" val="1"/>
<Str sr="arg3" ve="3">%Groceries</Str>
<Str sr="arg4" ve="3"/>
<Str sr="arg5" ve="3"/>
</Action>
<Action sr="act1" ve="5">
<code>598</code>
<Str sr="arg0" ve="3">%Groceries</Str>
<Str sr="arg1" ve="3">Grocery List\||\|1\|0</Str>
<Int sr="arg2" val="0"/>
<Int sr="arg3" val="0"/>
<Int sr="arg4" val="0"/>
<Str sr="arg5" ve="3"/>
<Int sr="arg6" val="1"/>
<Str sr="arg7" ve="3"/>
</Action>
<Action sr="act2" ve="5">
<code>598</code>
<Str sr="arg0" ve="3">%Groceries</Str>
<Str sr="arg1" ve="3">\n</Str>
<Int sr="arg2" val="0"/>
<Int sr="arg3" val="0"/>
<Int sr="arg4" val="0"/>
<Str sr="arg5" ve="3"/>
<Int sr="arg6" val="1"/>
<Str sr="arg7" ve="3">,</Str>
</Action>
<Action sr="act3" ve="5">
<code>590</code>
<Str sr="arg0" ve="3">%Groceries</Str>
<Str sr="arg1" ve="3">,</Str>
<Int sr="arg2" val="0"/>
</Action>
<Action sr="act4" ve="5">
<code>548</code>
<Str sr="arg0" ve="3">%Groceries</Str>
<Int sr="arg1" val="0"/>
</Action>
</Task>
</TaskerData>

Marta Hintz

unread,
Jun 4, 2014, 2:26:00 PM6/4/14
to tas...@googlegroups.com
That looks cool, can you export as description? I learn better that way.

Rory Harnisch

unread,
Jun 4, 2014, 2:33:40 PM6/4/14
to tas...@googlegroups.com
Awh yes, sorry. Here ya go:

Grocery List From keep (188)
A1: Run Shell [ Command:system/xbin/sqlite3 /data/data/com.google.android.keep/databases/keep.db " SELECT text_search_tree_entities_content.c0title, list_item.text, list_item.list_parent_id, list_item.is_checked FROM text_search_tree_entities_content, list_item WHERE c0title = 'Grocery List' AND list_parent_id = 1 AND is_checked = 0"; Timeout (Seconds):0 Use Root:On Store Output In:%Groceries Store Errors In: Store Result In: ] 
A2: Variable Search Replace [ Variable:%Groceries Search:Grocery List\||\|1\|0 Ignore Case:Off Multi-Line:Off One Match Only:Off Store Matches In: Replace Matches:On Replace With: ] 
A3: Variable Search Replace [ Variable:%Groceries Search:\n Ignore Case:Off Multi-Line:Off One Match Only:Off Store Matches In: Replace Matches:On Replace With:, ] 
A4: Variable Split [ Name:%Groceries Splitter:, Delete Base:Off ] 
A5: Flash [ Text:%Groceries Long:Off ] 




On Wed, Jun 4, 2014 at 11:25 AM, Marta Hintz <lar...@gmail.com> wrote:
That looks cool, can you export as description? I learn better that way.

--
You received this message because you are subscribed to a topic in the Google Groups "Tasker" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tasker/bCZqvzN-VWk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tasker+un...@googlegroups.com.
Visit this group at http://groups.google.com/group/tasker.
For more options, visit https://groups.google.com/d/optout.

Marta Hintz

unread,
Jun 5, 2014, 12:12:26 AM6/5/14
to tas...@googlegroups.com
Nice Thank you, time to experiment

Mark

unread,
Oct 20, 2014, 7:16:56 AM10/20/14
to tas...@googlegroups.com
Hi Rory

This looks particularly interesting but I get the following error when trying to import it:  Error import of shoppinglist.prj.xml failed: no %1$s found

Although I have got it sort of working (mine loads random notes from another google account which happens to be the default one on the phone), I'd like to see if I can get yours working with clickable lists if possible.

Any chance you have seen this error before or can shed any light on it?

Cheers,
Mark

Rory Harnisch

unread,
Oct 20, 2014, 10:21:58 AM10/20/14
to tas...@googlegroups.com
Mark,

For the errors, I don't think I can help you that much as I'm not sure what they mean exactly. I can speculate that they have something to do with the way your database query looks. What I basically did was used SQlite debugger from the play store (requires root) to look through the Google Keep Database to find this information. I finagled the search query inside SQLite Debugger to get to what I needed. Then I copy/pasted the query into a Run Shell command in tasker to pull that information into a variable. From that point, I just massaged the variable to a comma separated list of items using the Variable search and replace a few times. Looking back, I probably could have altered the Run Shell SQLite query to make it easier but it still works just fine. Try SQLite debugger first and let me know if you need further help.

-Rory

kreator837

unread,
Dec 8, 2014, 8:08:39 AM12/8/14
to tas...@googlegroups.com
Hi, finally got around to trying the sqlite query. Instead of picking up the Grocery list, the query picks up texts from another note. Is there a reason why the unchecked items aren't picked from the list?
Message has been deleted

Rory Harnisch

unread,
Dec 8, 2014, 11:02:04 AM12/8/14
to tas...@googlegroups.com
What is the SQL query you're using? Paste it here.

On Mon, Dec 8, 2014 at 5:08 AM, kreator837 <spo...@gmail.com> wrote:
Hi, finally got around to trying the sqlite query. Instead of picking up the Grocery list, the query picks up texts from another note. Is there a reason why the unchecked items aren't picked from the list?

Spool Accounts

unread,
Dec 8, 2014, 3:43:19 PM12/8/14
to tas...@googlegroups.com, Rory Harnisch
I'm just running the query from your earlier post and then flash %Groceries. I've got a Google keep list name "Grocery List" per the query.

/system/xbin/sqlite3 /data/data/com.google.android.keep/databases/keep.db "SELECT text_search_tree_entities_content.c0title, list_item.text, list_item.list_parent_id, list_item.is_checked FROM text_search_tree_entities_content, list_item WHERE c0title = 'Grocery list' AND list_parent_id = 1 AND is_checked = 0"

Scott Almond

unread,
Dec 11, 2014, 11:47:33 AM12/11/14
to tas...@googlegroups.com, rmhar...@gmail.com
I'm no expert with SQL databases, but I suggest changing the last "0" to a "1". that should pull the unchecked notes as well.

Regards
Scott

SunKol

unread,
Dec 12, 2014, 4:48:25 AM12/12/14
to tas...@googlegroups.com
You need to have AUTOSHARE. 
Intercept the share once in autoshare from KEEP and use it further.

SK

Spool Accounts

unread,
Dec 12, 2014, 6:58:03 AM12/12/14
to tas...@googlegroups.com
Thanks SK. Can you explain further how to do this? I'm a novice

Spool Accounts

unread,
Dec 12, 2014, 7:01:46 AM12/12/14
to tas...@googlegroups.com
Thanks Scott. Tried this but nothing is picked up now, checked or not.

SunKol

unread,
Dec 12, 2014, 10:18:00 AM12/12/14
to tas...@googlegroups.com
Here is my profile that use Autoshare
Profile:

AS - Command Keep (374)
State: AutoShare [ Configuration:Command: Keep
Sender: all
Subject: all
Text: all
Image: all ]
Enter: Share KEEP (433)
A1: AutoShare [ Configuration:Package: com.google.android.keep
Class: com.google.android.keep.activities.EditorActivity
App: AutoShare
Action: Share
MimeType: */*
Subject: AutoShare on %DATE %TIME
Text: %astext Package:com.joaomgcd.autoshare Name:AutoShare Timeout (Seconds):10 ]
A2: Wait [ MS:0 Seconds:1 Minutes:0 Hours:0 Days:0 ]
A3: Go Home [ Page:3 ]

Darijo Gospić

unread,
Jun 12, 2015, 6:37:08 AM6/12/15
to tas...@googlegroups.com
Is it possible to get reminder date & time set in Google Keep?
Not rooted 
Reply all
Reply to author
Forward
0 new messages