Google Sheets + LeadSimple
Update spreadsheet rows in Google Sheets when new leads are created in LeadSimple
Capture critical leads effectively with this unique workflow between LeadSimple and Google Sheets. When a new lead is created in LeadSimple, pertinent details are immediately updated in a row on your chosen Google Sheets document. Streamline your lead engagement process, ensuring no lead data slips through the cracks. Enhance your data organization and improve your follow-up efficiency seamlessly with this workflow.
Capture critical leads effectively with this unique workflow between LeadSimple and Google Sheets. When a new lead is created in LeadSimple, pertinent details are immediately updated in a row on your chosen Google Sheets document. Streamline your lead engagement process, ensuring no lead data slips through the cracks. Enhance your data organization and improve your follow-up efficiency seamlessly with this workflow.
- When this happens...
Lead CreatedTriggers when a new lead is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update Spreadsheet Row(s)Update one or more rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Call Completed
Triggers when a new call is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Changes Stage
Triggers when a lead changes stages.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Created
Triggers when a new lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Is Reassigned
Triggers when a lead is reassigned.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Outbound Conversation Created
Triggers when an outbound conversation is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Process Changes Tags
Triggers when a process changes tags.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Process Reassigned
Triggers when a process is reassigned.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Completed Automatically
Triggers when a task is completed automatically. An automatic task set to auto send.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Created
Triggers when a task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Name
Comments
PipelineRequired
StageRequired
Source
Assignee
Tags
Created At
Closed At
Cost
Value
Num Units
Full Name
Email Addresses
Company Name
Mobile Phone Number
Office Phone
Home Phone
Mailing Address
Mailing Address City
Mailing Address State
Mailing Address Zip Code
Street Address
City
State
Zip Code
Property Type
Bathrooms
Bedrooms
Occupancy
Square Feet
Estimated Rent
Lease start date
Lease end date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Comments
Process TypeRequired
StageRequired
User
Tags
Due At
Property
Unit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ConversationRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ConversationRequired
Assignee
Status
Snooze Expiration
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Process TypeRequired
ProcessRequired
Name
Comments
Tags
Stage
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PropertyRequired
UnitRequired
Unit Number
Num Bedrooms
Num Bathrooms
Occupancy
Square Feet
Estimated Rent
Delinquent Rent
Lease Start Date
Lease End Date
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PipelineRequired
SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
Lead Changes Pipeline
Triggers when a lead changes pipelines.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Changes Tags
Triggers when a lead's tags change.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Opens Email
Triggers when a lead opens email.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Inbound Conversation Created
Triggers when an inbound conversation is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Process Changes Stage
Triggers when a process changes stages.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Process Created
Triggers when a new process is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Completed
Triggers when a task is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Completed Manually
Triggers when a task is completed manually. A manual task that does NOT use auto send.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.From NumberRequired
To NumberRequired
Call Duration (in seconds)
Call Recording URL
Description
Outcome
Created At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Note TextRequired
Created At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProcessRequired
Note TextRequired
Created At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
First Name
Last Name
Company/Secondary Name
Email Addresses
Mobile Phone Number
Home Phone Number
Office Phone Number
Mailing Address
Mailing Address City
Mailing Address State
Mailing Address Zip Code
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PipelineRequired
LeadRequired
Name
Comments
Tags
Stage
Assignee
Num Units
Contact IDs
Property IDs
Unit IDs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PropertyRequired
Property Type
Address Line 1
Address City
Address State
Address Zip Code
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProcess Type
SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPropertyRequired
SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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
About Google Sheets
Related categories
About LeadSimple
Related categories
Related Zap Templates
- Create LeadSimple leads from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for completed tasks in LeadSimple
- Create LeadSimple leads from new or updated Google Sheets spreadsheet rows in team drive
- Add new LeadSimple leads to Google Sheets rows
- Create leads in LeadSimple from new or updated rows in Google Sheets
- Create Google Sheets rows for updated pipelines in LeadSimple
- Create spreadsheet rows in Google Sheets for new inbound conversations in LeadSimple
- Create a Google Sheets row for every completed LeadSimple call
- Update Google Sheets rows when leads change stages in LeadSimple
- Update Google Sheets rows when tags on LeadSimple leads change
- Create spreadsheet rows in Google Sheets for new tasks created in LeadSimple
- Create new rows in Google Sheets for each process created in LeadSimple
- Create Google Sheets rows when stages change in LeadSimple
- Update LeadSimple processes with new or updated rows from Google Sheets team drive
- Create process notes in LeadSimple for new or updated rows in Google Sheets
- Create new LeadSimple leads from new Google Sheets rows on team drive
- Create LeadSimple processes from new or updated rows in Google Sheets
Related Zap Templates
- Create LeadSimple leads from new Google Sheets rows
- Add new LeadSimple leads to Google Sheets rows
- Create spreadsheet rows in Google Sheets for new inbound conversations in LeadSimple
- Update Google Sheets rows when tags on LeadSimple leads change
- Create Google Sheets rows when stages change in LeadSimple
- Create spreadsheet rows in Google Sheets for completed tasks in LeadSimple
- Create leads in LeadSimple from new or updated rows in Google Sheets
- Create a Google Sheets row for every completed LeadSimple call
- Create spreadsheet rows in Google Sheets for new tasks created in LeadSimple
- Update LeadSimple processes with new or updated rows from Google Sheets team drive
- Create LeadSimple leads from new or updated Google Sheets spreadsheet rows in team drive
- Create Google Sheets rows for updated pipelines in LeadSimple
- Update Google Sheets rows when leads change stages in LeadSimple
- Create new rows in Google Sheets for each process created in LeadSimple
- Create process notes in LeadSimple for new or updated rows in Google Sheets