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?
Question
How to extract color coded meetings out of Google Calendar?
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 Orchestrator & Solution Partner
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 Orchestrator & Solution Partner
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 Orchestrator & Solution Partner
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.
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.