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.
Userlevel 7
+14
- Certified Zapier Expert
- 24174 replies
-
4 January 2022
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?
Userlevel 7
+14
- Certified Zapier Expert
- 24174 replies
-
4 January 2022
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?
Userlevel 7
+14
- Certified Zapier Expert
- 24174 replies
-
4 January 2022
Hi
Please post screenshots with where you are referencing in your Zap step configuration, thanks.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.