Export to email

You can send workbooks, their pages, and individual elements to email recipients on a set schedule or as-needed basis. For example, you can email an executive team member a PDF illustrating the team's KPIs on a regular basis.

A workbook can support multiple schedules, and each email can support multiple attachments, up to the export file size limit. Attachment file type options (PDF, Image, CSV, and Excel) vary by attachment type.

You can select either a published workbook or a tagged version of a workbook to send in email.

If you use email export while in draft mode, or while exploring, the export contains the latest published or tagged version. Changes you make to drafts or explorations cannot be exported to email until you publish them.

Exports only display the data that the recipient has access to based on their permissions. Recipients must be Sigma users.

This document describes how to schedule and send workbook exports using email destinations.

Requirements

• To use this feature, you must:
  • Be assigned an account type with the appropriate sharing and export permissions.
  • Have Can Edit or Can Explore access to the individual workbook.
• To send a version-tagged workbook, the version tag must exist and be applied to the workbook. Admins can create a version tag, and workbook creators can tag a version of a workbook. For more information see Version tagging.

Export limits

The size limit for emailed exports is 30MB. This is the total limit for all attachments when combined.

If an export exceeds this limit, the entire export fails and the email's recipient is notified. Scheduled exports that repeatedly exceed this limit are automatically paused and their owner notified.

Export to email as needed

To send an ad hoc email export:

1. Click the workbook header title menu ().

2. Select Send now.

   📘

   This option is only available from a workbook's latest published or tagged version. If the menu item is disabled, 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 send an email.

   The Send Now modal opens, with email as the default destination.

   

3. In the To field, enter up to 1,000 comma-separated recipient email addresses.

   📘

   If export authentication is configured for your organization, you can only send the export to email addresses associated with an authorized domain. When you attempt to send the export, Sigma notifies you if an email address contains a domain that is not allowed.

4. (Optional) In the Subject field, enter a subject line.

5. (Optional) In the Email Body field, enter a message.

6. If the workbook has versions or bookmarks, select which one you want to send. If you send a bookmark, you can only export a PDF file or an image.

7. Select one or more attachments from the Attachment menu. The options are:

   • Entire workbook exports all the workbook's pages.
   • By workbook page. Sigma lists all the pages in the workbook. For each page's submenu, you can export the Entire page or select an element on the page.

8. In the Format as dropdown select a file format.

   • For an entire workbook, use PDF and choose either a portrait or landscape Layout.
   • For an individual page, select either PDF or Image.
   • For an individual element, select either PDF, CSV, Excel, or Image.

     📘

     CSV and Excel attachments export as raw data. You cannot export bookmarks as raw data.

9. (Optional) To add additional attachments, click + Add another attachment and repeat the previous step.

10. (Optional) If you select more than one Excel attachment, you can export them as one Excel file with each element in its own tab. Select Merge Excel files.

11. (Optional) By default, Sigma includes a link to the workbook in the email body. If you don't want that link to be included, deselect the Include workbook link checkbox.

12. (Optional) By default, exports capture data accessible to the export creator. To limit the exports to only display what the recipient has permission to view, select Run queries as recipient.

    📘

    This feature only works for Sigma users. If the recipient is not a Sigma user and this option is checked, the email fails to send. The sender of the export receives a failure notification email with the error message: "No users found in organization for the provided email recipients".

    💡

    When an export is run as recipient, each query runs separately per recipient. Larger recipient lists will result in more queries sent to the database and longer processing times.

13. Click Send.

Schedule an emailed export

Scheduled emails send the latest published version of the workbook, unless you select a tagged version.

To schedule an emailed report:

1. From the workbook header menu (), select Schedule exports.
   The Schedule Exports modal opens.

2. Depending on whether a scheduled export already exists, click New schedule or Add schedule.

   A Schedule Exports form opens with a new schedule selected. The Destination field defaults to Email.
   

3. Enter a Schedule Name to identify the scheduled export.

4. In the To field, enter up to 1,000 comma-separated recipient email addresses.

   📘

   If export authentication is configured for your organization, you can only send the export to email addresses associated with an authorized domain. When you attempt to create the schedule, Sigma notifies you if an email address contains a domain that'ss not allowed.

5. (Optional) In the Subject field, enter a subject line.

6. (Optional) In the Email Body field, enter a message.

7. Scroll down to see the additional options of how and when to send the exported content.
   

8. If the workbook has versions or bookmarks, select which one you want to send. If you send a bookmark, you can only export a PDF file or image.

9. Select one or more attachments from the Attachment menu. The options are:

   • Entire workbook exports all the workbook's pages.
   • By workbook page. Sigma lists all the pages in the workbook. For each page's submenu, you can export the Entire page or select an element or data source on the page.

10. In the Format as dropdown, select a file format:

    • For an entire workbook, you can choose either:
      • Select PDF and choose a Layout of either portrait or landscape.
      • Select Excel.
    • For an entire individual page, select PDF, Image, or Excel.
    • For an individual element, select PDF, CSV, Excel, or Image.
    • For a data source, select PDF, CSV, Excel, PDF, or Image.

    📘

    CSV and Excel attachments export as raw data. You cannot export bookmarks as raw data.

11. (Optional) To add additional attachments, click + Add another attachment and repeat steps 9 and 10.

12. (Optional) If you select more than one Excel attachment, you can export them as one Excel file with each element in its own tab. Select Merge Excel files.

13. (Optional) By default, Sigma includes a link to the workbook in the email body. If you don't want that link to be included, deselect the Include workbook link checkbox.

14. (Optional) By default, exports capture data accessible to the export creator. To limit the exports to only display what the recipient has permission to view, select Run queries as recipient.

15. (Optional) By default, exports capture data accessible to the export creator. To limit the exports to only display what the recipient has permission to view, select Run queries as recipient.

    📘

    This feature only works for Sigma users. If the recipient is not a Sigma user and this option is checked, the email fails to send. The sender of the export receives a failure notification email with the error message: "No users found in organization for the provided email recipients".

    💡

    When an export is run as recipient, each query runs separately per recipient. Larger recipient lists will result in more queries sent to the database and longer processing times.

16. Set the delivery schedule.

    • For Repeat by, select a schedule option: Day/Week, Month or Custom.
    • From the Timezone, select a time zone.
    • Setting a schedule's frequency depends on the Repeat by selection.
      • Day/Week: pick the schedule's day or days of the week (On days), how often on a day (Occurrence) and time of day (At).
      • Month: Select the Day of month (1-31) and time (At).
      • Custom: Enter a raw cron string value. For more information see Set up a custom delivery schedule.

17. (Optional) Select one or more workbook controls to apply to the exported content. For more information, see Apply control values to scheduled reports.

    • In the search box below Controls, search for and select the control by control ID.
    • Select the control value(s) to apply to the scheduled export.
    • Repeat this step to add additional controls.

18. (Optional) You can define conditions for when Sigma sends the export. For more information see Schedule exports using conditions.

19. Click Create Schedule.