![]() =CONCATENATE("-label:", TEXTJOIN(" -label:", TRUE, ARRAYFORMULA(SUBSTITUTE(LOWER(A1:A100), " ", "-"))))īasically, working from the inside out, you LOWERcase your labels and SUBSTITUTE hyphens for spaces across the whole range (i.e. Assuming that your labels are in cells A1:A100, your Google Sheets formula would look like this: You can actually do this in one line with no cut and paste. Then I simply used the formula = CONCATENATE to make the “-label:” part then another =CONCATENATE to merge them into a usable string. Then copied and pasted into a new column so I could find spaces in my labels and replace with dashes (-). You can also do things like rename your labels and move a child label to another parent.Ĭhris describes how he uses this to put the labels into a format that is usable in filters:įor example, once I had all of my labels in a column, I put them in lowercase with the =lower formula. Basically, it lets you connect your Gmail or GSuite account to a Google Sheet and pull all labels into a spreadsheet. Thanks to commenter Chris who alerted me to a new Google Sheets Add-On called Labels Manager. Label ALL of the results with a new “LABELED” label (or whatever you want).First search for every message that HAS a label ( has:userlabels).Method 4 - Desperate Measuresįinally, if all else fails, you can use this roundabout method from Federico (comment from ): So what I’ve done is simply create a shortcut (aka bookmark), which you can do quite easily and it works up until you add a new label, but then it’s just a simple matter of editing the bookmark. If you do this more than once, typing in all your labels in the arcane syntax Gmail uses gets old. -label: -label:label-three -label:label-four -in:sent -in:chat -in:inbox.Method 3 - Highly reliable but a pain in the butt.Method 2 - Simple but doesn’t work for everyone.-has:userlabels -in:sent -in:chat -in:draft -in:inbox.This is a pretty long article, so I’ve organized this article into sections - click any link below to jump directly to the section that solves your problem. (NOTE: I update these periodically to incorporate new user comments.)īelow the links is a Prefaceon my original motivation and my current feeling about labeling or not. But you don’t want to wade through the whole set of emails manually, right?Ī little filter magic will sort this out in no time. So how do you find GMail message with no label? ![]() It will include a lot of email threads with labels. Unfortunately, this still doesn’t work reliably for me (updated March 2019). So you want to find unlabeled GMail messages.Įasy, right? You just search on has:nouserlabels (see Method 2 below). Maybe you need to clean out a bunch of cruft and your unlabeled email is usually not important. You want all your GMail messages to have a label, maybe several. ![]()
0 Comments
Leave a Reply. |