Google Sheets + LeadSimple

Create LeadSimple leads from new or updated Google Sheets spreadsheet rows in team drive

Easily track and manage new leads from your Team Drive Google Sheets by automatically creating them in LeadSimple. With this workflow, every time there is a new or updated row in your Google Sheets document, a lead is created in LeadSimple. This solution saves time and ensures that you never miss an opportunity to connect with potential clients.

When this happens...
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
TriggerScheduled
automatically do this!
Create Lead
Creates a Lead in one of your Pipelines. You'll need to specify a Pipeline 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

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
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
- 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

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
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
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
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 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

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

Google Sheets + LeadSimple

Create LeadSimple leads from new or updated Google Sheets spreadsheet rows in team drive

New Spreadsheet Row (Team Drive)

Drive

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

Trigger Column

Create Spreadsheet Column

Drive

Index

Create Multiple Spreadsheet Rows

Drive

Create Spreadsheet

Spreadsheet to Copy

Headers

Clear Spreadsheet Row

Drive

Update Spreadsheet Row

Drive

API Request (Beta)

Api Docs Info

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

Lookup Spreadsheet Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Find or Create Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Lead Changes Pipeline

Lead Changes Tags

Lead Opens Email

Inbound Conversation Created

Process Changes Stage

Process Created

Task Completed

Create Call

Call Duration (in seconds)

Call Recording URL

Description

Outcome

Created At

Create Lead Note

Created At

Create Process Note

Created At

Update Contact

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

Update Lead

Name

Comments

Tags

Stage

Assignee

Num Units

Contact IDs

Property IDs

Unit IDs

Update Property