On your Mac, make sure iCloud Drive is setup in System Preferences>iCloud
On your iPad, make sure iCloud is switched on for Notion. Go to iPad Settings>Notion>iCloud Enabled
Please ensure you are using the same Apple ID on both your iOS device, and your Mac.
You should then see a Notion folder appear in your iCloud Drive folder on your Mac.