When a new contact is added in HubSpot, insert a row into your remote SQL database to sync CRM data with your data warehouse
HubSpot contact data sent to a FlowMattic webhook is inserted as a new row in your remote MySQL database, so new CRM contacts also land in the tables you report from.
Webhook
Remote SQL2 steps Setup ~5 min Used on 878 sites Free to import
What this workflow does
HubSpot holds your contacts, but reports, dashboards and other systems often read from your own database. Exporting contacts on a schedule leaves the tables out of date. This workflow adds a row to your remote database for each new contact that HubSpot sends to it.
The trigger is a FlowMattic Webhook, not a HubSpot connection. FlowMattic gives you a webhook URL, and you set up HubSpot to send new-contact data to that URL. How you do that depends on your HubSpot account, so check what your setup allows before you import. Whatever HubSpot sends in that request becomes data you can map.
The second step is Insert Row from Remote SQL, which connects to a remote MySQL database. You choose the table and map the webhook values, such as email, name and contact ID, into its columns. Each request that reaches the webhook adds one row.
Contact table for BI reports
Your reporting tool reads a MySQL table. New HubSpot contacts are added there as they arrive, next to order and usage data.
Feeding an in-house app
A customer portal built on MySQL needs to know about new leads. Each contact HubSpot sends to the webhook becomes a row the app can read.
Keeping a backup of new contacts
A row per contact in your own database gives you a copy of key fields outside HubSpot.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
Webhook Capture Webhook ResponseGives you a webhook URL and starts the workflow each time a request reaches it. Point your HubSpot setup at this URL so new contact data is sent here.
- Remote SQL Insert Row
Inserts a new row into a table in your remote MySQL database. Connect the database, pick the table, and map the webhook values into its columns, then check a test row.
What you need
- FlowMatticCore
- Remote SQL AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Add a Filter after the webhook that continues only when an email value is present, so incomplete requests do not create rows.
- Add a column for the HubSpot contact ID and map it in, so you can match rows to HubSpot records later.
- Send one test contact from HubSpot after you set up the webhook, so FlowMattic captures the request's fields before you map them.
Questions about this workflow
Does this template connect to HubSpot directly?
No. It listens on a FlowMattic webhook. HubSpot has to be set up to send new contacts to that URL; the template does not do that part for you.
What if the same HubSpot contact is sent to the webhook twice?
Insert Row adds a new row each time, so you get two rows. Add a unique key on the email or ID column in your table if you want duplicates refused.
Which databases does the Remote SQL step support?
Remote SQL connects to remote MySQL databases. Your database must accept connections from the server where FlowMattic runs.
More Data Sync workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted