Sigma’s Google Drive Export feature allows you to easily schedule exports of your Sigma Worksheets to a folder on your Google Drive. Each export will create a new Sheet without overwriting any of its predecessors.
Summary of Content
The Power of Snapshots
Authorizing Sigma to Export to your Google Drive
Creating a Destination Folder
What to Expect from your Scheduled Export
Set up a Schedule
Send Now - How to Send your Scheduled Export at any Time
Edit/Delete your Schedule
Related Documentation
The Power of Snapshots
By generating a new Sheet on each export, this feature allows your team to create a snapshot history of reports in a central location for future reference and easy sharing.
You can leverage this report history to track and reflect on data changes and business decisions over time.
If you would prefer to rewrite over a single Sheet on each export, check out Export to Google Sheets.
Authorizing Sigma to Export to your Google Drive
The first time you schedule an export to Google Drive, you will be prompted to authorize Sigma to export to your Drive. Click 'Authorize' and follow the instructions on your screen.
After completing authorization, you will be redirected back to Sigma’s Scheduled Exports modal.
Creating a Destination Folder
When setting up a schedule, you will be asked to create a destination folder directly from Sigma’s scheduler modal. This new folder will be created directly in your authorized Google Drive.
To create this folder, please enter a new folder name under the heading ‘Google Drive Folder’ and click 'Create Folder '. You can rename the folder at any time in Google Drive without it impacting your schedule.
We will then provide you a direct link to your new folder.
*Please note - each schedule will be associated with the Google Drive of the original scheduler.
What to Expect from your Scheduled Export
Every time your scheduled export runs, a new timestamped Google Sheet will automatically be created in your destination folder.
Each Sheet will be named as follows: "<Export Timestamp> - <Sigma Document Name>”.
The export limit is 150k rows of data, and any columns that have been grouped into levels will be flattened.
Set up a Schedule
-
Open the Worksheet you would like to export.
-
If it is in 'Edit' mode, click the
publish button in the top right of the screen. -
Click the ••• on the top right of the screen.
-
In the menu under 'Data Export’, select 'Schedule...' in the menu to open the Scheduled Exports modal.
-
If this is the dashboard's first schedule, click 'Add Schedule'.
If schedules already exist, you will see them listed. Click '+ New Schedule'
-
Under Destination choose ‘Google Drive’.
-
If you have not already authorized Sigma to export to your Drive, you will be prompted to do so at this time.
- Under Google Drive Folder, type your new folder name and click ‘Create Folder’. Check out Creating a Destination Folder to learn more.
- Under Repeat by, select the frequency and time of day to export the snapshot of the worksheet.
-
[optional] Under Send you may choose to specify delivery conditions. For each scheduled delivery, the export/notification will only be sent if this condition is met. Learn more about conditional scheduling.
- Click ‘Create Schedule’.
Send Now - How to Send your Scheduled Export at any Time
-
Click the ••• on the top right of the worksheet.
-
In the menu under 'Data Export’, select 'Schedule...' in the menu to open the Scheduled Exports modal.
-
Click the ••• to the right of the schedule you would like to edit.
-
Click ‘Send Now’ to immediately export the worksheet to your folder.
Edit/Delete your Schedule
-
Click the ••• on the top right of the Worksheet.
-
In the menu under 'Data Export’, select 'Schedule...' in the menu to open the Scheduled Exports modal.
-
Click the ••• to the right of the schedule you would like to edit.
-
Click 'Delete' to delete the schedule or 'Edit' to make changes to the schedule.