Automate Commission Reports Generation from Sales Data to Google Sheets

• Automate monthly commission reporting for finance teams.
• Fetch and analyze sales data from HubSpot.
• Calculate commissions based on dynamic rates.
• Store financial data in Google Sheets for easy access.
• Notify stakeholders via email when reports are ready.

Triggers monthly at 06:00 UTC on the 1st. Fetches all closed deals from HubSpot for the previous month. Calculates commissions based on predefined rates. Writes the commission data to a specified Google Sheets document. Sends an email notification to the finance team.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure HubSpot API credentials for deal fetching.
3. 3
   Set up Google Sheets credentials for writing data.
4. 4
   Adjust commission rates as needed in the Commission Rates Table node.
5. 5
   Test the workflow to ensure all connections are functioning correctly.