CRM for developers and CTOs
Follow Up Boss to MySQL, kept in sync for you
Every lead in a MySQL table you own, with a typed view and write-back.
Free tier on every product. No card.
| id | name | stage | _synced_at |
|---|---|---|---|
| 4817 | Tom Becker | Showing | 10:52 |
| 4821 | Maria Gonzalez | Lead | 11:03 |
| id | lead_score | persona | pre_approved |
|---|---|---|---|
| 4817 | 62 | Upsizer | false |
| 4821 | 87 | First-time buyer | true |
lead_scoreLead scorepersonaPersonapre_approvedPre-approved
Maria Gonzalez
Follow Up Boss · lead 4821
Custom fields
- Lead score
- 87
- Pre-approved
- Yes
- Persona
- First-time buyer
Updated from your database
If your stack runs on MySQL, syncing Follow Up Boss to MySQL should not mean a new service to maintain. SyncYak writes every Follow Up Boss lead into your MySQL database as to_syncyak_<name>_people, with the record as JSON and a _flat view with a column per field, and keeps it current on your plan’s schedule.
Set tls=true (or skip-verify or preferred) in the connection string and give SyncYak a user that can create tables and views.
How it works
Sync Follow Up Boss to MySQL in three steps
Add your database
Paste a Postgres or MySQL connection string. SyncYak checks it can create tables and views, insert, update and select, and reports each step.
Connect the CRM
Paste its API key or sign in at the vendor, name the connection, and choose the entities to sync. People sync by default.
Query, then write back
Leads land in to_syncyak_<name>_people with a typed _flat view. Map columns of a table or sheet to CRM fields to write values back.
Follow Up Boss MySQL sync, the details
The connection check runs every permission it needs on a throwaway table and reports each step. Table names come from the connection name, lower-cased, up to 40 characters, with an optional prefix in place of to_syncyak_.
- JSON record plus a typed view
- Deletions marked, never removed
- Shared tables across connections, or one per connection
Export Follow Up Boss to MySQL and write back
Write scores or tags into from_syncyak_<name>_people and map each column to a Follow Up Boss field; changed rows are written into the leads at your plan’s pace.
Use cases
MySQL use cases
Your own app
Read leads in the app you already run on MySQL.
Reporting
Reports across agents and sources.
Enrichment
Scores from your code back into FUB.
What you get with CRM sync
CRM sync copies every lead from Follow Up Boss, Lofty, BoldTrail, CINC, HighLevel, Cloze, Brivity and KW Command into a Google Sheet, on every plan with no database needed, or into a Postgres or MySQL database you own. In a sheet each object gets a tab and each lead a row, upserted by its CRM id, with deletions marked in _deleted and your own columns left alone; in a database you get a to_syncyak_<name>_people table and a _flat view with one typed column per field. Notes, tasks, deals and other entities can sync too where the CRM offers them.
Field mapping writes values back: map columns of a Google Sheet tab, or of a from_syncyak_ table, to CRM fields, and SyncYak writes changed rows into the leads. Write-back works with Follow Up Boss, Lofty, HighLevel and Cloze; BoldTrail, CINC, Brivity and KW Command sync one way. Free syncs 100 leads every 60 minutes from 1 CRM; Hobby, $29 a month, syncs 1,000 every 30 minutes from 2 CRMs and adds field mapping and real-time CRM webhooks.
- Every lead syncs on every plan; the plan sets the batch size and how often
- Signed outbound webhooks: lead.created, lead.updated, lead.deleted and sync.completed
- Invite links let whoever administers a CRM connect it without a SyncYak login
- A request log of every pull, webhook and push, kept for your plan’s window
Frequently asked questions
Something else? Write to contact@syncyak.com and a person answers.
Which MySQL versions work?
Any current MySQL reachable from the internet with JSON and view support.
Is the connection encrypted?
Choose tls=true, skip-verify or preferred in the connection string.
Can I prefix the tables?
Yes. Set a table prefix to replace to_syncyak_.
Is there a free plan for CRM?
Yes. CRM has a free tier with no card and no end date: 1 crm, 100 leads every hour, postgres or mysql destination. Paid tiers start at $29 a month, and you can move up or down at any time.
Can I use the other SyncYak products on the same account?
Yes. Email parsing, the mailbox API, CRM sync, error tracking and tunnels share one login, one team, one API key system and one bill. Each product has its own tier, so you only pay more for the one that grows.
Related
Related solutions
Start with CRM free
1 CRM, 100 leads every hour, Postgres or MySQL destination, free every month. Set up in minutes, and add the other SyncYak products on the same account when you need them.
Free tier on every product. No card.
Follow Up Boss, MySQL are trademarks of their respective owners. SyncYak is not affiliated with or endorsed by them.