Google Sheets + Rex

Create new Rex leads from newly updated rows in Google Sheets

Stay on top of your leads with this seamless workflow between Google Sheets and Rex. Each time you add or update a row in your Google Sheets, a new lead will be created in your Rex software. This automation ensures none of your potential clients fall through the cracks, saving you time and effort while keeping your leads organized and current.

When this happens...
New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Create Lead
Creates a Lead
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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

- 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

- 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
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Limit to Lead Types
- Limit to Lead Assignees
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Limit to type
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Limit to Mailing List
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Send From
- Contact ID (Recipient)
- CC Contact IDs
- BCC Contact IDs
- Related Listing ID
- Related Property ID
- Mail merge template
- Subject
- Body
Action
Write
- Your Rex Agency AccountRequired
- TypeRequired
- Contact NameRequired
- Contact Email
- Contact Phone
- Listing Address
- Listing ID
- Property Address
- Subject
- Assignee Override
- Notes
Action
Write
- Your Rex Agency AccountRequired
- TypeRequired
- Contact IDs
- Property IDs
- NoteRequired
Action
Write
- Your Rex Agency AccountRequired
- Send From
- Contact ID (Recipient)
- Related Listing ID
- Related Property ID
- Mail merge template
- Body
Action
Write
- Your Rex Agency AccountRequired
- Record TypeRequired
- Record IDRequired
- TagRequired
Action
Write
- Your Rex Agency AccountRequired
- Associated record typeRequired
- Record IDRequired
Action
Write
- Your Rex Agency AccountRequired
- Search type
- Search value
Action
Search
- Your Rex Agency AccountRequired
- Search type
- Search value
Action
Search

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- 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
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- TagRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- TagRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Limit to Mailing List
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- TagRequired
Trigger
Instant
Try It
- Your Rex Agency AccountRequired
- Lead IDRequired
- AssigneeRequired
Action
Write
- Your Rex Agency AccountRequired
- Match Profile CategoryRequired
- Contact IDRequired
- Suburbs
- Min Price
- Max Price
- Min Bedrooms
- Max Bedrooms
- Min Bathrooms
- Max Bathrooms
- Email Campaign Frequency
- SMS Campaign Frequency
Action
Write
- Your Rex Agency AccountRequired
- TypeRequired
- Due dateRequired
- RemindeeRequired
- PriorityRequired
- Contact ID
- Listing ID
- Property ID
- DescriptionRequired
Action
Write
- Your Rex Agency AccountRequired
- Record TypeRequired
- Record IDRequired
- TagRequired
Action
Write
- Your Rex Agency AccountRequired
- TrackRequired
- Contact ID
- Listing ID
- Property ID
- Start date
- Remindee Override
Action
Write
- Your Rex Agency AccountRequired
- Calendar Event ID
Action
Search
- Your Rex Agency AccountRequired
- Search type
- Search value
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 Rex

Thousands of agencies across Aus, NZ and UK are powered by Rex's cloud and mobile real estate platform.

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

Google Sheets + Rex

Create new Rex leads from newly updated rows in Google Sheets

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

Appraisal Created

Calendar Event Updated

Contact Updated

Contract Created

Lead Created

Listing Updated

Listing Sold/Leased

Contact Added to Mailing List

Note Created

Property Updated

Send Email

Create Lead

Create Note

Send SMS

Remove Tag

Remove All Tracks

Search for Full Contact

Search for Full Property

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

Calendar Event Created

Contact Created

Tag Added to Contact

Contract Status Changed

Listing Created

Listing Published

Tag Added to Listing

Contact Removed From Mailing List

Open Home Attendee Added

Tag Added to Property

Assign Lead

Create Match Profile

Create Reminder

Add Tag

Create Track

Search for Full Calendar Event

Search for Full Listing

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Rex