Skip to main content

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? 

@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.


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


@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


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


 


 


Hi @Dawnee 

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