Автоматизация

Создать рабочий процесс

Building an automated workflow is similar to creating a flowchart. Триггеры, условия и действия компонуются так, что каждый исходный блок связан с одним или несколькими последующими.

Your permission level defines what you can do and where you can apply workflows. Подробнее о разрешениях для рабочих процессов.

You can build your workflows from scratch or customize existing templates. The Automation Template Gallery includes tips on when to use the workflow and how to customize each template.

Brandfolder Image

How to add a workflow

1. Галерея шаблонов автоматизации

• In the upper-left corner of your sheet, select Automation > Create from template…
• Select a template to open the details section.  

2. Создать рабочий процесс с нуля

• In the upper-left corner of your sheet, select Automation > Create from scratch…
  Brandfolder Image

Workflows are formed by:

• Trigger blocks: Define when your workflow is executed.
• Condition paths: A line that connects blocks to display different routes that your workflow may take depending on the conditions you set. Your workflow may have a single or several paths from trigger to action based on preceding conditions.
• Condition blocks: Define conditions to filter which rows to include in an alert or action.
• С помощью блока действий выберите операции, которые должны автоматически выполняться, когда активируется рабочий процесс.

Настройка рабочих процессов

Select the plus icon (+) to insert new paths and blocks to the workflow in order to:

• Add a condition: Filter the rows included in the workflow path.
• Add a condition path: Define an alternate route for your workflow if the first condition isn't met.
• Add an action: Define what you want your workflow to do once it meets your conditions. Brandfolder Image

Things to know about workflows

• With multiple paths, the workflow evaluates each condition block in sequence from left to right. The leftmost condition block that the row meets defines the path the row takes through the workflow.
• Add at least one action block at the end of each path. After an action block, you can define additional conditions and paths as long as another action block follows.
• Older workflows such as emails, update/approval requests, and move row automation on large sheets may take a few minutes to complete.
• Чтобы запросы на утверждение не отображались бесконечно, ячейки с межтабличными формулами и связями не будут запускать рабочие процессы, автоматически меняющие таблицу (перемещение, копирование, блокировка и разблокировка строк, запросы утверждения). При необходимости используйте автоматизированные процессы на основе времени или повторяющиеся рабочие процессы.

Workflow limitations

• Each sheet can have up to 150 workflows.
• Each workflow can have up to 100 blocks. This includes the trigger, condition, and action blocks.
• Each workflow can have up to 30 action blocks.
• Condition blocks can have up to 20 condition statements (20 lines within the block).
• Attachment links included in automated workflow emails expire after 14 days.

Best practices for workflows

• Type a name for your workflow in the upper-left corner of the workflow builder.
• Save your workflow after setting it up or after any change.
• Set your trigger to occur an hour before the action should occur. This ensures that technical issues don't prevent the action from occurring on time.
• To improve performance, combine workflows that are triggered together and deactivate older workflows.
• In the Manage Automation Workflows window, you can deactivate, activate, edit, duplicate, or remove a workflow.
• When you duplicate a workflow, modify the approval requests or use new values. Otherwise, the approvals in your original workflow may trigger approval requests in the new workflow.