Can I create a workflow to automatically create deals for marketing qualified leads on Pipedrive?

Yes. Please check out this article to know how you can set this up: Creating custom workflows with Pipedrive integration