How can we help?

Google Sheets Integration Details

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.


Section Links

Requirements and Best Practices

Bring In Hosted Images Via URL Using 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.


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.1.png


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".2.png


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 source14.png


4. Select the desired Mapping4.png


5. Select your mapped Image Dimension from the Dimensions list5.png


6. Add the "dummy" Metric as a hidden Metric6.png


7. Once the widget is created, the images should show up in your table7.png

 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.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request