Export to Slack

If Slack notifications are enabled for your organization, workbooks, their pages, and individual elements can be sent to any channel in your Slack account on a set schedule or as-needed basis.

For example, you might want to provide a weekly uptime report to your management team, but your team communicates primarily in Slack. You can set up an export to a Slack channel or a specific user to make sure your management sees the report.

You can set multiple schedules for a workbook, and you can select either a published workbook or a tagged version of a workbook to export.
Changes you make to drafts or explorations cannot be exported until you publish them.
For a matrix of supported file formats, see Available export destinations and formats.

Slack exports capture data accessible to the user who initiated the export.

This documentation describes how to send and schedule exports to Slack.

User requirements

The ability to export to Slack requires the following:

Export size limit

The size limit for exports to Slack is 1GB per file. See Download, export, and upload limitations.

Send an ad hoc notification

To export information from a workbook to Slack:

  1. From the workbook menu caret icon, select Export.

    πŸ“˜

    If the Slack option is not available, the workbook is in Edit mode. Either publish your draft or return to the latest published or tagged version of the workbook before attempting to export.

  2. Select Slack.

  3. In the To field, enter the name of the Slack channel, for example, #team-channel.

    If you want to send the notification to a private channel, you must first add the Sigma notifications bot to the channel. Enter @Sigma in your private channel to enable it. See Adding Sigma to a private Slack channel.

  4. (Optional) Enter a message in the Message field.

    You can notify individuals by user ID. Get the Slack member ID for the user from their Slack user profile, then use the syntax @<user_id> in the message. The angle brackets are required.

    slack-user-id.png

    You can also useΒ Slack channel @ mentions, such as @here or @channel, to notify people in the Slack channel when the notification is delivered.

  5. If the workbook has versions or bookmarks, select which one you want to send.

  6. In the Attachment section, choose what you want to export as an attachment. You can export:

    • An Entire workbook and export all workbook pages.
    • A specific workbook page, by navigating to the workbook page and choosing Entire page.
    • An element on a specific workbook page, by navigating to the workbook page and choosing the name of the element.

    Select + Add to add more attachments.

  7. For each attachment, select a supported file format. For a matrix of supported file formats, see Available export destinations and formats.

    If you export multiple elements as Excel attachments, you can choose to export them as one Excel file with each element in its own tab. In More Options, select the checkbox for Merge Excel files.

    Each attachment arrives in Slack as a separate message, except for merged Excel files.

  8. (Optional) To include a link to the workbook in the message body, select the checkbox for Include workbook link.
    Exports to Slack capture data accessible to the member who initiated the export. If a user clicks the workbook link, Sigma only displays what that individual user has permission to view.

  9. Click Export.

Schedule a Slack notification

Sigma generates exports from the workbook's latest published version. Draft changes are not sent unless they are published.

To schedule an export to Slack notification:

  1. From the workbook menu caret icon, select Schedule exports....

  2. If this is the first schedule for the workbook, click Add Schedule, otherwise click + New schedule.

  3. (Optional) You can define conditions for when Sigma sends the export. To turn on conditions, click the Condition toggle. For more information, see Schedule exports using conditions.

  4. SelectΒ Slack.

  5. In the To field, enter the name of the Slack channel, for example, #team-channel.

    If you want to send the notification to a private channel, you must first add the Sigma notifications bot to the channel. Enter @Sigma in your private channel to enable it. See Adding Sigma to a private Slack channel.

  6. (Optional) Enter a message in the Message field.

    You can notify individuals by user ID. Get the Slack member ID for the user from their Slack user profile, then use the syntax @<user_id> in the message. The angle brackets are required.

    slack-user-id.png

    You can also useΒ Slack channel @ mentions, such as @here or @channel, to notify people in the Slack channel when the notification is delivered.

  7. In the Attachment section, choose what you want to export as an attachment. You can export:

    • An Entire workbook and export all workbook pages.
    • A specific workbook page, by navigating to the workbook page and choosing Entire page.
    • An element on a specific workbook page, by navigating to the workbook page and choosing the name of the element.

    Select + Add to add more attachments.

  8. For each attachment, select a supported file format. For a matrix of supported file formats, see Available export destinations and formats.

    If you export multiple elements as Excel attachments, you can choose to export them as one Excel file with each element in its own tab. In More Options, select the checkbox for Merge Excel files.

    Each attachment arrives in Slack as a separate message, except for merged Excel files.

  9. In the Frequency section, set the delivery schedule:

    • (Optional) Select the dropdown for Daily and select Weekly, Monthly, or Custom.

      • For Daily, select Once a day or Multiple times.

      • For Weekly, select which days of the week to send an email, and choose between Once a day or Multiple times.

      • For Monthly, select which day of the month to send an email, and the time of day.

      • For Custom, specify a schedule using cron syntax. See Set up a custom delivery schedule.

        If you select Multiple times, specify the frequency. For example, every 2 hours on the :15 of the hour between 9 AM and 6 PM.

    • (Optional) Adjust the default schedule time zone using the dropdown menu.

  10. (Optional) To include a link to the workbook in the message body, select the checkbox for Include workbook link.
    Exports to Slack capture data accessible to the member who initiated the export. However, if a user clicks the workbook link, Sigma only displays what that individual user has permission to view.

  11. (Optional) Select the checkbox for Customize control values to filter the exported data according to the value of one or more workbook controls. See Apply control values to scheduled reports.

  12. Click Create.