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 this happens...

Order StatusesOrder statuses you can use in the productTriggerPolling - automatically do this!

Clear Spreadsheet Row(s)Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with RO App and Google Sheets
Discover other triggers and actions you can use with RO App and Google Sheets
Ad CampaignsAd 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 plan
Cash Flow ItemsCash 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 plan- Sort 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 plan- Sort 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 plan
Get Product CategoriesGet Product Categories from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Get Service CategoriesGet Service Categories from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Get TaxesTriggers 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 plan- Ids
- 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 plan
Lead TypesLead 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 plan
Employees ListThe 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 plan
Order Custom FieldsTriggers 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 plan- Title
- Q
- Ids
- Barcodes
- Categories
- Articles
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- IdRequired
- 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_periodUnitsRequired
- 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 app- IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Task idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Serial number of assets
- Owner ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Sort Direction
- Author Ids
- Assignee Ids
- Deadline from
- Deadline to
ActionThis is an event a Zap performs.SearchFind existing data in your app- Client Email
- Client Phone
- Client ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Serial 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 found- TitleRequired
- 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 found- 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 plan- Dont_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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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 plan- Is order or estimate?Required
- Order_idRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Get PricesGet prices from the account
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Created at from
- Created at to
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Sorting 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 plan
Get 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 plan
Get Invoice StatusesTriggers 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 plan- Names
- 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 plan
LocationsLocations you can use in the product
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Order StatusesOrder 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 plan- Title
- Q
- Ids
- Barcodes
- Categories
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Invoice_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_periodUnits
- 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 app- Product_idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Ids
- 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 app- Title
- Q
- Ids
- Barcodes
- Categories
- Articles
ActionThis is an event a Zap performs.SearchFind existing data in your app- Title
- Q
- Ids
- Barcodes
- Categories
ActionThis is an event a Zap performs.SearchFind existing data 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
- 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 found- TitleRequired
- 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 found- Client 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 found- 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 plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found





