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 name | Supported | |
|---|---|---|
| Column Hashing | True | Column level |
| Blocking | True | Column level |
| Incremental | True | |
| Custom data | False | |
| History | True | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Setup Guide - ELT
Prerequisites
You need a lemlist account with access to Settings > Integrations, where API keys are generated. Weld only reads from lemlist — it never writes back.
Step 1 - Generate a lemlist API key
- Sign in to lemlist.
- Go to Settings > Integrations > API and generate a new API key for Weld.
- Copy the key — lemlist only shows it once.
Step 2 - Create the connection
- In the Weld app, click Data Sources in the sidebar, then Add Data Source.
- Search for lemlist, select it and choose Create new connection.
- Give the connection a Name.
- 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(withcampaign_label,campaign_schedule,campaign_error,campaign_senderandcampaign_send_user),sequence(withsequence_step,sequence_step_conditionandsequence_step_workflow),schedule(withschedule_weekday) - Leads and engagement —
lead,activity,unsubscribe - Contacts and companies —
contact(withcontact_campaign,contact_phone_status,contact_field_rejectionandcontact_crm_sync_error),company(withcompany_field_rejectionandcompany_crm_sync_error) - Team and senders —
team(withteam_user,team_invited_userandteam_beta),sender(withsender_channelandsender_channel_alias) - Webhooks —
webhook
An activity's custom lead variables and enrichment data are not synced. contact_campaign and contact_phone_status stay empty for now, because lemlist does not return that data when listing contacts.
Senders and webhooks deleted in lemlist stay in sender and webhook with _weld_deleted_at set.
Step 4 - Configure sync
- Select how often you would like the data to sync.
- Optionally choose a start date for the
activitytable. If you leave it empty, Weld syncs the last 2 years of activity. The other tables always include all of their records. - 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.