Hi Evgeniy,
Welcome to Affinity Forums
Do the following: open a document on Affinity Photo on iPad, tap the Macros Studio icon on the right (looks like a play button - almost on bottom), then tap the small menu icon on the top of the Macros Studio and select Import Macros.... Pick the .afmacros file you have placed on iCloud/cloud service. To access them tap the button on top of the Macros Studio (it probably says <Default>) to open a pop-up, scroll that pop-up and select corresponding section (which are the ones you imported) to display them.