Google Sheets + LeadSimple

Update LeadSimple processes with new or updated rows from Google Sheets team drive

Manage your leads with ease using this efficient workflow. When new or updated data is captured in your Google Sheets on Team Drive, the information is used to update processes in LeadSimple. This automatic process not only saves time on manual data entry but ensures your lead management system is always up-to-date with the latest information. Turn your Google Sheets into a dynamic database for seamless lead management.

When this happens...
New or Updated Spreadsheet Row (Team Drive)
Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPolling
automatically do this!
Update Process
Updates a Process. You'll need to specify a Process Type and a Stage.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write

- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Call Completed
Triggers when a new call is completed.
Trigger
Instant
Try It
Lead Changes Stage
Triggers when a lead changes stages.
Trigger
Instant
Try It
Lead Created
Triggers when a new lead is created.
Trigger
Instant
Try It
Lead Is Reassigned
Triggers when a lead is reassigned.
Trigger
Instant
Try It
Outbound Conversation Created
Triggers when an outbound conversation is created.
Trigger
Instant
Try It
Process Changes Tags
Triggers when a process changes tags.
Trigger
Instant
Try It
Process Reassigned
Triggers when a process is reassigned.
Trigger
Instant
Try It
Task Completed Automatically
Triggers when a task is completed automatically. An automatic task set to auto send.
Trigger
Instant
Try It
Task Created
Triggers when a task is created.
Trigger
Instant
Try It
- 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
Action
Write
- Name
- Comments
- Process TypeRequired
- StageRequired
- User
- Tags
- Due At
- Property
- Unit
Action
Write
- ConversationRequired
- TagRequired
Action
Write
- ConversationRequired
- Assignee
- Status
- Snooze Expiration
Action
Write
- Process TypeRequired
- ProcessRequired
- Name
- Comments
- Tags
- Stage
- Assignee
Action
Write
- PropertyRequired
- UnitRequired
- Unit Number
- Num Bedrooms
- Num Bathrooms
- Occupancy
- Square Feet
- Estimated Rent
- Delinquent Rent
- Lease Start Date
- Lease End Date
- Tags
Action
Write
- PipelineRequired
- SearchRequired
Action
Search
- SearchRequired
Action
Search
- SearchRequired
Action
Search
- IDRequired
Action
Search

- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Lead Changes Pipeline
Triggers when a lead changes pipelines.
Trigger
Instant
Try It
Lead Changes Tags
Triggers when a lead's tags change.
Trigger
Instant
Try It
Lead Opens Email
Triggers when a lead opens email.
Trigger
Instant
Try It
Inbound Conversation Created
Triggers when an inbound conversation is created.
Trigger
Instant
Try It
Process Changes Stage
Triggers when a process changes stages.
Trigger
Instant
Try It
Process Created
Triggers when a new process is created.
Trigger
Instant
Try It
Task Completed
Triggers when a task is completed.
Trigger
Instant
Try It
Task Completed Manually
Triggers when a task is completed manually. A manual task that does NOT use auto send.
Trigger
Instant
Try It
- From NumberRequired
- To NumberRequired
- Call Duration (in seconds)
- Call Recording URL
- Description
- Outcome
- Created At
Action
Write
- LeadRequired
- Note TextRequired
- Created At
Action
Write
- ProcessRequired
- Note TextRequired
- Created At
Action
Write
- 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
Action
Write
- PipelineRequired
- LeadRequired
- Name
- Comments
- Tags
- Stage
- Assignee
- Num Units
- Contact IDs
- Property IDs
- Unit IDs
Action
Write
- PropertyRequired
- Property Type
- Address Line 1
- Address City
- Address State
- Address Zip Code
- Tags
Action
Write
- SearchRequired
Action
Search
- Process Type
- SearchRequired
Action
Search
- PropertyRequired
- SearchRequired
Action
Search
- IDRequired
Action
Search

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About LeadSimple

LeadSimple is the CRM that property management and real estate companies use to scale and grow.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Related Zap Templates

Create LeadSimple processes from new or updated rows in Google Sheets

Update spreadsheet rows in Google Sheets when new leads are created in LeadSimple

Google Sheets + LeadSimple

Update LeadSimple processes with new or updated rows from Google Sheets team drive

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

Call Completed

Lead Changes Stage

Lead Created

Lead Is Reassigned

Outbound Conversation Created

Process Changes Tags

Process Reassigned

Task Completed Automatically

Task Created

Create Lead

Create Process

Tag Conversation

Update Conversation

Update Process

Update Unit

Search Lead

Search Property

Search User

Get Process

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

Lead Changes Pipeline

Lead Changes Tags

Lead Opens Email

Inbound Conversation Created

Process Changes Stage

Process Created

Task Completed

Task Completed Manually

Create Call

Create Lead Note

Create Process Note

Update Contact

Update Lead

Update Property

Search Contact

Search Process

Search Unit

Get Lead

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator