6/14/2023 0 Comments Unread minbox gmail![]() =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.
0 Comments
Leave a Reply. |