Skip to main content

Google Sheets Integration Details

Google Sheets Integration Details

Daniel
  • Updated

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.
  • 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.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".1.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 source13.png

 

4. Select the desired Mapping3.png

 

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

 

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

 

7. Once the widget is created, the images should show up in your table6.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.

 

 

Related articles

Comments

0 comments

Article is closed for comments.