How to Lemlist to Google Sheets

If you want to analyze the results of your campaigns more deeply, you would probably want to import them into Google Sheets.

Here is how to do it.

The easy way with lembot

Lembot automates the export of your lemlist campaign data (reports, activities, and leads) to your GSheet.

Follow the step-by-step guide to create your automation:

step 1: paste your lemlist API key. At this point lembot automatically presents your campaigns so you can select the one you want to import in Google Sheets.
step 2: paste your gsheet URL. At this point lembot automatically presents your spreadsheet's sheets so you can select where you want to import your campaign data.
optionally, select which columns to import (see how ↗️), schedule automatic export (see how ↗️), etc.
click Save and / or Run Export

That's it 🤩

Once setup you can run your automation in 1 click, or automatically if you scheduled it (daily, on weekdays, weekly, monthly).

Try lembot for free, no credit card required ↗️

example of a scheduled automation

Without lembot

Without lembot, the only way is to do it the hard way: all by hand.

Without lembot, here are the steps you need to follow to achieve the same result, all by hand, again and again every time you want to refresh your data:

open your lemlist dashboard
find and click on your campaign
click Export
wait until the export is ready 😴
download the CSV
open your Google spreadsheet
click File
hover Import, click
click the Upload tab
click Select a file from your device
find the right CSV among others on your computer, good luck when file name looks like fil_axp_CvGPWvb3AxzDbFhJQ_campaign_x.csv 🤯
choose the right options for your import
and finally, click Import data

Let's be honest, it's time-consuming and error-prone work with 0 added value.

Lembot automates all this for you so you can focus on your business.

I prefer the easy way, let's try lembot ↗️

Win 4 hours a week with lembot

And you can do a lot more with lembot:

export campaign reports
export campaign activities: email opened, sent, link clicked, etc... with dates
export campaign leads
schedule your export every days / weekdays / weeks / months, see how to
bulk export your lemlist campaigns, see how to
choose which columns to export, see how to
add the campaign name to your export, see how to
etc.

Your privacy is taken seriously at lembot.

We are GDPR compliant, our servers are in the EU and we store only the minimal amount of data to run the service.

For example, we DO NOT store anything about your leads, anything.

Read our Privacy Policy for all the details.

Build lembot with us

We regularly update lembot with new features, see our whats-new page.

All features are based on your feedback so feel free to chat or send an email if you have any suggestions.

Note that lembot is not affiliated with lemlist, we are lemlisters like you and we built lembot to make us more productive.

Ready? Try lembot for free ↗️

Cheers,

François