@Padashwi
Macro: Your macro does not contain a macro output tool so no data will flow out of the macro. It looks like that macro is writing to something using the output tool within the macro. So data is flowing into the location, but won't be presented to the final user. If you want someone to be presented with the result you must add a macro output tool within the macro and then outside the macro in the workflow add an output tool using the file format you want. I would recommend swapping out the output tool with a macro output tool and then adding that output tool to the macro output anchor in the workflow.
Server: When you save the workflow to the server, the pop-up screen should allow you to select the macro. If it's not in the initial screen you should see an ability to add assets or variables to the workflow. You can select that option and you should see the macro there. When you make the selections it will package the workflow with the macro and send to the server. As far as the run button goes, I am not sure what would cause that. Somethings you may want to investigate is making sure the workflow is designated as an app in the workflow configuration, you may also want to check with your server admin on permission rights, or you can always reach out to our support team.
I would recommend reviewing these resources:
https://community.alteryx.com/t5/Interactive-Lessons/Deploying-your-Macros/ta-p/657929
https://alteryxhelp.prod.acquia-sites.com/20214/server/save-workflow-server
https://alteryxhelp.prod.acquia-sites.com/20221/designer/workflow-dependencies
