Skip to main content

Automations

Copera Board Automations let you define "when this happens, do that" rules that execute automatically on your board data — eliminating repetitive manual work. Every automation combines a trigger (such as Column Changed, Column Not Empty, Column Just Changed, Select Added, Select Removed, a Recurrence schedule, or a date-based reminder) with one or more actions (Change Column Value, Add Value, Remove Value, Copy Column Value, Set Current Date, Create Row, Send Notification, and Send Email via Gmail or Outlook). You can reference dynamic column values in notifications and email content, build recurring schedules that create rows on autopilot (including AI recurrence generation from plain language), and the built-in recursion guard prevents infinite loops.

How Automations Work

Every automation has two parts:

  1. Trigger (When) -- The event or condition that starts the automation.
  2. Action (Then) -- What happens when the trigger fires.

When a row is created or updated, Copera evaluates all active automations for that table. If a row matches an automation's trigger conditions, the corresponding actions execute automatically. The automation runs as the Copera AI bot user, and the action is recorded in the row's activity history.

Trigger Types

Copera supports six trigger types that cover a wide range of workflow scenarios:

TriggerDescriptionUse Case
Column ChangedFires when a column value matches a set of filter conditions (using AND logic).Run automation when a row matches a complex multi-field condition.
Column Not EmptyFires when a previously empty column receives a value for the first time.Notify the team when an assignee is first set on a task.
Column Just ChangedFires whenever a specific column's value changes from one value to another.Track status transitions or log when priority changes.
Select AddedFires when a specific option is added to a select/label column.Trigger when "Approved" label is added to a row.
Select RemovedFires when a specific option is removed from a select/label column.Alert when "Priority" label is removed from a task.
RecurrenceFires on a recurring schedule with flexible patterns.Create recurring check-in rows or periodic report entries.

Trigger Conditions

For the Column Changed trigger, you can define sophisticated filter conditions using the same operators available in Filters & Sorting. Conditions use AND logic, meaning all conditions must be true for the trigger to fire.

Advanced Recurrence

The Recurrence trigger supports flexible scheduling patterns that go far beyond simple daily or weekly repeats. When you select a recurrence trigger, the advanced recurrence editor lets you configure:

  • Frequency --- Choose from hourly, daily, weekly, monthly, or yearly.
  • Interval --- Set how often the pattern repeats (e.g., every 2 weeks, every 3 months).
  • Specific days --- For weekly frequency, pick which days of the week (Monday, Wednesday, Friday, etc.).
  • Specific hours --- For hourly or daily frequency, choose which hours the automation should run.
  • Monthly patterns --- Choose specific days of the month (e.g., the 1st and 15th), or relative patterns like "the second Tuesday of every month."
  • Yearly patterns --- Select which months and day patterns for annual automations.
  • Week start day --- Set which day your week begins (Monday, Sunday, etc.).
  • End conditions --- Optionally set the automation to stop after a certain number of occurrences or after a specific date.

A preview section shows the next scheduled dates so you can verify the pattern is correct before saving.

tip

You can also use the AI recurrence generator to describe your schedule in plain language (e.g., "every other Friday at 9 AM") and have it automatically create the recurrence pattern for you.

Execute Settings

Some triggers support execute settings that let you schedule the action relative to a date column value:

  • On Date --- Execute the action on the exact date in the column.
  • Before --- Execute a specified number of minutes, hours, days, weeks, or months before the date.
  • After --- Execute a specified number of minutes, hours, days, weeks, or months after the date.

This is useful for reminders (e.g., "3 days before the due date, notify the assignee") and follow-up actions (e.g., "1 week after completion, send a satisfaction survey").

Action Types

When a trigger fires, one or more actions are executed. Copera supports the following action types:

ActionDescription
Change Column ValueSet one or more column values on the triggering row. Define static values or reference other columns.
Add ValueAppend a value to a column without replacing the existing content. Useful for adding labels, tags, or users to multi-value fields.
Remove ValueRemove a value from a column without clearing the rest. Useful for taking a single label, tag, or person off a multi-value field.
Copy Column ValueCopy a value from one column to another within the same row.
Set Current DateStamp the current date/time into a date column, useful for tracking when events occurred.
Create RowCreate a new row in the same table or a different table. Map column values statically or dynamically from the trigger row.
Send NotificationSend an in-app notification to specific people with a custom subject and message.
Send Email (Gmail)Send an email via a connected Gmail account. Compose subject and body with dynamic column references.
Send Email (Outlook)Send an email via a connected Outlook account. Compose subject and body with dynamic column references.

Send Notification Action

The Send Notification action lets you alert specific team members when a trigger fires without leaving Copera. Configure:

  1. Subject --- A brief title for the notification. Supports dynamic placeholders.
  2. Body --- The notification message. Supports dynamic placeholders and rich text formatting.
  3. Recipients --- Choose specific workspace members, or reference a Users column to dynamically notify whoever is assigned to the row.

For example, you can create an automation that says: "When status changes to Done, notify the person in the Assignee column with the message 'Your task {Task Name} has been completed.'"

tip

Use the Send Notification action instead of email when your team primarily works inside Copera. Notifications appear instantly in the recipient's notification center without requiring email account connections.

Add Value and Remove Value Actions

The Add Value and Remove Value actions work differently from Change Column Value: instead of replacing the whole field, they adjust a single value while leaving everything else in place. They are the natural choice for multi-value fields like Labels, Dropdowns that allow multiple selections, and Users.

Add Value appends to the current value. Use it to:

  • Add a label or tag to a multi-select column without removing existing labels.
  • Add a person to a Users column without unassigning the current assignees.
  • Append an option to a dropdown that supports multiple selections.

Remove Value takes a single value out without clearing the rest. Use it to:

  • Drop one label or tag from a row while keeping the others.
  • Unassign a specific person from a Users column without removing the rest of the team.
  • Remove one option from a multi-select dropdown.
tip

Pair these two actions to move a value between states automatically --- for example, when a task is marked Done, remove the "In Progress" label and add a "Completed" label in the same automation.

Dynamic Column References in Actions

Actions that involve text content (like notification messages, email subject, and email body) support dynamic column references. You can insert placeholders that are replaced at runtime with actual values from the triggering row:

  • Board name --- The name of the board containing the row.
  • Table name --- The name of the table containing the row.
  • Any column value --- Insert the value of any column from the triggering row.

These placeholders appear as labeled chips in the text editor, making it easy to see which dynamic values are included.

tip

While typing a notification message, email subject, or email body, press the { key to bring up the list of dynamic values you can insert. Pick one and it drops in as a chip --- no need to remember exact column names.

Send Email Action

Copera can send an email automatically when an automation fires, using one of your own connected email accounts. Both Gmail and Outlook are supported, so you can pick whichever provider you use.

When you choose a Send Email action you can configure:

  1. Account --- Choose which connected Gmail or Outlook account the email is sent from. If you have not connected one yet, Copera prompts you to connect before you finish.
  2. Recipients --- Add one or more people in the To field. You can also add Cc, Bcc, and Reply-To addresses. Recipients can be workspace members or any external email address.
  3. Subject and Body --- Write the email's subject and message. Both support dynamic column references, so the email can include the row's own values (for example, the task name, due date, or assignee).

This makes it easy to send polished, personalized emails --- order confirmations, status updates, or reminders --- straight from your board without copying anything by hand.

note

Emails are sent from your connected account, so replies come back to you and the message appears in your own Sent folder. Connect your Gmail or Outlook account in your user settings before building an email automation.

Recurring Row Creation

One of the most powerful combinations is a Recurrence trigger paired with a Create Row action: Copera adds a new row automatically on whatever schedule you define --- no one has to remember to do it.

This is ideal for work that repeats on a rhythm:

  • A weekly status-report row every Monday morning.
  • A monthly billing-review row on the 1st of each month.
  • A quarterly planning row at the start of each quarter.
  • A daily stand-up row each weekday.

To set it up:

  1. Create a new automation and choose the Recurrence trigger.
  2. Build your schedule in the advanced recurrence editor (or describe it in plain language with the AI recurrence generator).
  3. Add a Create Row action and pick the table the new row should land in.
  4. Fill in the column values the new row should start with. You can set fixed values (like a title or status) and let date columns stamp themselves.
  5. Save. From then on, a fresh row appears automatically every time the schedule comes around.
tip

Combine recurring row creation with a Send Notification action in the same automation so the right person is alerted the moment each new row is created.

Creating an Automation

Follow these steps to set up a new automation:

  1. Open your board and navigate to the table you want to automate.
  2. Click the Automations button in the board toolbar.
  3. Click Create Automation to open the automation builder.
  4. Name your automation -- Give it a descriptive name like "Notify assignee on completion" or "Auto-stamp completion date."
  5. Configure the trigger -- Select the trigger type and define the conditions. For column-based triggers, choose the column and set the matching criteria. For recurrence triggers, set up your schedule pattern.
  6. Configure the action(s) -- Select the action type and define the details. You can add multiple actions to a single automation by clicking the + button below the action list.
  7. Save and activate -- Save the automation. It becomes active immediately and will evaluate on every future row change (or on schedule for recurrence triggers).

Managing Automations

Enabling and Disabling

Each automation has an on/off toggle. Disabling an automation preserves its configuration but prevents it from firing. This is useful for temporarily pausing automations during bulk data imports or maintenance.

Automation Execution Feedback

When an automation fires, Copera sends a real-time update to all users viewing the board, showing which automation ran and who triggered it. This provides immediate visibility into automated changes.

Email Automation Logs

For email automations, Copera records detailed history entries:

  • Success -- The email was sent successfully, and the details (recipients, subject, body) are logged in the row history.
  • Failure -- If the email fails (e.g., invalid connection token), the automation owner receives a notification explaining the failure, and the error is logged.

Recursion Protection

Automations include built-in recursion guards. When a "Change Column Value" action modifies a row, Copera compares the new values against the existing values and skips updates where the value has not actually changed. This prevents infinite loops where an automation's action re-triggers the same automation.

Task Activity and Comments

Every task (row) in your board has an Activity Panel where you can see the full history of changes, automation actions, and comments. The activity panel uses a chat-style interface that makes discussions on tasks feel like natural conversations.

Commenting on Tasks

  1. Open any task by clicking on it.
  2. The Activity Panel appears on the right side.
  3. Type your message in the input field at the bottom and press Enter to send.
  4. Comments appear in a chat-like timeline alongside automated activity entries.

Activity Features

  • Rich text --- Format your comments with bold, italic, lists, and more.
  • File attachments --- Drag and drop files directly into the comment input.
  • Reactions --- React to comments with emoji reactions.
  • Edit and delete --- Edit or delete your own comments after posting.
  • History toggle --- Switch between showing only comments or the full activity history (including automated field changes, email logs, and approval decisions).
  • Resizable panel --- Drag the left edge of the activity panel to adjust its width.
note

Automation actions appear in the activity history with clear labels showing which automation ran and what changed. This gives your team full transparency into automated workflows.

Best Practices

tip

Name automations descriptively so team members understand their purpose at a glance. For example, "Notify PM when task blocked" is much clearer than "Automation 1."

tip

Test with a single row first before activating an automation on a board with many rows. This lets you verify the trigger conditions and actions work as expected.

tip

Use the Send Notification action for internal team alerts. It is faster to set up than email (no account connection required) and notifications appear instantly inside Copera.

tip

Use advanced recurrence for periodic tasks like weekly status reports, monthly billing checks, or quarterly reviews. The AI recurrence generator makes it easy to describe complex patterns in plain language.

tip

Connect email accounts in your user settings before creating email automations. Both Gmail and Outlook are supported through secure connections.

tip

Monitor automation history in the task activity panel to verify automations are working as expected.

Frequently Asked Questions

Can I have multiple actions on a single automation?

Yes. Click the + button below the action list to add additional actions. All actions execute in order when the trigger fires.

What happens if a notification action fails?

In-app notifications are delivered through Copera's notification system and are highly reliable. If a recipient has left the workspace, the notification is silently skipped.

Can I reference a Users column as the notification recipient?

Yes. When configuring the Send Notification action, the recipient field lets you select a Users column from your table. The notification will be sent to whoever is assigned in that column for the triggering row.

How do I stop a recurrence automation?

You can either disable the automation using its on/off toggle, or configure an end condition in the recurrence settings (stop after N occurrences or after a specific date).

What is the difference between "Change Column Value", "Add Value", and "Remove Value"?

Change Column Value replaces the current value entirely. Add Value appends a value to the existing ones, and Remove Value takes a single value out while leaving the rest --- both are designed for multi-select, labels, and users columns where you want to adjust one entry without disturbing the others.

Can an automation create a new row on a schedule?

Yes. Pair a Recurrence trigger with a Create Row action and Copera will add a fresh row automatically on the schedule you set --- daily, weekly, monthly, or any custom pattern. This is perfect for recurring status reports, billing reviews, or stand-up entries. See Recurring Row Creation.

Can I send email from both Gmail and Outlook?

Yes. The Send Email action works with either a connected Gmail or Outlook account --- just pick the account you want to send from. You can add To, Cc, Bcc, and Reply-To recipients and personalize the subject and body with dynamic column values.

  • Filters & Sorting --- The same filter operators used in automation trigger conditions.
  • Formulas --- Create computed values that can complement your automations.
  • Board Permissions --- Control who can create and manage automations.