Labels Manager for Gmail

  • Labels Manager is a free Google sheet add on which can help you perform bulk operations on your Gmail labels.
  • Bulk Create, Update, Delete and Export your Gmail labels in your Google Sheet.
  • Use it right from your Google Sheets without a line of code to manage your Gmail labels.

FAQ

Most frequent questions and answers about Labels Manager for Gmail

You can create Gmail labels in bulk with Labels manager for Gmail, and it also allows you to define the background and text color for Gmail labels by simply putting color as as hex string #RRGGBB (ex #000000).

Note -: Gmail only allows to use following color codes for label background and color, you can also go to https://www.color-hex.com/ and put following code to see the actual color behind following codes.

You can use following color codes for Gmail label background:

#000000, #434343, #666666, #999999, #cccccc, #efefef, #f3f3f3, #ffffff, #fb4c2f, #ffad47, #fad165, #16a766, #43d692, #4a86e8, #a479e2, #f691b3, #f6c5be, #ffe6c7, #fef1d1, #b9e4d0, #c6f3de, #c9daf8, #e4d7f5, #fcdee8, #efa093, #ffd6a2, #fce8b3, #89d3b2, #a0eac9, #a4c2f4, #d0bcf1, #fbc8d9, #e66550, #ffbc6b, #fcda83, #44b984, #68dfa9, #6d9eeb, #b694e8, #f7a7c0, #cc3a21, #eaa041, #f2c960, #149e60, #3dc789, #3c78d8, #8e63ce, #e07798, #ac2b16, #cf8933, #d5ae49, #0b804b, #2a9c68, #285bac, #653e9b, #b65775, #822111, #a46a21, #aa8831, #076239, #1a764d, #1c4587, #41236d, #83334c

You can use following color codes for Gmail label text:

 #000000, #434343, #666666, #999999, #cccccc, #efefef, #f3f3f3, #ffffff, #fb4c2f, #ffad47, #fad165, #16a766, #43d692, #4a86e8, #a479e2, #f691b3, #f6c5be, #ffe6c7, #fef1d1, #b9e4d0, #c6f3de, #c9daf8, #e4d7f5, #fcdee8, #efa093, #ffd6a2, #fce8b3, #89d3b2, #a0eac9, #a4c2f4, #d0bcf1, #fbc8d9, #e66550, #ffbc6b, #fcda83, #44b984, #68dfa9, #6d9eeb, #b694e8, #f7a7c0, #cc3a21, #eaa041, #f2c960, #149e60, #3dc789, #3c78d8, #8e63ce, #e07798, #ac2b16, #cf8933, #d5ae49, #0b804b, #2a9c68, #285bac, #653e9b, #b65775, #822111, #a46a21, #aa8831, #076239, #1a764d, #1c4587, #41236d, #83334c

 

 

Though you can create unlimited number of labels, however Google enforces some limitation on the script execution time as following-:

1. Personal @gmail account OR G Suite Basic edition users have a limit of 6 minutes for script execution, that means script for you can run maximum for 6 minutes.

Though I have not tested but You should be able to create upto 100 Gmail labels at once.

2. G Suite Business, Enterprise or Education edition users have a limit of 30 minutes for script execution time, that means script for you can run maximum for 30 minutes.

Though I have not tested but You should be able to create upto 300 Gmail labels at once.

What if you need to create more than that, like 1000 Gmail labels at once?

You can create them in small batches instead of putting all 1000 at once.

 

1. Please make sure that you watched the videos above and followed the directions as shown in them.

2. If you are still getting an error, try removing the add on, install it again and give it a shot.

3. If it still does not work, then record a video (I would recommend https://www.useloom.com/ for it) which shows your attempt to use the add on and the error, and put that in the comments below for me to look at and help you out.

I appreciate it, you can simply comment your feature request below and I would try to add it as soon as I get time.

Ideally your feature request should include following-:

1. Title of the feature request.

2. Explanation / Summary of the use case behind it.

3. How would it make your job easy?

Note -: I am a full time employed with a demanding family, So I can’t commit any timeline to add your requested features, but rest assured I love helping out G Suite community and would do my best to add your requested feature if it make sense.

Apologies, I do not freelance.

However, please put it as comment below, and I will try to help (for free) as soon as I get time.

2 thoughts on “Labels Manager for Gmail”

  1. Hello, I tried to update my labels however I keep getting this message “API call to gmail.users.labels.update failed with error: Invalid value for: labelShow is not a valid value”. I put “labelShow” under the Label Visibility column.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.