Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

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

  1. Lemlist Webhook
  2. Normalize Event
  3. Is Lead Event?
  4. Secret Check
  5. Event Type Router
  6. Has Breakcold ID?
  7. Breakcold: Post Custom Activity
  8. Mark Matched – Success
  9. Append to Google Sheets (Events)
  10. Mark Unmatched – Breakcold Error
  11. Mark Unmatched – No Breakcold ID
  12. Mark Unrecognized Event

Similar automations