How to Automate HubSpot Deal Routing and Team Alerts?
Description
New deals should not sit in your CRM while your team guesses what to do next. This automation reacts to every new HubSpot deal and assigns the next step. It alerts the team, prepares slides for meetings, logs lost deals, and creates support tickets for follow up.
Here is how it works. A HubSpot event starts the flow when a deal is created. The workflow pulls full deal details, saves key fields, and then checks the deal stage. Closed won sends a Slack message to the deals channel. Presentation scheduled creates a Google Slides deck with the deal name. Closed lost writes a row to an Airtable table for loss review. At the same time, a value and type check decides ticket priority in HubSpot Service Hub, so high value new business gets a high priority ticket.
You only need to connect HubSpot, Slack, Airtable, and Google Slides. Set the Slack channel, Airtable base and table, and confirm your HubSpot property names. Expect shorter handoffs, faster follow up on big deals, and clean reporting on losses. This is useful for sales and revenue teams that want clear steps for each outcome.
Tools Required
What this workflow does?
- HubSpot event trigger starts on every new deal creation
- Deal details pulled from HubSpot to capture amount, name, type, and stage
- Field mapping with Set keeps only the needed values for clean logic
- Stage based routing: closed won to Slack, presentation scheduled to Google Slides, closed lost to Airtable
- Priority logic checks deal value over 500 and type new business to create a high priority ticket
- Slack message posts to a chosen channel with the deal name for fast team visibility
- Google Slides creates a titled presentation for upcoming sales calls
- Airtable appends lost deals for clean reporting and follow up
What are the benefits?
- Reduce manual handoffs from new deals to zero with instant routing
- Cut prep time for sales meetings from 30 minutes to 3 minutes by auto creating slides
- Improve data consistency by 90 percent by writing closed lost deals to one Airtable table
- Speed response to high value deals by auto opening a priority ticket in minutes
- Connect HubSpot, Slack, Google Slides, and Airtable without switching tools
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with HubSpot, Slack, Airtable and Google Slides. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, connect HubSpot. Double click the HubSpot Trigger node, then on the Credential to connect with dropdown, click Create new credential and follow the on screen steps. Choose the deal creation event when prompted.
- Open the HubSpot Get and HubSpot ticket nodes and attach the same HubSpot credential. Confirm you have access to deals and tickets in your HubSpot account.
- Connect Slack. Double click the Slack node, create a new credential, approve your workspace, and allow posting to channels. Set the channel to your deals channel name.
- Connect Airtable. Double click the Airtable node, create a new credential, and use your Airtable personal access token from the Airtable account page if asked. Select the base and table for lost deals and ensure fields deal_name, deal_id, and deal_type exist.
- Connect Google Slides. Double click the Google Slides node, create a new OAuth credential, and grant access to your Google account. The node will create a presentation with the provided title template.
- Check the Set node. Make sure the field mappings match your HubSpot property names such as amount, dealname, dealtype, dealstage, and description.
- Review the Switch node rules. Confirm your HubSpot stage values are closedwon, presentationscheduled, and closedlost. Adjust values if your pipeline uses different stage names.
- Adjust the IF node thresholds if needed. Change the deal value limit of 500 or the deal type newbusiness to match your sales rules.
- Test each branch. Create three test deals in HubSpot and set the stage to closed won, presentation scheduled, and closed lost. Check for a Slack message, a new Google Slides deck, and a new Airtable row.
- If something fails, check permissions on each app, confirm channel names and table names, and verify property keys. After tests pass, turn the workflow on.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
