Hey,
Just a heads up…
I don’t believe Dynamo will be more Automatic than Revit…
if your model changes you will need to manually open your Dynamo Graph and run it. You could export your Revit schedule as a .txt and link it to excel and it would be similarly quick.
That said, Dynamo gives you an unlimited amount of flexibility in creating your Excel…
The Bumblebee package will let you automatically format it and give precise control over the output:
If you just want a basic graph which extracts parameters, to excel, there is an example here:
Hope that helps,
Mark