Get to know the features of lembot, how-to, tips, help and much more.
Export your campaign stats
You can use this Google Sheets formula COUNTA(Z3:Z)/COUNTA($A3:$A) to compute your campaign stats, then Lembot will keep this data up-to-date by automatically the export.
Duplicate headers found
Lembot found a duplicate in your campaign custom variables. Review your custom variables in your Lemlist dashboard, found the duplicate and remove it.
Google API error - Quota exceeded for quota metric 'Read/Write requests' and limit 'Read/Write requests per minute per user' of service 'sheets.googleapis.com'
The Google API limits the number of read and write operations per minute per user. Simply review the schedule of your bots and megabots and space them out at bit.
Google API error - This action would increase the number of cells in the workbook above the limit of 10000000 cells
This is a Google API limitation for spreadsheets, they are limited to 10 million cells. Consider using 2 spreadsheets instead of 1, or reducing the number of campaigns in your megabots
Export your lemlist leads
Discover how to export your lemlist campaign leads: email, firstName, lastName... and custom variables into your Google Sheets spreadsheet.
What differences between lemlist reports and activities
Let's clarify the difference between lemlist campaign report and activities
Export your lemlist campaign activities
Discover how to export your lemlist campaign activities: event types like sent, opened, clicked, interested, with the exact date and time of the interaction, the lead, sender, clicked URL, everything.
How to connect Lemlist to Google Sheets
Discover lembot, the best Lemlist to Google Sheets integration. A no code tool made by lemlisters for lemlisters.
Bulk export your lemlist reports
Discover how to export several campaign reports into one sheet. All your reports, one below the other with automatic and smart columns matching.
Remove the CSV header
Discover how to remove the header of the CSV. As a result you get the data in your GSheet without the first line. Make disappear all column names.
Add the campaign name in your export
Discover how to augment your lemlist export by adding the campaign name. As a result, the campaignName appears in front of every leads. Super helpful!
Schedule automatic export
Discover how to schedule automatic exports of your lemlist data at the frequency of your choice: daily, on weekdays, weekly or monthly.
Keep your lemlist export minimalist and consistent
Discover how to export only the data you care about. Lembot allows you to re-shape the lemlist export so your sheet stays minimalist and consistent.
Setup your Google spreadsheet for lembot
Discover how to allow lembot to write the lemlist data into your spreadsheet. It's super easy, 100% secure and keeps your spreadsheet private.
Export your lemlist reports
Discover how to export your lemlist campaign results, into your Google Sheets spreadsheet.
Discover the lembot identity card. What is lembot, the motivations behind it, why we decide to build lembot and the long term vision.