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.
+14- Zapier Expert
- 31123 replies
Hi
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?
+14- Zapier Expert
- 31123 replies
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?
+14- Zapier Expert
- 31123 replies
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.