Using Dynamo to filter families from a type catalog based on an excel workbook


I am wondering if it is possible to write a script that loads a family with an associated type catalog into a file and filters the type selection based on an excel spreadsheet.

I have a large number of families cached within a type catalog and I want to load 2 or 3 three of the families within the type catalog into my model. Our firm has a standard naming convention and so I know the names of the families I am looking for, it is simply a bother to have to manual scroll through the type catalog every time I want to load these families.

In addition to the naming convention, we have an excel spreadsheet that tracks the families we are working with. I have already got my family name tracked as a value within the spreadsheet.

Is there a way to write a script to load a family and automatically filter the types loaded from the type catalog based on the preexisting spreadsheet?

I’m not sure if this is specifically for type catalogs or not as it doesn’t seem to actually say, but this seems like a starting point.