Data Sync & ETL
Sync Lemlist campaign events to Breakcold CRM and log them in Google Sheets
Receives Lemlist email and LinkedIn webhook events, adds each to the lead's Breakcold timeline, and logs every event to a Google Sheet, flagging failed syncs.
What it does
## Sync Lemlist email & LinkedIn activity to Breakcold CRM and log every event to Google Sheets Outbound agencies and sales teams running campaigns in Lemlist can use this workflow to push every email and LinkedIn touchpoint (sends, opens, clicks, replies, bounces, invites accepted and more) to the matching lead's timeline in Breakcold in real time. Every event is also logged to a Google Sheet, giving you a full audit trail of campaign engagement and flagging events that could not be synced, so gaps get fixed instead of lost. ### How it works 1. Receive Lemlist events: a webhook catches each Lemlist activity event as it happens. 2. Normalize the payload: extracts event type, timestamp, lead email, campaign, sequence step and the custom variables breakcold_lead_id and contact_id, handling varying field names and timestamp formats. 3. Filter & secure: drops non-lead events and (optionally) verifies a shared webhook secret. 4. Route by event type: 12 email and LinkedIn events are recognized. Anything else is logged as unrecognized. 5. Post to Breakcold: if the lead has a Breakcold ID, the event is added as a custom activity on their timeline (e.g. "emailsReplied (Lemlist)") with campaign, step, email and the original event time. 6. Log to Google Sheets: every event becomes a row with timestamp, contact, campaign, client, channel, event type, step, a matched flag and an error reason (no_breakcold_id, unrecognized_event_type or the Breakcold error code). Breakcold failures never stop the workflow. ### Requirements - Lemlist account with API/webhook access - Breakcold account and API key - Google account with Google Sheets ### Setup steps (15 to 20 min) 1. Breakcold credential: in *Breakcold: Post Custom Activity*, create a Header Auth credential. Name: Authorization, Value: Bearer YOUR_BREAKCOLD_API_KEY (the Bearer prefix is required, otherwise Breakcold rejects the call). 2. Google Sheets: create a spreadsheet with a tab named Events and these headers in row 1: timestamp, contact_id, campaign_id, client, channel, event_type, sequence_step, matched, error. In *Append to Google Sheets (Events)*, connect your Google account and pick the spreadsheet. 3. Lemlist custom variables: give each lead a breakcold_lead_id variable (the Breakcold record ID) and optionally contact_id (your own internal ID, e.g. from Clay or your CRM). 4. Config: open *Normalize Event* and set
The steps
- Lemlist Webhook
- Normalize Event
- Is Lead Event?
- Secret Check
- Event Type Router
- Has Breakcold ID?
- Breakcold: Post Custom Activity
- Mark Matched – Success
- Append to Google Sheets (Events)
- Mark Unmatched – Breakcold Error
- Mark Unmatched – No Breakcold ID
- Mark Unrecognized Event
Similar automations
Lead Generation & EnrichmentAdd Leads to Lemlist with Dropcontact and HubSpot30 stepsLead Generation & EnrichmentTurn Sales Navigator leads into lemlist with Evaboot, OpenAI and Slack15 stepsLead Generation & EnrichmentHandle Lemlist Replies with OpenAI, HubSpot and Slack25 stepsAlerts & NotificationsPost Lemlist Campaign Events to Mattermost3 steps