Google Sheets + lemlist
Add new Google Sheets spreadsheet rows to lemlist as campaign leads
Effortlessly grow your email campaigns with this Google Sheets to lemlist workflow. When you add a new row in your Google Sheets spreadsheet located in your Team Drive, a lead will be added to your selected lemlist campaign. This streamlined process makes growing your email campaigns easy, allowing you to focus on creating engaging content.
Effortlessly grow your email campaigns with this Google Sheets to lemlist workflow. When you add a new row in your Google Sheets spreadsheet located in your Team Drive, a lead will be added to your selected lemlist campaign. This streamlined process makes growing your email campaigns easy, allowing you to focus on creating engaging content.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Add Lead to CampaignAdd a Lead to a campaign.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont 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 foundCampaign
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 app
Dont 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
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 found
About Google Sheets
Related categories
Related categories
Related Zap Templates
- Add new lemlist activities to Google Sheets as multiple spreadsheet rows
- Add new lemlist email activity to Google Sheets as rows
- 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 lemlist email activity to Google Sheets as rows
- 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