Create actions that download and export data
Workbooks support actions that initiate direct downloads and exports to email, Slack channels, webhooks, and cloud storage.
This document explains how to create actions to download and export workbook content to specific destinations. For more information about actions in Sigma, see Intro to actions.
User requirements
The following requirements apply to users who configure actions. Users who access and interact with a workbook can typically trigger all existing actions within it. Any restrictions are noted in this document.
The ability to configure actions requires the following:
-
You must be assigned an account type with the Full explore or Create, edit, and publish workbooks permission enabled.
-
You must be the workbook owner or be granted Can explore1 or Can edit workbook permission.
1 If you’re granted Can explore workbook permission, you can configure actions but cannot save changes to the workbook’s published version.
Initiate direct download
Create an action that downloads an entire workbook, a specific page, or an individual element directly to the interacting user’s device.
This action can only be configured and triggered by users assigned an account type with the Download or Send Now permission enabled.
-
Open a workbook in Explore or Edit mode.
-
Select the element you want to trigger the action, then click Actions in the side navigation.
-
In the Actions panel, click Add action.
-
In the On select, On click, or On change modal (title depends on the type of trigger element), configure the required fields to define the response:
When selecting cells in Select a column from the trigger element to initiate the action when clicked.
This field only applies when the trigger element is a table, pivot table, or input table.
Condition [optional] Configure a condition that should be met for the action to take effect. Action Select Download and export. Destination Select Download. Attachment Select the workbook content to download, then choose a file type.
Export to email
Create an action that emails an entire workbook, a specific page, or an individual element to specific recipients.
This action can only be configured and triggered by users assigned an account type with the Download or Send Now permission enabled.
-
Open a workbook in Explore or Edit mode.
-
Select the element you want to trigger the action, then click Actions in the side navigation.
-
In the Actions panel, click Add action.
-
In the On select, On click, or On change modal (title depends on the type of trigger element), configure the required fields to define the response:
When selecting cells in Select a column from the trigger element to initiate the action when clicked.
This field only applies when the trigger element is a table, pivot table, or input table.
Condition [optional] Configure a condition that should be met for the action to take effect. Action Select Download and export. Destination Select Email. Recipient Enter one or more comma-separated email addresses for the export recipients. Subject Enter text to include in the email subject line. Message [optional] Enter a message to include in the email body. Attachment Select the workbook content to export, then choose a file type. More options [optional] Select the Include link to workbook checkbox to allow the export recipient to open the workbook directly from the email.
[optional] Select the Run queries as recipient checkbox to run workbook queries as the recipient of the email. If deselected (default), queries run as the user who performs the action.
[optional] Select the Send as .zip file checkbox to send attachments as a compressed zip file.
Export to Slack
Create an action that exports an entire workbook, a specific page, or an individual element to Slack.
This action can only be configured and triggered by users assigned an account type with the Export to Slack permission enabled.
-
Open a workbook in Explore or Edit mode.
-
Select the element you want to trigger the action, then click Actions in the side navigation.
-
In the Actions panel, click Add action.
-
In the On select, On click, or On change modal (title depends on the type of trigger element), configure the required fields to define the response:
When selecting cells in Select a column from the trigger element to initiate the action when clicked.
This field only applies when the trigger element is a table, pivot table, or input table.
Condition [optional] Configure a condition that should be met for the action to take effect. Action Select Download and export. Destination Select Slack. To Enter the name of a Slack channel that must receive the export. Message [optional] Enter a message to include in the Slack notification. Attachment Select the workbook content to export, then choose a file type. More options [optional] Select the Include link to workbook checkbox to allow channel members to open the workbook directly from the Slack message.
Export to a webhook
Create an action that exports an individual element’s data to another application with a webhook.
This action can only be configured and triggered by users assigned an account type with the Export to webhook permission enabled.
-
Open a workbook in Explore or Edit mode.
-
Select the element you want to trigger the action, then click Actions in the side navigation.
-
In the Actions panel, click Add action.
-
In the On select, On click, or On change modal (title depends on the type of trigger element), configure the required fields to define the response:
When selecting cells in Select a column from the trigger element to initiate the action when clicked.
This field only applies when the trigger element is a table, pivot table, or input table.
Condition [optional] Configure a condition that should be met for the action to take effect. Action Select Download and export. Destination Select Webhook. Endpoint Enter the receiving application’s endpoint. Attachment Select an element to export, then choose a data format.
Export to cloud storage
Create an action that exports an individual element’s data to cloud storage.
This action can only be configured and triggered by users assigned an account type with the Export to cloud permission enabled.
-
Open a workbook in Explore or Edit mode.
-
Select the element you want to trigger the action, then click Actions in the side navigation.
-
In the Actions panel, click Add action.
-
In the On select, On click, or On change modal (title depends on the type of trigger element), configure the required fields to define the response:
When selecting cells in Select a column from the trigger element to initiate the action when clicked.
This field only applies when the trigger element is a table, pivot table, or input table.
Condition [optional] Configure a condition that should be met for the action to take effect. Action Select Download and export. Destination Select Cloud Storage. Storage integration Enter an integration name. Cloud Storage URI Enter a file path for the export destination. Element Select an element to export, then choose a file format. More options [optional] Select the Prefix file name with current date and time checkbox to include the export date and time (in ISO format) in the file name.
Updated 2 days ago