Google Sheets deliveries
With Google Sheets deliveries, you can automatically schedule sending individual tiles to Google Sheets.
Setup
To use Google Sheets as a destination, you'll need an existing Google Sheet workbook that you have write access to. This sheet should be blank as Omni includes column headers in the delivery.
When connecting your Google Drive account to Omni, be sure you grant Omni all requested permissions or deliveries will fail.
Write modes
The Write mode setting defines how Omni writes data to the specified sheet:
-
Overwrite the data on a sheet - Data in the sheet is overwritten on each successful delivery, including column headers
-
Append the data on a sheet - On every successful delivery, new results are added to the specified sheet starting with the first empty row
-
Create a new sheet for each delivery - Creates a new sheet in the workbook for each successful delivery
Delivering pivoted data
If your query contains pivoted data, there are a few things to consider when configuring a delivery to Google Sheets. In a typical table, column order doesn't usually have to be strictly maintained to retain the accuracy of the data. In pivoted data, however, the data's column structure is directly tied to the position of its pivot dimensions.
To ensure the data that Omni delivers is accurate, only the Overwrite and Create new sheet options are supported for delivering pivoted data:
- If creating a new schedule and Omni detects pivoted data in the query, the Append option will be unavailable
- If editing a schedule and Omni detects that the query has changed to include pivoted data, it will change the write mode to Overwrite