Google Sheets + Urbanise FM

Google Sheets + Urbanise FM integrations

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.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Comment on a Work OrderComment on a Work Order
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Google Sheets and Urbanise FM

Discover other triggers and actions you can use with Google Sheets and Urbanise FM

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Account Created
Triggers When An Account Has Been Created.
Trigger
Instant
Try It
Invoice Status Changed
Triggers when an Invoice's Status Changes.
Trigger
Instant
Try It
Property Updated
Triggers When A Property Has Been Updated.
Trigger
Instant
Try It
Supplier Updated
Triggers When A Supplier Has Been Updated.
Trigger
Instant
Try It
Support Request Updated
Triggers When A Support Request Has Been Updated.
Trigger
Instant
Try It
Work Order Comment Added
Triggers When A Work Order's Comment Has Been Added.
Trigger
Instant
Try It
Work Order Job Added
Triggers When A Work Order Job Has Been Added.
Trigger
Instant
Try It
Work Order Job Attachment Added
Triggers When A Work Order's Job Attachment Has Been Added.
Trigger
Instant
Try It
Work Order Job Next Action Change
Triggers When A Work Order's Job Next Action Changes.
Trigger
Instant
Try It
Work Order Job Status Change
Triggers When A Work Order's Job Status Changes.
Trigger
Instant
Try It
- Job Reference
  Required
- Document type
  Required
- Document description
- Filemetadata thumbnail
- Visible To Customer
- Visible To Job
- Filename
  Required
- File
  Required
Action
Write
- Job Reference
  Required
- Job Comment
  Required
- Visible To Customer
  Required
- Comment Providers External Reference
Action
Write
- Business Name
  Required
- Business Email Address
  Required
- Segment
  Required
- External Reference Number
  Required
- 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
Action
Write
- Business Name
  Required
- 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 Time
  Required
- Region Identifiers
- Segment Keys
- Send Work Order Notifications
- Skills
- TimeSheetRequired
- UploadCustomerDocuments
- ViewSalesRates
- Website
Action
Write
- Customer Number
  Required
- 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 Reference
  Required
- Job Template Type
  Required
- Pre-Check Work Instruction Reference
- Work Order Priority
  Required
- Work Instruction Reference
- Property Reference Number
  Required
- Requesters Email Address
- Requesters Name
- Requesters Phone
- Work Order Title
  Required
Action
Write
- Job Template Type
  Required
Action
Write
- Job Reference
  Required
- Copy Cancellation Email Address
Action
Write
- Business Name
  Required
- Business Email Address
  Required
- Segment
  Required
- External Reference Number
  Required
- 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
Action
Write
- Property Address
  Required
- Country Code
  Required
- Location ID
  Required
- 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 Keys
  Required
- Site Name
- Supplier Region Name
- Location Tags
- Unit Number
Action
Write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Account Updated
Triggers When An Account Has Been Updated.
Trigger
Instant
Try It
Property Created
Triggers When A Property Has Been Created.
Trigger
Instant
Try It
Supplier Created
Triggers When A Supplier Has Been Created.
Trigger
Instant
Try It
Support Request Created
Triggers When A Support Request Has Been Created.
Trigger
Instant
Try It
Work Order Attachment Added
Triggers When A Work Order's Attachment Has Been Added.
Trigger
Instant
Try It
Work Order Created
Triggers When A Work Order Has Been Created.
Trigger
Instant
Try It
Work Order Job Assignee Change
Triggers When A Work Order's Job Assignee Changes.
Trigger
Instant
Try It
Work Order Job Due Date Change
Triggers When A Work Order's Job Due Date Changes.
Trigger
Instant
Try It
Work Order Job Priority Change
Triggers When A Work Order's Job Priority Changes.
Trigger
Instant
Try It
Work Order Status Changed
Triggers When A Work Order's Status Changes.
Trigger
Instant
Try It
- Service Request Reference
  Required
- Document type
  Required
- Document description
- Filemetadata thumbnail
- Visible To Customer
- Visible To Job
- Filename
  Required
- File
  Required
Action
Write
- Work Order Reference
  Required
- Work Order Comment
  Required
- Visible To Customer
  Required
- Comment Providers External Reference
Action
Write
- Property Address
  Required
- Country Code
  Required
- Location ID
  Required
- 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 Keys
  Required
- Site Name
- Supplier Region Name
- Location Tags
- Unit Number
Action
Write
- Category Key
  Required
- Topic Key
  Required
- Account Number
  Required
- Summary
  Required
- Description
- Creator Email Address
- Send To Email Address
- External Reference
- External Location Reference
Action
Write
- Document Reference Number
  Required
Action
Write
- Invoice External Reference
  Required
- Payment Reference
  Required
Action
Write
- Job Reference
  Required
Action
Write
- Job Reference Number
  Required
- External Reference Number
  Required
- Response Time
Action
Write
- Business Name
  Required
- 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 Time
  Required
- Region Identifiers
- Segment Keys
- Send Work Order Notifications
- Skills
- TimeSheetRequired
- UploadCustomerDocuments
- ViewSalesRates
- Website
Action
Write

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Urbanise FM

Urbanise offers cloud-based solutions to service the Facilities and Strata Management industries.

HelpHelp

Related categories

IT Operations