CRM 04 · Zoho CRM · Native

Zoho CRM. Contacts, case-sensitive.

Setup → Customization → Modules and Fields → Contacts → New Field. API names are case-sensitive. Type them as the table says. Make uses the Zoho CRM app. Zapier the same.

Nativev1.0Five TBT fieldsGap default 25 bps$99 AUD once

← All 12 CRMs · Make guide · Zapier guide

Connection type: Native. Sign in to the Zoho CRM org. Module is Contacts. Change it only if you store rates on Deals or a custom module.

Connect with scopes that can read and update Contacts and create Notes / Tasks. If the stamp module fails with AUTHENTICATION_FAILURE, delete the connection and re-add it with those ticked. Use Email_Opt_Out as the opt-out field.

Fields for this CRM

Create the ones marked YES. Map the ones you already store. Do not invent a second current-rate field.

PurposeCanonicalThis CRMRequiredCreate?
Contact IDcontact_ididYesNo
First namefirst_nameFirst_NameYesNo
Last namelast_nameLast_NameNoNo
EmailemailEmailYesNo
MobilemobileMobileRecommendedNo
Current ratetbt_current_ratetbt_current_rateYesMap or create
New-money ratetbt_new_money_ratetbt_new_money_rateYesYES - create or maintain
Loyalty gap (bps)tbt_loyalty_gap_bpstbt_loyalty_gap_bpsYesYES - create / compute
LenderlenderLenderRecommendedNo
Product nameproduct_nameLoan_ProductRecommendedNo
Existing client flagexisting_clienttbt_existing_clientYesMap
Email opt-outemail_optoutEmail_Opt_OutYesNo
Loyalty statetbt_loyalty_statetbt_loyalty_stateYesYES - create this
Last loyalty touchtbt_last_loyalty_touchtbt_last_loyalty_touchYesYES - create this
Broker ownerbroker_ownerOwner.emailRecommendedNo
Broker emailbroker_emailset in watch mapperYesSet in the watch

Full translation and notes: 05-templates/CRM-Field-Map.csv. Gap is in basis points. Example: current 6.40 and new-money 5.90 is a 50 bps gap. Default watch threshold is 25 bps.

Make — watch file to import

Import 02-make-blueprints/01d-TBT-Loyalty-Tax-Watch-Zoho.blueprint.json.

Import this file. Sign in to the Zoho CRM org. Create the five fields first. Then import the outreach blueprint and paste its webhook URL into the watch.

Everyone also imports 02-make-blueprints/02-TBT-Loyalty-Tax-Outreach.blueprint.json. Import outreach first so you have the webhook URL. Walkthrough: MAKE-Setup-Guide.html.

Make — last-step swap

On the outreach scenario, modules 7, 8 and 9 are HTTP placeholders labelled SWAP. Replace them. The middle (consent, gap gate ≥ 25 bps, OpenAI, broker Gmail) does not change.

Outreach moduleSwap for
7 · Create the broker task — SWAPZoho CRM → Create a Task. Subject {{3.broker_task_title}}, description {{3.broker_task_body}}, related to the Contact Id.
8 · Write the CRM note — SWAPZoho CRM → Create a Record (Notes) linked to the Contact Id. Body {{3.crm_note}}.
9 · Stamp loyalty touch — SWAPZoho CRM → Update a Record (Contacts). Set tbt_loyalty_state = touched and tbt_last_loyalty_touch = today. Do not skip.

Stamp body (use this CRM’s field names from the table):

{
  "tbt_loyalty_state": "touched",
  "tbt_last_loyalty_touch": "{{formatDate(now; \"YYYY-MM-DD\")}}"
}

Zapier — first module and last three

Zapier cannot import a Make blueprint. Build two Zaps by hand. Full click-path: ZAPIER-Setup-Guide.html. This page is the CRM-specific first and last steps only.

WhereWhat
Zap A · first moduleSchedule by Zapier (daily 09:00) + Zoho CRM Find / Search Records (Contacts) where tbt_loyalty_gap_bps ≥ 25, email exists, not Email Opt Out. Then Webhooks by Zapier → POST to Zap B. Map First_Name, Email, Email_Opt_Out and the five tbt_* fields from the table.
Zap B stepModule
B6 TaskZoho CRM → Create Task. Subject from broker_task_title, description from broker_task_body, related Contact = contact_id.
B7 NoteZoho CRM → Create Note on that Contact. Body from crm_note.
B8 StampZoho CRM → Update Module Entry (Contacts). tbt_loyalty_state = touched, tbt_last_loyalty_touch = today.

Zap A then POSTs the canonical keys (see the field-map Canonical column) to Zap B’s Catch Hook. Leave auto_email_client as false. Replace [YOUR BROKER EMAIL], [YOUR FIRST NAME], [YOUR BUSINESS NAME].

Fallback — Google Sheets bridge (01e)

If Zoho OAuth is blocked or the required scopes are refused, export Contacts with rates and gap into the Google Sheet and import 01e the same week.

T Test on yourself before any live send

  1. Create yourself as a settled existing-client test record with a real email you read, a current variable rate, a new-money / retention reference, and tbt_loyalty_gap_bps at or above 25. State due or queued. Last touch empty.
  2. Run the watch (Make scenario 01, or Zap A) with a limit of 1, filtered to only this record.
  3. Confirm the broker email arrives. Confirm you did not get a client email. auto_email_client stays false.
  4. Confirm the broker task, the CRM note (or sheet write-back), and the stamp: state touched, last touch = today.
  5. Run again the same day. The engine must not draft you a second time. Then set state to opt_out and run again — must not draft.

If the stamp fails, stop. Fix it before anyone else is in the set. After the loop is proven on you, you may flip auto_email_client — not before. Read 04-compliance first.