Notion AI allows users to activate AI through various actions like using the space bar or slash commands. It integrates AI within the existing workspace for easy access and manipulation of AI-generated content. Notion AI follows data protection practices and offers unlimited AI usage with the add-on plan. Users can test Notion AI for free before opting for the subscription.