Replacement solution for IFTTT+Gmail -> GQueues?

1,415 views
Skip to first unread message

Jen L

unread,
Mar 26, 2019, 10:53:01 AM3/26/19
to GQueues Discussion Forum
I am a power user of IFTTT and have had numerous applets set up for many years that search my gmail for keywords on incoming mail and forward them to my GQueues using the QuickAdd syntax to organize/date/tag them properly. Unfortunately, IFTTT+Gmail functionality (and Gmail + other integrations) is going to be significantly hindered in the coming days due to a tightening of the Gmail API: https://help.ifttt.com/hc/en-us/articles/360020249393-Important-update-about-the-Gmail-service (this does not affect the GQueues add-on for Gmail!)

While I can simply set up filters within Gmail to automatically forward desired emails to GQueues as tasks, I can't figure out how to append my desired QuickAdd syntax within the filter so the tasks will get organized properly. Any ideas? Other workarounds?

Cameron (GQueues Team)

unread,
Mar 26, 2019, 7:03:45 PM3/26/19
to gqu...@googlegroups.com
Hi Jen - 

Would Zapier be a viable alternative?  I'm not sure if they comply with Gmail's new API restrictions, but it looks like they still have triggers based on incoming emails.  

-Cameron

Jen L

unread,
May 23, 2019, 1:15:07 PM5/23/19
to GQueues Discussion Forum
If anyone else has been struggling with this, I have managed to work out a solution for myself. It uses Gmail Filters, Google Sheets, and a Google Apps Script to forward emails to GQueues with proper Quick Add Syntax. It's customized from the concept/script that a Redditor posted: https://www.reddit.com/r/ifttt/comments/b3zv1z/alternative_to_gmail_applet_using_sheetsapp/  

For now, the solution I'm using is kind of for my eyes only (e.g. messy), but if there's interest, I'll write up instructions and re-create a version of the Script + Spreadsheet specifically to share with the GQueues community like I did for the "Subtask Template Calculator." 

Solution Overview:


1) Implement Gmail Filters to add specific Labels to emails (as they come in) that I want forwarded to GQueues.

2) Set up a Google Sheet containing the instructions/syntax for what to do with each kind of filter/label.

Capture.PNG


3) Add custom Google Apps Script to the Google Sheet. The Script will scan Gmail for desired Labels, forward them to GQueues with corresponding Quick Add Syntax, then change the Label in Gmail so the messages don't get processed a second time.


4) Set up a Trigger to run the Google Apps Script every 30 min (which is fast enough for my needs, but could be customized).

Reply all
Reply to author
Forward
0 new messages