Setting up a no-code CRM pipeline: HubSpot + Notion + Gmail guide

Managing customer relationships efficiently is vital for any business, regardless of size. As a business owner, freelancer, or operations manager, you know that keeping track of leads, projects, and communications can quickly become overwhelming, especially when done manually across multiple tools.

This tutorial will show you how to build a simple, effective, and completely no-code CRM pipeline. We'll connect HubSpot for lead tracking, Notion for project management, and Gmail for automated communication. This setup will save you time, reduce errors, and ensure no lead falls through the cracks, allowing you to focus on growing your business rather than administrative tasks.

Why this matters for your business

A well-integrated CRM pipeline offers significant advantages. Firstly, it centralizes information. Instead of copying and pasting data between your CRM, project tracker, and email, data flows automatically. This means less manual effort and fewer mistakes. Secondly, it ensures timely follow-ups. When a new lead comes in or a deal progresses, automated actions can trigger emails or create tasks, ensuring you or your team respond promptly.

For operations managers, this means streamlined workflows and better team coordination. For business owners and freelancers, it translates to more organized client management and a professional image. Ultimately, this integration boosts productivity, improves customer satisfaction, and helps you make data-driven decisions without needing technical expertise.

Step-by-step guide: Build your automated pipeline

To set this up, you will use an integration platform that connects your different apps. For this guide, we'll outline the steps you'd take on a platform like Make.com (which we recommend in our CTA).

1. Preparation: Get your tools ready

• HubSpot: Ensure you have a HubSpot account (the free CRM tier is sufficient). Familiarize yourself with creating deals or contacts.
• Notion: Set up a Notion workspace. Create a new database, perhaps named "Client Projects" or "Lead Tasks." Define properties like "Client Name" (text), "Status" (select: New, In Progress, Completed), "HubSpot Deal ID" (text), "Email" (email), and "Deal Amount" (number).
• Gmail: Have your Gmail account ready for sending automated emails.

2. Choose your automation platform

You'll need an online integration tool. These platforms act as a bridge between your apps. They allow you to define "scenarios" or "workflows" where one event in an app triggers an action in another.

3. Create a new automation scenario

Log in to your chosen automation platform and start a new scenario or workflow. This is where you'll build your pipeline step-by-step.

4. Set the Trigger: New Deal in HubSpot

1. Add a HubSpot module: Search for HubSpot and select it.
2. Choose the "Watch New Deals" or "Watch New Contacts" trigger: This tells the platform to monitor HubSpot for new deal creations or contact additions. For this pipeline, we'll focus on "Watch New Deals."
3. Connect your HubSpot account: Authorize the integration platform to access your HubSpot data.
4. Select "Deal Stage": You might want this automation to trigger only when a deal reaches a specific stage, like "New Lead" or "Qualified to Buy."

5. Set the First Action: Create a Database Item in Notion

Once a new deal is detected in HubSpot, the next step is to automatically create a corresponding item in your Notion database.

1. Add a Notion module: After the HubSpot module, add a Notion module to your scenario.
2. Choose the "Create a Database Item" action: This action will create a new entry in your specified Notion database.
3. Connect your Notion account: Authorize the integration platform to access your Notion workspace. You might need to grant access to specific pages or databases.
4. Select your database: Choose the "Client Projects" or "Lead Tasks" database you created in Notion.
5. Map the data: This is crucial. You need to tell the platform which information from HubSpot goes into which property in Notion.
   • For Notion's "Client Name" property, pull data from HubSpot's "Deal Name" or "Contact Name."
   • For Notion's "HubSpot Deal ID" property, use HubSpot's "Deal ID."
   • For Notion's "Email" property, use HubSpot's "Contact Email" (associated with the deal).
   • For Notion's "Deal Amount" property, use HubSpot's "Amount."
   • Set "Status" in Notion to "New Lead" or "To Do" by default.

6. Set the Second Action (Optional but Recommended): Send an Email via Gmail

To ensure prompt communication, you can automatically send a welcome or confirmation email to the client or an internal notification.

1. Add a Gmail module: After the Notion module, add a Gmail module.
2. Choose the "Send an Email" action: This will send an email from your connected Gmail account.
3. Connect your Gmail account: Authorize the integration platform to access your Gmail.
4. Configure the email:
   • To: Use the HubSpot "Contact Email" data.
   • Subject: Create a dynamic subject line, e.g., "Thanks for connecting, {{HubSpot Contact Name}}!"
   • Content: Write a template message. You can include dynamic data like the deal name: "Hi {{HubSpot Contact Name}}, thank you for your interest in {{HubSpot Deal Name}}. We've received your inquiry and will be in touch shortly. You can also view your project status in our system."

7. Test and Activate Your Scenario

1. Run a test: Most automation platforms allow you to run the scenario once manually or process existing data. Create a new deal in HubSpot.
2. Verify the outcome: Check your Notion database for the new item and your Gmail "Sent" folder for the automated email.
3. Activate: Once you've confirmed everything works, turn on your scenario to run automatically.

Pro tips for optimizing your pipeline

• Keep Notion properties simple: Start with essential properties and add more as needed. Too many properties can make your database cumbersome.
• Use filters: In your automation platform, you can add filters to your HubSpot trigger to only activate for specific deal types, values, or stages.
• Set up follow-up automations: Extend this pipeline by adding more steps. For example, if a deal's status changes in HubSpot, update the status in Notion automatically.
• Error handling: Understand how your automation platform notifies you of errors so you can quickly fix any issues.

Frequently Asked Questions (FAQ)

Q: Do I need coding skills to set this up?

A: Absolutely not. This entire guide is designed for a no-code approach. All connections and data mapping are done using visual interfaces provided by the automation platform.

Q: What if I use a different CRM or project management tool?

A: The principles remain the same. Most popular CRMs (like Salesforce, Zoho CRM) and project management tools (like Asana, Trello) are supported by integration platforms. You would simply swap out the HubSpot or Notion modules for your preferred tools.

Q: How much does it cost to run an automation like this?

A: Many integration platforms, including Make.com, offer free tiers that are often sufficient for basic needs (like handling up to 1,000 operations per month). As your usage grows, paid plans offer more operations and advanced features.

Written by Vangari Sai Sampath, Automation Specialist · Integration Directory · Hyderabad, India