This n8n workflow automates project status monitoring by integrating Airtable with the Motion API, and sending email notifications via Gmail. It is scheduled to run monthly, specifically between the 10th and 31st at 8 AM, to ensure timely updates. The process retrieves project data from Airtable, filters for active projects, fetches project details from Motion, and checks for specific task completions such as blog article integration. When milestones are achieved, customized email notifications are sent to relevant stakeholders, ensuring everyone stays informed about project progress.

The workflow begins with a scheduled trigger, then pulls project information from Airtable. It filters projects based on their ‘Actif’ status and whether last update was before the start of the current month. For each project, it requests project details from the Motion API. Projects are categorized, and tasks like ‘Intégrer les articles de blog’ are monitored for completion. When a task is completed, an email notification is triggered, personalized with project details and sent to project managers and collaborators.

Additional features include updating Airtable records with the last notification date, and the ability to customize this process for individual or multiple projects, with options to extend notifications to Slack, Discord, SMS, or other platforms. This automation is particularly useful for marketing agencies, content teams, and development teams aiming to streamline project updates and improve communication efficiency.