If your added iframe macro shows as a blank page in confluence page. I think there are two places you need to check.
- Ensure the site url (include protocol scheme) has been whitelisted.
- Check whether the site allows cross origin access.
For example, *.sharepoint.com does not cross origin access by setting x-frame-option as SAMEORIGIN.