Automated commission calculation workflow for finance teams

• Automate monthly commission calculations for sales teams
• Fetch closed-won deals from a CRM to calculate commissions
• Update Google Sheets with commission data for finance reporting
• Send automated emails to sales representatives with commission details

Triggers on the 2nd of each month at 05:00 UTC using a cron job Fetches closed-won deals from the CRM for the previous month Calculates commissions based on defined tiers for each sales representative Writes the calculated commissions to a Google Sheet for record-keeping Sends personalized emails to each sales representative with their commission details

1. 1
   Import the workflow template into n8n
2. 2
   Configure the CRM API credentials for fetching deals
3. 3
   Set up Google Sheets credentials for writing commission data
4. 4
   Configure SMTP settings for sending emails to sales representatives
5. 5
   Test the workflow to ensure all connections and calculations are functioning correctly