Did you get this sorted? I’m trying to do the same using the London Underground sensor and then have my google home read the description which is an attribute. I can make it work with the main state but not the attribute.
The use case doesn’t matter, it’s the same need as you mention hence I’m interested in whether you resolved.
So I did finally make this work. It seems you have to create a separate sensor to extract the attribute. And then you refer to that new sensor in the automation itself - it worked fine once I had done that. Surprising but it does work.