How to extract color coded meetings out of Google Calendar?

  • 4 January 2022
  • 7 replies

I am trying to extract the color coded meetings out of Goggle Calendar into Google Sheets. Under the colorID field I am not sure what to select that would give me the correct color codes? 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +14

Hi @Dawnee 

Please post screenshots with where you are referencing in your Zap step configuration, thanks.



Under Color ID I don’t know which item to select that would pull the color codes from Google Calendar?

Userlevel 7
Badge +14


Is there another data point from the Zap trigger that would tell you which color it is?
Unless there is a returned data point from the Zap trigger that indicates the Color ID you are seeking, you may have to instead use a Lookup Table as a Zap step:

So I’m following the steps but still don’t know what would be the Lookup Key? What’s the lookup table?

Userlevel 7
Badge +14


The concept of a Lookup Table is to translate 1 value to another value.



Red | 1

Green | 2

Blue | 3


But that depends on having some value to use as the input.