How can we help?

Integrating with Google Sheets

Ninjacat has a very strong integration with Google sheets. Any data that you can get into a Google Sheet can be included as a table in your NinjaCat report. There are many clever and automated ways to get data into a Google Sheet using apps such as Zapier and Supermetrics, opening the possibility to easily incorporate data from sources such as Pinterest, SalesForce, Zillo, etc.

Get started by attaching a Google sheets account in the Networks tab

Connecting a Google Sheets Network

1. Click on the Add Network button in your Networks tab and select Google Sheets.

2. Type a unique description to name this sheets connection

3. Open another tab in the same browser and log in to the Google Drive/Sheets account you wish to connect. 

4. Go back to the NinjaCat browser tab and click on the Add Network Account button 

5. You will automatically be directed to a Google permissions page to authorize NinjaCat and allow access 

6. Select Allow.

7. You will then be directed back to the Networks tab with your list of connected networks, where the Google sheets account you just linked will be displayed. 

Google Sheet Requirements and Best Practices

Your Google sheet should adhere to the following requirements:

  • Column headings must be in row 1.
  • Recommended limit of 10 columns total. This is not a hard/fast limitation, but if you have more than 10 columns the resulting table in your NInjaCat report will start to look very crowded.
  • 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.
  • Formatting (e.g. color, bold, text alignment) in your Google sheet will not carry through to your NinjaCat report. All cells will be center aligned unless otherwise specified (see below).
  • Cell alignment in tables:
    • You can explicitly control the text alignment of a field in a google sheets table by adding a modifier to the header row:
      • Header|left
      • Header|right
      • Header|center


Getting Data into a Google Sheet

There are many different ways of getting data into Google Sheets, in this example "Pinterest Pins by User Data" was brought in using a Google sheet add-on called Supermetrics. Data can also be imported to sheets using hundreds of Zapier Zaps.

Once you have your data in sheets it will look something like this example below.  

Google Sheet with Pinterest Data: Figure 1



Adding the Google Sheets Widget to Your Template


Once your Google Sheets network is established, your can work with the Google Sheets template widget.

  1. From the Templates tab the Google Sheets widget can be found under Miscellaneous Widgets.
  2. Under the Table section of the widget, select the Network, the Google Sheet, and specify the worksheet tab.

Google Sheet Report Template: Figure 2

Once the template is saved and the report is run, the Google sheets data from figure 1, will look like this in figure 3. 

Report Table Containing Pinterest Data from Sheets Integration: Figure 3

If the sheet is updated and the report is re-run, the sheets data will update in the report. 


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


Please sign in to leave a comment.