There are so many sources of data that don't provide direct, software API connections. You are probably using at least one. If you've got data but are in need of a way to get it to NinjaCat we can help. If you can get your data into a Google Sheet we can read that sheet and make that data available for Reports and Dashboards. Sign in to your Google Drive through our data connector and the connector will only see the Sheets in the drive. Then you direct NinjaCat to the specific data you need to pull by using what we call a "Mapping". This article is documentation of some of the details of this integration.
NinjaNote: For a "How To" on setting up a Google Sheets connection follow the instructions in this article; Setting Up Google Sheets.
Requirements and Best Practices
- Column headings must be in row 1.
- No blank or skipped rows. Your NinjaCat report will include consecutive rows in a Google sheet up until the first row with no content in the first cell/column.
- Data formatting designations should be accurate in the Google Sheet before being brought into NinjaCat (e.g. Date data formatted as Date, Numeric data formatted as Number, Text string data formatted as Text)
- Formatting (e.g. color, bold, text alignment) in your Google sheet will not carry through to your NinjaCat report.
- Google Sheet Restrictions (as per Google):
- Google spreadsheets format can’t be larger than 20 MB
- Needs to be under 400,000 cells
- Needs to be under 256 columns per sheet
- As far as we know (at this point) there is no max number of NinjaCat mappings that can be made to a single Google Sheets Custom Network
Bring In Hosted Images Via URL Using Google Sheets
It is possible to bring images into your template and report via a google sheet. The image must be stored on an internet-accessible server. The image must be publicly accessible and able to be loaded using a URL.
Google Sheet Setup
1. The sheet should have one column for the links that lead to a hosted image and at least one other column for a "dummy" metric that will be used to bring in the image data but doesn't need to contain any valid data.
2. Follow the steps in the article Setting Up Google Sheets to create a Mapping for the sheet that contains the image links. When mapping the Image Link column set the "Display As" field to "Image".
Access In Template Builder
1. Access the NinjaCat Template Builder
2. In order to bring in an Image from a Google Sheet, a table widget must be used.
3. Select "Google Sheets" as the data source
4. Select the desired Mapping
5. Select your mapped Image Dimension from the Dimensions list
6. Add the "dummy" Metric as a hidden Metric
7. Once the widget is created, the images should show up in your table
NinjaNote: The data result of the table can be limited and the style of the table can be altered to create the ideal display of your image.