Documentation · Workflows
How to Sync Clay Rows into Salesforce with Claude Code (Deepline)
Use Deepline as a receiver for your Clay HTTP API column, then tell Claude to upsert each row into Salesforce Leads using the Clay row_id as External ID. Deepline handles OAuth refresh and rate-limit retries.
What you need
- • Clay (via webhook) account (Any plan — Deepline works on whatever tier you have)
- • Salesforce account (Any plan with API access — see provider docs)
- • Claude Code installed locally
- • ~2 minutes
Step-by-step
- 1
Install Deepline
One command installs the Deepline CLI and registers a workspace. Takes about 30 seconds. You only do this once per machine.
curl -s "https://code.deepline.com/api/v2/cli/install" | bash deepline auth register - 2
Connect Clay (via webhook) in the Deepline dashboard
In the Deepline dashboard, click Integrations → Clay → copy the generic webhook URL. Paste it into Clay's HTTP API action (or any other tool that POSTs JSON). Deepline treats each POST as a row and routes it to your destination of choice.
- 3
Connect Salesforce in the Deepline dashboard
In the Deepline dashboard, click Integrations → Salesforce → Authorize. Salesforce opens its OAuth consent screen — pick sandbox or production, approve scopes. Deepline manages the refresh-token flow and JWT rotation every 55 minutes.
- 4
Chat with Claude
Open Claude Code and describe the workflow in plain English. Deepline handles the tool calls, waterfall routing, rate limits, auth refresh, and dedup. An example prompt for this pair:
> When a row arrives from my Clay webhook, upsert it into Salesforce as a Lead. Match on the Clay row_id field (External_Id__c). Populate email, first name, last name, company, title, and LeadSource = 'Clay'. Skip any row without a verified email. - 5
Deploy as a workflow
Once Claude's one-off run looks right, type "Deploy this as a workflow" and tell it the schedule. Deepline wraps the exact prompt + tool chain as a recurring workflow with run history, billing, and alerting in the dashboard.
> Deploy this as a workflow that runs every weekday morning at 8am.
Cost math
For 1,000 leads: $1.00
~0.1 credits per Salesforce upsert. No Clay credits consumed on this leg — Clay only charges for its own enrichment columns. Deepline's credit pricing is pay-as-you-go — see code.deepline.com/docs/pricing for current rates.
Why do it in Claude Code
Waterfall routing by default
Deepline tries the cheapest provider first and only falls back if it misses. For Clay (via webhook) workflows, this means email enrichment stops at the first valid hit — you don't pay for the second and third provider unless you need to.
Deploy the exact prompt as a schedule
Once the one-off run looks right, "Deploy this as a workflow" wraps the same prompt + tool chain as a cron-scheduled workflow. Run history, per-run billing, and retry logic all live in the dashboard. No DevOps.
One place for every provider credential
Clay (via webhook) keys, Salesforce OAuth, waterfall fallbacks (Hunter, Dropcontact, Findymail, Prospeo) — all live in the Deepline dashboard. Rotate once; every workflow picks up the new credential automatically.
What people are saying
“Oleg Tomenko's Clay + Instantly 'wrong person' workflow hits a 7% reply rate and 30% positive-reply rate on autopilot.”
“A counter-balance worth knowing: new Clay users routinely burn through their entire credit allocation in the first 48 hours. Waterfall pricing changes the economics.”
Citations sourced from community posts, vendor case studies, and engineering blogs. See src/data/workflow-social-proof.md in the repo for the full sentiment bank.
Troubleshooting
Clay (via webhook) integration shows red in the Deepline dashboard
Cause: Clay (via webhook) credentials are either expired, revoked at the provider side, or the account tier doesn't expose API access.
Fix: Click the integration row in the dashboard → Test Connection. If it fails, re-paste the API key (or re-run OAuth for OAuth-based providers). Confirm the provider account tier includes API access — most providers gate this to paid tiers.
Workflow run succeeds but 0 rows landed in the destination
Cause: The filter returned 0 matches, OR rows failed a downstream gate (email not verified, already in destination, deliverability check failed).
Fix: Open the run in the Deepline dashboard → expand the step-by-step trace. Every row's path is logged: matched/unmatched at each stage. Most frequent culprit is the email-verification gate. Loosen the filter or remove the gate in the prompt if that's the cause.
Scheduled workflow stopped firing
Cause: Either hit a provider rate-limit, ran out of Deepline credits, or the destination API returned 500s Deepline classified as permanent.
Fix: Dashboard → Workflows → Recent Runs. Failed runs show the exact error and a "Replay" button. Credits are visible top-right. Rate-limit issues auto-resume once the window resets; permanent errors need intervention.
FAQ
Do I need an Anthropic API key for this?
No. You need Claude Code (the CLI/IDE). Deepline provides the tool-execution layer and credit system. Your Claude Code subscription or Anthropic API key handles the LLM calls — Deepline handles the GTM actions underneath.
How does Deepline handle dedup across runs?
Built-in. For Salesforce as a destination, Deepline uses the provider-native idempotency key (email for HubSpot/Attio, External_Id for Salesforce, campaign-level dedup for Instantly/Smartlead/Lemlist). Reruns update existing records instead of creating duplicates.
Can I still use my own API keys?
Yes. Paste them in the Deepline dashboard under Integrations. Deepline uses your keys for the actual provider calls — you keep your provider contracts, billing, and rate limit allocation. Deepline's credit billing only covers the orchestration + waterfall layer.
What if my filter only matches 3 rows but the workflow says 1000?
Deepline runs exactly what you describe. The 1000 in cost-math is the reference cost per 1K rows — a 3-row run costs 3/1000 of that total. You never pay for rows that don't exist.
Can I combine this with a waterfall?
Yes. Mention it in the prompt — e.g. "If Clay (via webhook) doesn't return an email, fall back to Hunter → Dropcontact → Findymail." Deepline assembles the waterfall automatically and charges you only for the provider that successfully finds each row.
Related workflows
Clay (via webhook) → HubSpot
Point Clay's HTTP API column at the Deepline webhook, tell Claude how to shape the HubSpot Contact, and Deepline handles the batched upsert. Works as a webhook receiver for any tool that POSTs JSON.
Apollo → Salesforce
Connect Apollo and Salesforce in Deepline, define your filter in the chat, and Claude runs the search + enrich + upsert. Deepline uses Apollo's person_id as External ID so reruns update existing Leads, never duplicate.
Want this workflow pre-configured?
Run it on Deepline or fork the full skill pack on GitHub. Either way, the code is yours to read and change.