Paste your lemlist API key in Derrick's Connectors. Your campaigns load automatically.
Map your leads
Pick the target campaign, map your email column and any fields you have: name, company, job title, LinkedIn URL, icebreaker, custom variables.
Push in one click
Every row lands in your lemlist campaign, ready to sequence. The pushed and leadId columns confirm each sync.
All the data you can extract
Enrich companies and leads with 2+ data points each.
Field Name
Description
Example
✅ pushed (push-to-lemlist)
Whether the lead was pushed to the lemlist campaign
true
🆔 leadId (push-to-lemlist)
The lemlist lead id created by the push
lea_xxxxxxxxxxxx
When to reach for it
Push to lemlist use cases
Send leads from Google Sheets straight into a lemlist campaign - no CSV export. Connect your lemlist key once, pick the campaign, map your email column (lemlist's lead key) plus any fields you have (name, company, job title, LinkedIn URL, icebreaker, five custom variables), and Derrick pushes every row in one click. Each row comes back with its lemlist leadId, so you know exactly what synced.
1Engagers to outreach: import a post's likers/commenters, find their emails, push them into a campaign.
2Look-alike to outreach: find similar companies, pull their staff, enrich, push.
3Personalized at scale: write an icebreaker per row, push it with the lead, reference it in your lemlist copy.
4Enriched leads to sequence: verify emails first, push only the valid ones.
Push to lemlist isn't tied to the Google Sheets sidebar. Every Derrick enrichment - this one included - is also exposed through the REST API and the MCP server, so you can run it from your CRM, your data pipeline, an AI assistant, or any no-code tool (Zapier, Make, n8n). Same credit cost as the add-on, same data. API access is included from the Standard plan up.
"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."
Alex Clark
Director | SaaS GTM Leader
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
David Sire
Mortgage Broker at Zero Point Mortgage
"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."
Etienne Grange
CEO Form'actions
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
Zaid Bilal
RevOps Professional
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
Asif Hanzala
Lead Generation Specialist at IdeaPeel
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
Julien Walon Cohen
CEO & Co-founder @ Diffly | B2B Sales Advisor
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
Michael Kim
SDR Team Lead at CloudScale
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
AJ Alexander
Opportunity Prospector
The last mile of any prospecting workflow is getting your list out of the spreadsheet and into outreach. Most teams export a CSV and re-import it into their sequencer - lossy, manual, and stale by the time it lands. Derrick pushes leads from a Google Sheet straight into a lemlist campaign : connect your lemlist key once, pick the campaign, map your email column (lemlist's lead key) plus any fields you carry (name, company, job title, LinkedIn URL, phone, timezone), and every row is sent in one click. Each row comes back with its lemlist leadId, so you can see exactly what synced.
Where it pays off is personalisation : map an icebreaker and up to five custom variables per row, and reference them straight in your lemlist copy as {{icebreaker}} and {{variable1}}. Build the line in the sheet - from an enriched signal, a recent post, a funding round - and it travels with the lead. Free : pushing costs 0 credits. See the full plan grid on the Derrick pricing page.
Do I need to install anything to use Push to lemlist?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Push to lemlist is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.
Can I use Push to lemlist on a list of 1,000+ rows?
+
Yes - Push to lemlist runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.
Where does the data behind Push to lemlist come from?
+
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs a multi-source lookup for Push to lemlist. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Push to lemlist GDPR-compliant?
+
Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.
Can I trigger Push to lemlist automatically when I add a row?
+
Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Push to lemlist into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
From data to outreach, zero export
Whatever you built in Derrick - engagers, similar companies, enriched leads - goes one click into lemlist and into your sequences.
