lemlist

lemlist is a sales engagement platform for running multichannel outreach campaigns across email, LinkedIn and phone. With Weld you can sync your lemlist data into your data warehouse and combine campaign activity, leads and replies with your CRM and revenue data to report on outreach performance and pipeline.

Features

Feature nameSupported
Column HashingTrueColumn level
BlockingTrueColumn level
IncrementalTrue
Custom dataFalse
HistoryTrue
ReSyncTrueTable level
TemplatesFalse

Data Schema


Setup Guide - ELT

Step 1 - Generate a lemlist API key

  1. Sign in to lemlist.
  2. Go to Settings > Integrations > API and generate a new API key for Weld.
  3. Copy the key — lemlist only shows it once.

Step 2 - Create the connection

  1. In the Weld app, click Data Sources in the sidebar, then Add Data Source.
  2. Search for lemlist, select it and choose Create new connection.
  3. Give the connection a Name.
  4. Paste your key into API Key, then click Connect.

Step 3 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

The connector exposes 11 tables, plus the related tables that come along with them:

  • Campaigns — campaign (with campaign_label, campaign_schedule, campaign_error, campaign_sender and campaign_send_user), sequence (with sequence_step, sequence_step_condition and sequence_step_workflow), schedule (with schedule_weekday)
  • Leads and engagement — lead, activity, unsubscribe
  • Contacts and companies — contact (with contact_campaign, contact_phone_status, contact_field_rejection and contact_crm_sync_error), company (with company_field_rejection and company_crm_sync_error)
  • Team and senders — team (with team_user, team_invited_user and team_beta), sender (with sender_channel and sender_channel_alias)
  • Webhooks — webhook

Step 4 - Configure sync

  1. Select how often you would like the data to sync.
  2. Optionally choose a start date for the activity table. If you leave it empty, Weld syncs the last 2 years of activity. The other tables always include all of their records.
  3. Check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.

Weld will take over from here and commence syncing data from your lemlist account.

Was this page helpful?