🔌Google Sheets | Connection Details
ChannelMix
Connection Overview
Google Sheets is a widly used cloud-based spreadsheet application that allows users to create and collaborate using online spreadsheets in real-time and from any device.
Connection Authentication
You'll need a Google Account (work or personal) to use this ChannelMix connection. To grant ChannelMix permission to pull data from your Google Account via Google Sheets you'll just need to setup a connection in ChannelMix. The authentication is quick and easy at app.channelmix.com on the connect page.
Connecting a Google Sheet to ChannelMix allows data in your Google Sheet to automatically load into your data warehouse.
Profile Association and Values
This connection does not currently have profile values.
Each Google Sheet you would like setup in ChannelMix requires a request to help.channelmix.com so a support agent can help assist.
Connection Reporting Details
ChannelMix utilizes the Google Sheets API to return data a user has permission to view.
Connection Limitations
- Google Sheet tab names must have less that 32 characters (31 charaters MAX)
- Google Sheets will update once per day (in the morning) OR when a user manually refreshes the data in ChannelMix.
Connection FAQ
Time Zone Reporting
Time zones are not applicable for this source connection.
Standard Datasets
ChannelMix does have a standard Google Sheet format that we strongly recommend users take advantage of when loading data with this source. This standard dataset is automatically available in all appropriate dashboard templates and oneview datasets listed below. If you don't have access to ChannelMix's standard Google Sheet, please ask about it at help.channelmix.com.