Goal:
I’m trying to connect Pocket and Google Sheets to track how many items I’m saving and how many items I’m reading.
Setup and Problem:
I have two scenarios that use the Pocket “Watch Items” module as their trigger. The first scenario is meant to watch for “unread” items and the second scenario is meant to watch for “archived” items. Once triggered, both scenarios send a bunch of info about the items in Pocket over to Google Sheets. I have both scenarios set to run every 60 minutes and I also have them set to execute “from now on.”
The first scenario is executing just fine, pulling any items I’ve added to Pocket since the last scenario execution into Google Sheets just as expected.
However, the second scenario watching for “archived” items often pulls nothing, even when I’ve moved something in Pocket from “unread” to “archived” since the last scenario execution. I can’t seem to figure out why this isn’t working or what I can do to fix it. Any pointers would be appreciated, including alternative solutions!
Scenario 1:
Scenario 2:
“Where to Start” Settings:
For the trigger module with the State set to “Archive”, do you see any items when you select “Choose manually” from the “Choose where to start” dialog?
2 Likes
Yes, I can see items when I do that, but interestingly, it seems to be a random assortment—some from my “unread” list, some from my “archive,” and in no particular order (i.e. not just the most recent additions).
The trigger works more often than not when I run it manually. It’s when it’s running on a schedule that it seems to miss items more consistently.
Perhaps you can try setting it to the default “All”, then create a filter to match items by status, if that’s possible?
2 Likes
Yes, I thought that might be a solution, but the behavior seems no different. I think the Pocket “Watch Items” module essentially builds that filtering in, so watching “all items” and filtering down to “archived” in a later step is no different.
I’m still testing, but I seem to have found a solution using this flow in Make:
This seems to trigger reliably whenever a new item is added to the “unread” list; once it triggers, the “get items” module seems to do a good job of retrieving items on the “archive” list. Then I check the item IDs of the items returned by that module against what is already in the spreadsheet to avoid adding duplicates.
There are a lot of edge cases to test, so I may still find that some trip up even this flow, but for now, it seems to be working.
3 Likes
Heya @Jeffrey_Hart 
Grea job figuring this one out with the guidance of @samliew 
Thanks a lot for stepping back into the community and sharing your insights and your final setup with us. This is super valuable and can be incredibly helpful to others looking for similar information 
1 Like
