Thanks I will give it a go.

I have a lot of components in a drawing and I would like to be able to change their colors based off an excel spread sheet. I would like to build the components in sketchup export them to a csv file, then in the csv file add a column for color, filter the components and add color, then import it back into sketchup. Just wondering if this is possible with either a regular component or a dynamic component or some kind of ruby script?

Thanks