Dealpath + Google Sheets
Create Dealpath properties and deals from new Google Sheets rows
Automate deal creation in Dealpath from spreadsheet entries. When a new deal row is added to your Google Sheet, this Zap creates a property in Dealpath, then creates the associated deal. This removes manual data entry and keeps Dealpath up to date with your spreadsheet, saving time and reducing errors.
Automate deal creation in Dealpath from spreadsheet entries. When a new deal row is added to your Google Sheet, this Zap creates a property in Dealpath, then creates the associated deal. This removes manual data entry and keeps Dealpath up to date with your spreadsheet, saving time and reducing errors.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Create PropertyCreates a new property in Dealpath.
ActionWriteCreate a new record or update an existing record in your app. - then do this!Create Deal
Creates a new deal in Dealpath.
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
Include Grid Data
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
Asset Updated
Triggers when an asset is updated in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Field Edited
Triggers when a custom field value changes. Can be filtered by entity type and specific field.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.File Updated
Triggers when a file is modified (renamed, moved, or tags changed).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Asset Created
Triggers when a new asset is created in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Loan Created
Triggers when a new loan is created in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property Updated
Triggers when a property is updated in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Asset IDRequired
Loan IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal NameRequired
Deal Type
Property IDs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
File NameRequired
Parent Folder IDRequired
FileRequired
File Content Type
File Tag IDs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Folder NameRequired
Parent Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tenant NameRequired
Property IDRequired
Begin DateRequired
Suite IDRequired
Leased AreaRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan NameRequired
Attach Loan ToRequired
Loan TypeRequired
Loan StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Field Definition IDRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
Field Definition IDRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Investment IDRequired
Deal IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
PropertyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File IDRequired
File NameRequired
File Content TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Deal NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Field DefinitionRequired
Field ValueRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
Field DefinitionRequired
Field ValueRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Investment IDRequired
Investment NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
Loan Name
Loan Type ID
Loan Status ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProperty IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appProperty IDs
Investment IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IDRequired
Field Definition IDs
Sparse (Only Populated Fields)
Include Demographic Fields
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appInvestment IDRequired
Field Definition IDs
Sparse (Only Populated Fields)
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appProperty IDRequired
Field Definition IDs
Linked Entity IDs
Sparse (Only Populated Fields)
Include Demographic Fields
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
Parent Folder IDs
File Tag Definition IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IDRequired
Folder IDs
Parent Folder IDs
File Tag Definition IDs
ActionThis is an event a Zap performs.SearchFind existing data in your appInvestment IDs
Deal IDs
Asset IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDs
Asset IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IDRequired
Role Definition IDs
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 foundDeal Updated
Triggers when a deal is updated in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.File Created
Triggers when a new file is uploaded to a deal or asset.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Loan Updated
Triggers when a loan is updated in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deal Created
Triggers when a new deal is created in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Property Created
Triggers when a new property is created in Dealpath.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Investment IDRequired
Deal IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Loan IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset NameRequired
Asset TypeRequired
Property IDs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
File NameRequired
Parent Folder IDRequired
FileRequired
File Content Type
File Tag IDs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AssetRequired
Folder NameRequired
Parent Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Investment NameRequired
Deal IDs
Asset IDs
Investment TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create List Option
Creates a new option for a list/dropdown field in Dealpath.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property NameRequired
Property TypeRequired
Address Line 1
Address Line 2
City
State
Postal Code
Country
Latitude
Longitude
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Field Definition IDRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property IDRequired
Field Definition IDRequired
Linked Entity ID
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete List Option
Deletes a list option from Dealpath. Can optionally transfer existing values to another option.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Loan IDRequired
Property IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Asset NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Deal StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Field DefinitionRequired
Field ValueRequired
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property IDRequired
Field DefinitionRequired
Field ValueRequired
Linked Entity ID
Derived Field ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update List Option
Updates an existing list option in Dealpath (rename or enable/disable).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property IDRequired
Property Name
Address Line 1
Address Line 2
City
State
Postal Code
Country
Latitude
Longitude
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Record Type
Search QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField Definition IDRequired
Sparse (Only Populated Fields)
Deal IDs
Property IDs
Investment IDs
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
Field Definition IDs
Sparse (Only Populated Fields)
Include Demographic Fields
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appLoan IDRequired
Field Definition IDs
Sparse (Only Populated Fields)
Include Demographic Fields
Derived Field ID
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IDRequired
Parent Folder IDs
File Tag Definition IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
Folder IDs
Parent Folder IDs
File Tag Definition IDs
ActionThis is an event a Zap performs.SearchFind existing data in your appProperty IDs
Deal IDs
Asset IDs
Updated Before
Updated After
ActionThis is an event a Zap performs.SearchFind existing data in your appProperty IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
Role Definition IDs
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Dealpath
Related categories
