Comment on Urbanise FM work orders when new rows are added in Google Sheets
With this workflow, you can easily manage your work orders in Urbanise FM whenever a new row is added to your Google Sheets. By seamlessly connecting these two powerful tools, this integration ensures that no necessary comments on work orders are missed whenever new data is inputted into your spreadsheet. It saves you time and maintains a systematic approach to your order management.
With this workflow, you can easily manage your work orders in Urbanise FM whenever a new row is added to your Google Sheets. By seamlessly connecting these two powerful tools, this integration ensures that no necessary comments on work orders are missed whenever new data is inputted into your spreadsheet. It saves you time and maintains a systematic approach to your order management.
- When this happens...New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Comment on a Work Order
Comment on a Work Order
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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 foundAccount Created
Triggers When An Account Has Been Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Status Changed
Triggers when an Invoice's Status Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property Updated
Triggers When A Property Has Been Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Supplier Updated
Triggers When A Supplier Has Been Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Support Request Updated
Triggers When A Support Request Has Been Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Comment Added
Triggers When A Work Order's Comment Has Been Added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Added
Triggers When A Work Order Job Has Been Added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Attachment Added
Triggers When A Work Order's Job Attachment Has Been Added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Next Action Change
Triggers When A Work Order's Job Next Action Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Status Change
Triggers When A Work Order's Job Status Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job ReferenceRequired
Document typeRequired
Document description
Filemetadata thumbnail
Visible To Customer
Visible To Job
FilenameRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job ReferenceRequired
Job CommentRequired
Visible To CustomerRequired
Comment Providers External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
Business Email AddressRequired
SegmentRequired
External Reference NumberRequired
Account First Name
Account Last Name
Account Middle Name
Account Title
Account Number
Contact Other Phone Number
Contact Primary Phone Number
Corporate account
Date Of Birth
Gender
Nationality
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
External Reference Required
Account Viewable
Active
Allow Jobs Raised
Allow Record Assets
Bee Rating
Business Address
Company Number
Compliance Status
Display Name
Email
Hide Amount Due
Internal
Latitude
Longitude
Phone
Property Viewable
Raise Location Work Orders
Recipient Created Tax Invoice
Record Response TimeRequired
Region Identifiers
Segment Keys
Send Work Order Notifications
Skills
Time Sheet Required
Upload Customer Documents
View Sales Rates
Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer NumberRequired
Approval Reference
Area Reference Number
Work Order Auto Assignee Reference
Work Order Description
Due Date
Work Order External Reference
Job Template Assignee Reference
Job Template ReferenceRequired
Job Template TypeRequired
Pre-Check Work Instruction Reference
Work Order PriorityRequired
Work Instruction Reference
Property Reference NumberRequired
Requesters Email Address
Requesters Name
Requesters Phone
Work Order TitleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Template TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job ReferenceRequired
Copy Cancellation Email Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
Business Email AddressRequired
SegmentRequired
External Reference NumberRequired
Account First Name
Account Last Name
Account Middle Name
Account Title
Account Number
Contact Other Phone Number
Contact Primary Phone Number
Corporate account
Date Of Birth
Gender
Nationality
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property AddressRequired
Country Code Required
Location IDRequired
Suburb
Building Name
Building Number
Building Ref
Building Type
City
State
Delivery Region
Event Id
External Link
Internal Reference
Latitude
Longitude
Parent Reference Link
Post Code
Property Type
Room Count
Segment KeysRequired
Site Name
Supplier Region Name
Location Tags
Unit Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No 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 foundAccount Updated
Triggers When An Account Has Been Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property Created
Triggers When A Property Has Been Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Supplier Created
Triggers When A Supplier Has Been Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Support Request Created
Triggers When A Support Request Has Been Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Attachment Added
Triggers When A Work Order's Attachment Has Been Added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Created
Triggers When A Work Order Has Been Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Assignee Change
Triggers When A Work Order's Job Assignee Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Due Date Change
Triggers When A Work Order's Job Due Date Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Job Priority Change
Triggers When A Work Order's Job Priority Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Work Order Status Changed
Triggers When A Work Order's Status Changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Service Request ReferenceRequired
Document typeRequired
Document description
Filemetadata thumbnail
Visible To Customer
Visible To Job
FilenameRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Work Order ReferenceRequired
Work Order CommentRequired
Visible To CustomerRequired
Comment Providers External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Property AddressRequired
Country Code Required
Location IDRequired
Suburb
Building Name
Building Number
Building Ref
Building Type
City
State
Delivery Region
Event Id
External Link
Internal Reference
Latitude
Longitude
Parent Reference Link
Post Code
Property Type
Room Count
Segment KeysRequired
Site Name
Supplier Region Name
Location Tags
Unit Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category KeyRequired
Topic KeyRequired
Account NumberRequired
SummaryRequired
Description
Creator Email Address
Send To Email Address
External Reference
External Location Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document Reference NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice External ReferenceRequired
Payment ReferenceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job ReferenceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Reference NumberRequired
External Reference NumberRequired
Response Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
External Reference Required
Account Viewable
Active
Allow Jobs Raised
Allow Record Assets
Bee Rating
Business Address
Company Number
Compliance Status
Display Name
Email
Hide Amount Due
Internal
Latitude
Longitude
Phone
Property Viewable
Raise Location Work Orders
Recipient Created Tax Invoice
Record Response TimeRequired
Region Identifiers
Segment Keys
Send Work Order Notifications
Skills
Time Sheet Required
Upload Customer Documents
View Sales Rates
Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.