Best answer by Keith N
Welcome to the Community and thanks for reaching out. There isn't a way currently to automate volume changes in Sonos natively. I'd keep an ear out from others in the community about other possible solutions.
In the meantime, I have forwarded this feature request to the team. Thanks for the feedback.