STEP-1
Go to Confluence Settings right top corner → Apps → CircleCI Connector.
Generate CircleCI Personal Token
STEP-2
Go to CircleCI App → Click Workflow → Copy URL from Browser.
Go to Confluence Page choose Macro CircleCI Workflows → Edit.
That's It.
We don't have a way to export this macro.