ChannelMix API connection is built around the Google Sheets API. Use the following guides to help answer questions about ChannelMix's connection.
Connection Guide
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 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.
Checkout this article for a general overview of the connection process!
Each Google Sheet you would like setup in ChannelMix requires a request to help.channelmix.com so a support agent can help assist.
Profile Association and Values
This connection does not currently have profile values.
Required User Permission Levels
n/a
Data Guide
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.
ChannelMix Standard Google Sheet Templates
Data configurations that are not supported
- Blank header rows are not supported. Headers must be on row one with data starting on row two.
- Column headers must be unique.
- Inconsistent data stored in the same column. Columns that have inconsistent data types throughout the column will be stored as a string.