Kütüphane / Veri Senkronizasyonu ve ETL
Veri Senkronizasyonu ve ETL
Lemlist kampanya olaylarını Breakcold CRM ile senkronize et ve Google Sheets'e kaydet
Lemlist e-posta ve LinkedIn webhook olaylarını alır, her birini lead'in Breakcold zaman çizelgesine ekler ve her olayı bir Google Sheet'e kaydeder, başarısız senkronizasyonları işaretler.
Ne yapar
## 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
Adımlar
- 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
Benzer otomasyonlar
Potansiyel Müşteri Yaratma ve ZenginleştirmeDropcontact ve HubSpot ile Lemlist'e Potansiyel Müşteri Ekleme30 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeLemlist yanıtlarını OpenAI, HubSpot ve Slack ile yönetme25 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeEvaboot, OpenAI ve Slack ile Sales Navigator potansiyel müşterilerini lemlist'e aktar15 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeGoogle Sheets Kişilerini Dropcontact ve Lemlist ile Zenginleştirme4 adım