Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

FogBugz
Trigger: Watch Areas
Google Sheets
Action: Select an action
1. Select a trigger
  • Triggers when a new area is created.

  • Triggers when a case has been assigned.

  • Triggers when a case has been closed.

  • Triggers when a case has been edited.

  • Triggers when a case email event has been occured.

  • Triggers when a case email has been forwarded.

  • Triggers when a case email has been received.

  • Triggers when a case email has been replied.

  • Triggers when a case email has been sent.

  • Triggers when a case email has been sorted.

  • Triggers when a case event has occured.

  • Triggers when a case has been opened.

  • Triggers when a case has been reactivated.

  • Triggers when a case has been reopened.

  • Triggers when a case has been resolved.

  • Triggers when a case status has been changed.

  • Triggers when a new category is created.

  • Triggers when a new milestone is created.

  • Triggers when a new project is created.

  • Triggers when a new status is created.

  • Triggers when a new tag is created.

  • Triggers when a new user is created.

2. Select an action
  • Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

  • Appends a new row to the bottom of the table.

  • Adds a new sheet.

  • Appends multiple rows to the bottom of the table.

  • Updates multiple rows.

  • Clears a specific cell.

  • Clears values from a specific row.

  • Clears a specified range of values from a spreadsheet.

  • Copies a sheet to another spreadsheet.

  • Creates a new spreadsheet.

  • Creates a new spreadsheet from a template sheet.

  • Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.

  • Deletes a specific row.

  • Deletes a specific sheet.

  • Gets a specific cell.

  • Performs an arbitrary authorized API call.

  • Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.

  • Renames a specific sheet.

  • Updates a specific cell.

  • Updates a row.

Select a trigger and an action

Create workflow (opens in a new tab)