Zum Inhalt springen
NEUMarktplatz und trig8n Agent: Verkaufen Sie, was Sie bauen, und erhalten Sie Pläne und Änderungen, die getestet sind, bevor Sie sie sehen. Neuigkeiten ansehen

Bibliothek / Datensynchronisierung & ETL

Datensynchronisierung & ETL

Lemlist-Kampagnenereignisse mit Breakcold CRM synchronisieren und in Google Sheets protokollieren

Empfängt Lemlist-E-Mail- und LinkedIn-Webhook-Ereignisse, fügt jedes Ereignis der Breakcold-Timeline des Leads hinzu und protokolliert alle Ereignisse in einem Google Sheet, wobei fehlgeschlagene Synchronisierungen markiert werden.

Was sie bewirkt

## 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

Die Schritte

  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

Ähnliche Automatisierungen