# SheetAutomationRules ## Documentation The workflows of the sheets which send alerts, requests or changes when something happens. A filter on sheet_id reads one sheet only. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `automation_rule_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `SheetAutomationRules` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `action_frequency` | `varchar2` | | ☐ | How often the rule acts: IMMEDIATELY, HOURLY, DAILY or WEEKLY. | | `action_type` | `varchar2` | | ☐ | What the rule does: NOTIFICATION_ACTION, UPDATE_REQUEST_ACTION or APPROVAL_REQUEST_ACTION. | | `automation_rule_id` | `int64` | | ☑ | The id of the rule. | | `created_at` | `datetime` | | ☐ | When the rule was made, UTC. | | `created_by_email` | `varchar2` | | ☐ | The e-mail address of who made the rule. | | `disabled_reason` | `varchar2` | | ☐ | Why Smartsheet switched the rule off, when it did. | | `enabled` | `char` | | ☐ | Whether the rule runs. | | `modified_at` | `datetime` | | ☐ | When the rule was last changed, UTC. | | `modified_by_email` | `varchar2` | | ☐ | The e-mail address of who last changed the rule. | | `name` | `varchar2` | | ☐ | The name of the rule. | | `sheet_id` | `int64` | | ☑ | The sheet of the rule. | | `user_can_modify` | `char` | | ☐ | Whether the user may change the rule. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | Declared by the connector, not enforced by the platform |