Google Sheets + lemlist
Add new lemlist email activity to Google Sheets as rows
Want to track how many recipients are opening emails from your campaign? This Zap can help you do just that. Once set up, this integration will automatically add lead information to a new row on a Google Sheets spreadsheet whenever an email is opened from a lemlist campaign.
Want to track how many recipients are opening emails from your campaign? This Zap can help you do just that. Once set up, this integration will automatically add lead information to a new row on a Google Sheets spreadsheet whenever an email is opened from a lemlist campaign.
- When this happens...
New ActivityTriggers when an activity has ocurred. It can be an email has been sent, replied to, bounced, or unsubscribed from or v3 new activity like a LinkedIn profile have been visited or a phone call just ended.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Campaign
Event Type
Only First
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Email
Linkedin URL
First Name
Last Name
Company Domain
Company Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Linkedin Url
First Name
Last Name
Company Domain
Company Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
CampaignRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Campaign Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
CampaignRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email Address
CampaignRequired
First Name
Last Name
Company Name
Screenshot URL
Image URL
Icebreaker
Linkedin URL
Phone
Custom Variables
Deduplicate
Find verified email
LinkedIn enrichment
Verify existing email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
One of your campaign
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Unsubscribed Recipient
Triggers when a recipient be unsubscribes from an email subscription list.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLinkedin Url
First Name
Last Name
Company Domain
Company Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email Address
CampaignRequired
First Name
Last Name
Company Name
Screenshot URL
Image URL
Icebreaker
Linkedin URL
Phone
Custom Variables
Deduplicate
Find verified email
LinkedIn enrichment
Verify existing email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
CampaignRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
CampaignRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Campaign Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
CampaignRequired
First Name
Last Name
Company Name
Screenshot URL
Image URL
Icebreaker
Linkedin URL
Phone
Custom Variables
Deduplicate
Find verified email
LinkedIn enrichment
Verify existing email
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
Related categories
Related Zap Templates
- Add new lemlist activities to Google Sheets as multiple spreadsheet rows
- Add new Google Sheets spreadsheet rows to lemlist as campaign leads
- Add lemlist buddy-to-be campaigns for new Google Sheet rows
- Add buddy-to-be to campaigns in lemlist for new or updated spreadsheet rows in Google Sheets
- Add Google Sheets leads to lemlist campaigns
- Update lemlist leads from campaigns when new Google Sheets rows are added
- Create spreadsheet rows in Google Sheets for newly unsubscribed recipients in lemlist
- Add new Google Sheets rows to lemlist campaign as leads
- Add leads to lemlist campaign from new or updated Google Sheets rows
- Add new Google Sheets rows to lemlist as campaign leads
- Update lemlist leads from campaigns with new or updated Google Sheets rows
- Mark leads as interested in lemlist when new or updated spreadsheet rows occur in Google Sheets
- Update Google Sheets rows with new lemlist activities
- Pause lemlist leads from all campaigns when new or updated spreadsheet rows occur in Google Sheets team drive
- Update Google Sheets rows with new lemlist activities for streamlined tracking
- Capture new lemlist activities and create spreadsheets in Google Sheets
- "remove leads from unsubscribe in lemlist when new or updated rows occur in Google Sheets"
- Add new leads to lemlist campaign when new rows are added in Google Sheets
- Add new or updated Google Sheets rows from team drive to lemlist campaigns as leads
- Add recipients to lemlist unsubscribe list for new or updated rows in Google Sheets
- Mark leads as interested in lemlist when new or updated rows happen in Google Sheets
- Track new lemlist activities by creating top rows in Google Sheets
Related Zap Templates
- Add new lemlist activities to Google Sheets as multiple spreadsheet rows
- Add buddy-to-be to campaigns in lemlist for new or updated spreadsheet rows in Google Sheets
- Create spreadsheet rows in Google Sheets for newly unsubscribed recipients in lemlist
- Add new Google Sheets rows to lemlist as campaign leads
- Update Google Sheets rows with new lemlist activities
- Add new Google Sheets spreadsheet rows to lemlist as campaign leads
- Add Google Sheets leads to lemlist campaigns
- Add new Google Sheets rows to lemlist campaign as leads
- Update lemlist leads from campaigns with new or updated Google Sheets rows
- Pause lemlist leads from all campaigns when new or updated spreadsheet rows occur in Google Sheets team drive
- Add lemlist buddy-to-be campaigns for new Google Sheet rows
- Update lemlist leads from campaigns when new Google Sheets rows are added
- Add leads to lemlist campaign from new or updated Google Sheets rows
- Mark leads as interested in lemlist when new or updated spreadsheet rows occur in Google Sheets
- Update Google Sheets rows with new lemlist activities for streamlined tracking