Turn ClickHouse re-engagement candidates into HubSpot contacts
Spot leads who may need a fresh conversation, then get them into HubSpot without rebuilding the list by hand.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create batch of contacts
Creates up to 100 new contact records in hubspot crm, optionally associating them with existing crm objects; ensure associated object ids are valid.
Why this helps
Potentially valuable leads sit in analytics while someone still has to identify eligible records and add them to HubSpot.
- Reduce manual list building between analytics and CRM.
- Apply eligibility and consent rules before creating contacts.
- Give the team a focused set of leads to review.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and HubSpot once in Notis.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, ask Notis to query ClickHouse for eligible re-engagement candidates and create HubSpot contacts, respecting your consent rules and avoiding existing contacts.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real example and confirm the query returns the needed contact details.
Questions about this workflow
What should the ClickHouse query return?
It should provide the contact identifiers and properties needed to create a HubSpot contact, plus the signals and eligibility criteria your team trusts.
Will this send a marketing email?
No. This workflow creates contact records only. It does not send email.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Hubspot. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Hubspot actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add asset association
Associates an existing asset ('form', 'object list', or 'external web url') with a specified hubspot marketing campaign.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add token to event template
Adds a new custom data token to an existing event template for a specified hubspot application, optionally populating a crm object property if objectpropertyname is provided.
Archive email
Archives the hubspot email specified by `emailid` by moving it to the recycling bin, making it inaccessible unless restored.
Archive a batch of emails by ID
Archives multiple hubspot crm emails by id; ids must exist as archiving is irreversible.
Archive a batch of quotes by id
Archives a batch of existing, non-archived quotes by their ids; this action is irreversible and useful for managing outdated or irrelevant quotes.
Archive batch of companies by id
Archives a batch of companies by their unique ids; targeted companies must exist, not be previously archived, and this api operation is irreversible.
Archive batch of contacts by id
Archives a batch of existing contacts by their hubspot crm ids, rendering them inactive; this action is irreversible via the api and requires manual restoration or a separate unarchive endpoint.
Archive batch of deals by id
Archives a batch of existing deals by their unique hubspot ids, removing them from active views and reports (soft delete); archived deals may be restorable.
Connect any two apps with Notis in the middle.
ClickHouse and Hubspot, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Hubspot.