How to automatically apply a Lightroom Preset based on appropriate (Canon) Picture Style on import

Note: I do not believe this question is a duplicate of "How to emulate the in-camera processing into lightroom" (I referred to this question in my question) I just want that my monochrome images stay monochrome and my colored should stay in color.

Explanation:

• shoot photo 1 with Picture Style "Color"



• shoot photo 2 with Picture Style "Monochrome":

On import of both raw files, I want Lightroom to automatically:

• apply Lightroom Preset "MyColor" to all photos shot with Picture Style "Color" (in this case photo 1)


• apply Preset "MyMonochrome" to all photos shot with Picture Style "Monochrome" (in this case photo 2)

If I import Raw Files into Lightroom, which where shot with the Picture Style "Monochrome", the Thumbnail list in Lightroom shows the correct monochrome Pictures, but as soon as Lightroom starts to rebuild the Thumbnails (not using the jpg sidecar file or the embedded thumbnail any more) it builds the thumbnails from the Color Image, not respecting the Monochrome Picture Style.

Of course I can import all images and auto-apply a monochrome Lightroom development setting, but I often switch between Monochrome and Color while shooting, so it would be helpful to extract the information from the raw file and apply different Lightroom presets based on it.

Related questions:

How do I start with in-camera JPEG settings in Lightroom?

Does not help: I have no process option for "Monochrome".

How to emulate the in-camera processing in Lightroom?

Maybe right (that it is not possible to apply picture Canon picture styles), but I hope that one of you may have a solution or a workaround for the problem.

Update3: I found out that the Data is present in the Metadata in the Raw file (thanks to ExifToolGui & ExifTool)

Tag Name: PictureStyle
Value: Monochrome

So it would be a solution to import the Photos normal, then filter them by the Picture Style and manually apply a previous defined Lightroom Preset to the result.

The problem is, that Lightroom does not show this Metadata, so it can't be used for filtering.

Possible solution can be using the metadata-wrangler

further reading:

Answer

There is a solution provided by Jeffrey Friedl and his awesome Lightroom plugin "Data Explorer".

1. download and install the plugin


2. select all the images, which have different canon styles applied, you want to process. the free version of the plugin is limited to handling a maximum of 500 images at once. Edit > Select all


3. run the data explorer. File > Plug-in Extras > Explore...

4. 
   

   choose "User-Specified Master-File Data Field" in the "Explore" Field and "MakerNotes:PictureStyle" in the "Field" field and press the "Begin" button.

   
   


5. 
   

   Press the "isolate" or "Isolate Each Reslut to its own Collection" Button to get a Collection which have, for example, only the "Monocrom" Picture Style.

   
   

6. Then apply a "Saved Preset" from the Quick Develop Section. For example Lightroom B&W Presets > B&W Look1

you are done. all your canon monochrom picture styled images have now a LR B&W preset applied.