Библиотека / Синхронизация данных и ETL
Синхронизация данных и ETL
Синхронизация событий кампаний Lemlist с CRM Breakcold и запись в Google Sheets
Получает вебхуки Lemlist с email- и LinkedIn-событиями, добавляет каждое в таймлайн лида в Breakcold и записывает все события в Google Sheet, отмечая неудачные синхронизации.
Что делает
## 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
Шаги
- 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
Похожие автоматизации
Генерация и обогащение лидовДобавление лидов в Lemlist с Dropcontact и HubSpotШагов: 30Генерация и обогащение лидовОбработка ответов Lemlist с OpenAI, HubSpot и SlackШагов: 25Генерация и обогащение лидовПревращение лидов Sales Navigator в lemlist с Evaboot, OpenAI и SlackШагов: 15Генерация и обогащение лидовОбогащение контактов Google Sheets с Dropcontact и LemlistШагов: 4