Google Sheets + RO App
Clear Google Sheets rows when new order statuses are updated in RO App
When an order status changes in RO App, ensure your Google Sheets record remains up-to-date with this efficient workflow. It paves the way for a streamlined business operation by instantly removing specific rows in your Google Sheets. With this automation, you can keep your spreadsheets organized and accurate, saving time and enhancing your business organization.
When an order status changes in RO App, ensure your Google Sheets record remains up-to-date with this efficient workflow. It paves the way for a streamlined business operation by instantly removing specific rows in your Google Sheets. With this automation, you can keep your spreadsheets organized and accurate, saving time and enhancing your business organization.
- When this happens...
Order StatusesOrder statuses you can use in the product
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Clear Spreadsheet Row(s)Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Ad Campaigns
Ad Campaigns you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCash Flow Items
Cash flow items you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSort Direction
Types
Branches
Statuses
Asset UID
IDs
ID Labels
Managers
Engineers
Clients IDs
Client Names
Client Phones
Created At from
Created At to
Modified At from
Modified At to
Done At from
Done At to
Closed At from
Closed At to
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSort Direction
Cashbix idRequired
Created from
Created to
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet Product Categories
Get Product Categories from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet Service Categories
Get Service Categories from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet Taxes
Triggers when a new get_taxes is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIds
Statuses
Client Ids
Client Names
Client Phones
Payer Ids
Payer Names
Payer Phones
Managers
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLead Types
Lead Types you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEmployees List
The list of Employees you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planOrder Custom Fields
Triggers when a new order_custom_fields is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTitle
Q
Ids
Barcodes
Categories
Articles
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIdRequired
Is ServiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead IdRequired
MessageRequired
Is Private
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Is order or estimate?Required
Order IdRequired
Is ServiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Branch IdRequired
Assignee Id
Client IdRequired
Scheduled ForRequired
Scheduled To
Resource Id
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email
Phone
Address
Notes
Is supplier?
Is juridical?
Is conflicted?
Marketing source
Discount code
Discount goods
Discount services
Discount materials
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Branch idRequired
Order typeRequired
Client ID
Asset ID
Is urgent?
Estimated cost
Appearance
Packagelist
Malfunction
Assigned at
Duration
Estimated done at
Manager ID
Engineer ID
Manager notes
Warranty date
Kind of good
Brand
Model
Serial
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Cashbox IDRequired
Payment amountRequired
DirectionRequired
Cash flow item
Client ID
Employee ID
Created at
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Status IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Description
Barcodes
Category IdRequired
Article
Code
Uom IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Booking IDRequired
Branch Id
Assignee Id
Client Id
Scheduled For
Scheduled To
Resource Id
Comment
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id NameRequired
First Name
Last Name
Email
Phone
Address
Notes
Is supplier?
Is juridical?
Is conflicted?
Marketing source
Discount code
Discount goods
Discount services
Discount materials
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Is order or estimate?Required
Order IdRequired
Item IdRequired
Assignee IdRequired
QuantityRequired
PriceRequired
CostRequired
Discount TypeRequired
Discount SponsorRequired
Discount ValueRequired
Warranty PeriodRequired
Warranty Period UnitsRequired
Tax Ids
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Branches
IDs
Statuses
Assignees
Client IDs
Client Names
Client Phones
Created At From
Created At To
Modified At From
Modified At To
Scheduled For From
Scheduled For To
Ordering
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTask idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSerial number of assets
Owner ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSort Direction
Author Ids
Assignee Ids
Deadline from
Deadline to
ActionThis is an event a Zap performs.SearchFind existing data in your appClient Email
Client Phone
Client ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSerial number of asset
ID of Asset owner
Vehicle plate number
Group of Asset
Brand of Asset
Model of Asset
Modification of Asset
Color of Asset
Condition of Asset
Year of Asset
Warehouse ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTitleRequired
Q
Ids
Barcodes
Categories
Category IdRequired
Cost
Uom IdRequired
Is Labor
Warranty
Warranty Period
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont 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
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
Branches
IDs
Statuses
Assignees
Client IDs
Client Names
Client Phones
Created At From
Created At To
Modified At From
Modified At To
Scheduled For From
Scheduled For To
Ordering
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIs order or estimate?Required
Order IdRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet Prices
Get prices from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCreated at from
Created at to
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSorting direction
Authors employees Id's for filtering
Assignee employee id's
Deadline from
Deadline to
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet UOMs (Inits of Measure)
Get UOMs (Inits of Measure)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGet Invoice Statuses
Triggers when a new invoice_statuses is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNames
Phones
Emails
Discount Codes
Marketing Sources
Is Juridical
Is Supplier
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLocations
Locations you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planOrder Statuses
Order statuses you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTitle
Q
Ids
Barcodes
Categories
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planInvoice IdRequired
MessageRequired
Is Private
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IdRequired
MessageRequired
Is Private
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IdRequired
MessageRequired
Is Private
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Serial number of asset
Vehicle plate number
Group of Asset
Brand of Asset
Model of Asset
Modification of Asset
Color of Asset
Condition of Asset
Year of Asset
ID of Asset owner
Warehouse ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact nameRequired
Contact phone
Lead type IDRequired
Client ID
Manager ID
Location ID
Additional description
Ad campaign
Is urgent?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Is order?Required
Branch idRequired
Order typeRequired
Client IDRequired
Payer ID
Asset ID
Ad Campaign ID
Is urgent?
Estimated price
Malfunction
Scheduled for
Scheduled to
Resource ID
Due date
Manager ID
Assignee ID
Manager notes
Engineer notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
DescriptionRequired
DeadlineRequired
AssigneesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IdRequired
Warehouse ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Barcodes
Category IdRequired
Cost
Uom IdRequired
Is Labor
Warranty
Warranty Period
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Item IdRequired
Quantity
Price
Cost
Warranty Period
Warranty Period Units
Discount Type
Discount Sponsor
Discount Value
Tax Ids
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Is order or estimate?Required
Order IDRequired
Branch id
Order type
Client ID
Payer ID
Asset ID
Ad Campaign ID
Is urgent?
Estimated price
Malfunction
Scheduled for
Scheduled to
Resource ID
Due date
Manager ID
Assignee ID
Manager notes
Engineer notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IdRequired
TitleRequired
Description
Barcodes
Category IdRequired
Article
Code
Uom IdRequired
Is Serial
Warranty
Warranty Period
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIds
Statuses
Client Ids
Client Names
Client Phones
Payer Ids
Payer Names
Payer Phones
Managers
ActionThis is an event a Zap performs.SearchFind existing data in your appTitle
Q
Ids
Barcodes
Categories
Articles
ActionThis is an event a Zap performs.SearchFind existing data in your appTitle
Q
Ids
Barcodes
Categories
ActionThis is an event a Zap performs.SearchFind existing data in your appBranches
IDs
Statuses
Assignees
Client IDs
Client Names
Client Phones
Created At From
Created At To
Modified At From
Modified At To
Scheduled For From
Scheduled For To
Ordering
Branch IdRequired
Assignee Id
Client IdRequired
Scheduled ForRequired
Scheduled To
Resource Id
Comment
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTitleRequired
Q
Ids
Barcodes
Categories
Articles
Description
Category IdRequired
Article
Code
Uom IdRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundClient Email
Client Phone
Client ID
First Name
Last Name
Email
Phone
Address
Notes
Is supplier?
Is juridical?
Is conflicted?
Marketing source
Discount code
Discount goods
Discount services
Discount materials
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont 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 found
About Google Sheets
Related categories
