I am trying to automatically forward an email in Gmail that gets labeled with a specific label, but I’m running into problems with what feels like should be a simple automation.
Here’s what I’m doing:
- A conversation in Gmail is tagged with a label (e.g. “Receipt”)
- I use Zapier’s Gmail “New Labeled Conversation” trigger, which returns a Thread Id
- I use Gmail “Find Email” to look up the email by Thread ID (i.e. search query “threadId:<THREADID>”).
- I then use Gmail “Send Email” to create a new email with all the information as the email I looked up (subject, body, attachments, etc.) and send that to my accounting software (since Zapier doesn’t have a “forward email” action).
The issue is with step #3. Zapier formats the Thread ID as HEX, but Gmail expects it as a 64-bit integer. So the search fails.
Yes I could insert a code step #2.5 that converts the HEX Thread ID into decimal, but that seems silly and costs me a task per run. I feel like I am missing something simple – Zapier’s trigger returns a thread ID, and I should be able to use that Thread ID to look up associated emails.
Any suggestions?
(and yes, I do know there is “New Labeled Email” as a trigger that just returns the email directly; the problem is it also triggers on replies, and my accounting software always replies to a forwarded receipt with a confirmation, which is going to trigger the Zap again, and create a loop)
