Export to Google Drive





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.

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 Sheets, 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 scheduler 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. 

Setup a Schedule

1. Open the Worksheet you would like to export.

2. If it is in 'Edit' mode, click the  publish button in the top right of the screen.

3. Click the ••• on the top right of the screen.
   
   

4. Click 'Schedule’ in the menu to open the Schedule Manager modal.

5. Click 'Add Schedule'.

   
   

6. Under ‘Select channel’ choose ‘Google Drive’.

7. If you have not already authorized Sigma to export to your Drive, you will be prompted to do so at this time.

8. Under ‘Google Drive Folder’, type your new folder name and click ‘Create Folder’. Check out Creating a Destination Folder to learn more.
   
   
   
   
9. Select the frequency and time of day to export the snapshot of the Worksheet.
   
   
   
   
10. Click ‘Save’.
    
    

Send Now - How to Send your Scheduled Export at any Time

1. Click the ••• on the top right of the worksheet.

2. Click 'Schedule’ in the menu to open the Schedule Manager modal.

3. Click the ••• to the right of the schedule you would like to edit.

4. Click ‘Send Now’ to immediately export the worksheet to your folder.


Edit/Delete your Schedule

1. Click the ••• on the top right of the Worksheet.

2. Click 'Schedule’ in the menu to open the Schedule Manager modal.

3. Click the ••• to the right of the schedule you would like to edit.

4. Click 'Delete' to delete the schedule or 'Edit' to make changes to the schedule.


Related Articles

Send or Schedule Reports

Export to Google Sheets