Question

How to extract color coded meetings out of Google Calendar?

  • 4 January 2022
  • 7 replies
  • 101 views

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

@Dawnee 

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: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

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

@Dawnee 

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

e.g.

INPUT | OUTPUT

Red | 1

Green | 2

Blue | 3

 

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