Create new deal in Pipedrive, and notify team via email about missing data

Create new deals in Pipedrive when a new row is added in SQL Server, filtering out specific entries. Notify your team via Office 365 email about the new deal and any missing data for improved tracking and collaboration.