Retrieve Findings and Import Them to Google Sheets

## **Retrieve Findings and Import Them to Google Sheets**

Learn how to retrieve all findings using the Cobalt API and import them to Google Sheets.


:::info
Use this document with our [Cobalt API documentation](https://docs.cobalt.io/en-us/articles/introduction-JKOScm86lp) to retrieve Cobalt findings for all pentests.

:::

Complete the following steps:

* Step 1: Get all findings
* Step 2: Import findings to Google Sheets
* Step 3: Visualize findings data

To use our API, you need a Cobalt account with membership in your organization. Your organization owner can create an account and [assign you as a member](https://docs.cobalt.io/en-us/articles/import-them-to-google-sheets-tWNRTnjEnQ#h-step-1-get-all-findings). Your organization owner is typically the user who interacts with the Cobalt Customer Success Manager (CSM).

## **What You Need**

* [Personal API token](https://docs.cobalt.io/en-us/articles/import-them-to-google-sheets-tWNRTnjEnQ#h-step-2-import-findings-to-google-sheets): `YOUR-PERSONAL-API-TOKEN`
* [Organization token](https://docs.cobalt.io/en-us/articles/import-them-to-google-sheets-tWNRTnjEnQ#h-step-3-visualize-findings-data): `YOUR-V2-ORGANIZATION-TOKEN`

## **Step 1: Get All Findings**

Retrieve all [findings](https://docs.cobalt.io/en-us/articles/findings-D4kEiuzfAW) of an organization with the following REST call:

```javascript
curl -X GET "https://api.cobalt.io/findings" \
  -H "Accept: application/vnd.cobalt.v2+json" \
  -H "Authorization: Bearer YOUR-PERSONAL-API-TOKEN" \
  -H "X-Org-Token: YOUR-V2-ORGANIZATION-TOKEN" \
  | jq .
```

## Click to view a sample response.

You should see output similar to:

```javascript
{
  "data": [
    {
      "resource": {
        "id": "vl_3sP2RCWWUajc3oRXmbQ4j9",
        "tag": "#PT3334_37",
        "title": "XSS vulnerability",
        "description": "Cross-Site Scripting (XSS) attacks are a type of injection, in which malicious scripts...",
        "type_category": "Cross-Site Scripting (XSS)",
        "labels": [
          {
            "name": "Your label"
          }
        ],
        "impact": 5,
        "likelihood": 4,
        "severity": "high",
        "affected_targets": [
          "https://example.com",
          "192.168.1.1"
        ],
        "proof_of_concept": "Here you can see...",
        "severity_justification": "The vulnerability can cause a lot of damage",
        "suggested_fix": "Ensure this...",
        "prerequisites": "Credentials are needed",
        "pentest_id": "pt_PEtv4dqnwGV2efZhLw3BM5",
        "http_request": "HTTP GET / ...",
        "asset_id": "as_HcChCMueiPQQgvckmZtRSd",
        "log": [
          {
            "action": "created",
            "timestamp": "2021-04-01T15:13:24.322Z"
          },
          {
            "action": "likelihood_changed",
            "value": 4,
            "timestamp": "2021-04-01T15:14:05.856Z"
          },
          {
            "action": "impact_changed",
            "value": 5,
            "timestamp": "2021-04-01T15:14:05.856Z"
          },
          {
            "action": "state_changed",
            "value": "need_fix",
            "timestamp": "2021-04-01T15:14:06.757Z"
          },
          {
            "action": "state_changed",
            "value": "check_fix",
            "timestamp": "2021-04-01T15:14:57.845Z"
          }
        ],
        "state": "check_fix",
        "created_at": "2022-09-26T18:35:18.759Z",
        "updated_at": "2022-09-26T18:36:57.462Z",
        "attachments": [
          {
            "id": "at_LA5GcEL4HRitFGCHREqmzL",
            "file_name": "rainbow.jpeg",
            "download_url": "https://s3.amazonaws.com/acmecorp/uploads/attachment/file/12345/rainbow.jpeg?something=1"
          }
        ]
      },
      "links": {
        "ui": {
          "url": "https://api.cobalt.io/links/eyJ0eXBlIjoic29tZXRoaW5nIiwib3JnU2x1ZyI6ImNvYmFsdCIsInBlbnRlc3RUYWciOiJz="
        }
      }
    }
  ],
  "pagination": {
    "next_page": "/findings?cursor=a1b2c3d4",
    "prev_page": "/findings?cursor=4d3c2b1a"
  }
}
```

For more information on each parameter, see our API reference documentation on how to [get all findings](https://docs.cobalt.io/en-us/articles/findings-D4kEiuzfAW#h-get-all-findings).

If the command is successful, you’ll see the following HTTP code:

| **Message** | **Meaning** |
|----|----|
| 200 OK | Findings for all pentests of an organization are returned. |

For a list of error codes, see the [Errors](https://docs.cobalt.io/en-us/articles/errors-UFbGWTD0Sf) section of our API reference.

## **Step 2: Import Findings to Google Sheets**

Now that you have findings data in JSON format, you can import it to the spreadsheet software of your choice.

As an example, let’s import findings to Google Sheets.


1. In Google Sheets, select **Extensions** > **Apps Script**.
2. Use the [Class UrlFetchApp](https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app) service to import raw findings data. Refer to the [Class SpreadsheetApp](https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app) reference for details.
3. Run the following script to download and import Cobalt findings. Replace YOUR-PERSONAL-API-TOKEN and YOUR-V2-ORGANIZATION-TOKEN with your values.

   ```javascript
   function FETCH_DATA() {
     var url = 'https://api.cobalt.io/findings';
     var params = { headers: {
       'Accept': 'application/vnd.cobalt.v2+json',
       'Content-Type': 'application/vnd.cobalt.v2+json',
       'Authorization': 'Bearer YOUR-PERSONAL-API-TOKEN',
       'X-Org-Token': 'YOUR-V2-ORGANIZATION-TOKEN'
     }}
     var sheet = SpreadsheetApp.getActiveSheet();
   
     var response = JSON.parse(UrlFetchApp.fetch(url, params)).data;
     sheet.appendRow(Object.keys(response[0].resource));
     response.forEach((i) => 
       sheet.appendRow(
         Object.entries(i.resource)
         .map(([key, content]) => { 
           if(key == 'labels') {
             return content.map(c => c.name).join(',');
           }
           if(key == 'affected_targets') {
             return content.join(',');
           }
           if(key == 'log') {
             return JSON.stringify(content);
           }
           return content;
         })
       )
     );
   }
   ```

## **Step 3: Visualize Findings Data**

After importing raw findings data, you can create charts to visualize data. Here are some examples for Google Sheets.

* **Sum of impact points per target**: Use a QUERY inside a spreadsheet. The request sums up Impact Points (column G) and groups them by Affected Targets (Column J): `=TRANSPOSE(QUERY('Raw Data'!B:J, "SELECT J, SUM(G) group by J " , 1))`
* **Chart representing severity**: In Google Sheets, select **Insert** > **Chart**, and select **Column I** as the data source.
* **Chart representing likelihood**: In Google Sheets, select **Insert** > **Chart**, and select **Column H** as the data source.
* **Chart showing the highest severity**: Use the following command:

  ```javascript
  =INDIRECT("'Raw Data'!B"&MATCH(MAX('Raw Data'!G:G),'Raw Data'!G:G,0))
  ```

The result may appear as shown in the image.

 ![](https://brainfish-storage-prod.s3-accelerate.amazonaws.com/uploads/8e42b09c-e27b-4b5a-ba0c-7a5ef138ea38/57904a67-1bdb-4e95-bedd-8bb104c59cc4/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIAUPPN5IL36DGGCY5R%2F20260425%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260425T123203Z&X-Amz-Expires=3000&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMn%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMiJIMEYCIQCCnlN6BdSGOGeJURt%2FBcTzsN6WRSZGEnQLsqvSlBxGaQIhANK8NeLXFRHUtuW%2FO2TeFjrTMyJqjGE%2Bq7pQmUSWroIJKuYFCJL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAhoMMzA4MTI1OTc1Mjg3Igwhkw%2FL4xY8oHk5wKoqugVeSI1H0jYEjx%2BSQ7D5ihTPUFwd77JWsenSlLxCQWyzkEjOoez1LoLQldnHk%2B%2F9NmvABV0LTkIjszKLZGiEWl8r%2FF9siwlf102qfAz0oApH3O5sgi8Bn8k1A8gjGrypEZnCdqTDWzSG2U5Zyn1Bu0Po1QHu42bWksg67fSw9zkQKEw7sI127iM0u8%2FOtvhxGoYnCrNYVKWGh0k3TFIkDOUAXaP75SNcOf%2FttShU38yKECnb2vbiabpdNHYZ3O6lpiEHTRlGxahD9EwyfFDXlXOWQmg5jFUJOyMAY9KsTbKlKAzPaIcLjmELXazI3mbyeoTj0hNAnCbwRl4xgLxMcHlg6pNeKk4Gprz96CgnQ5BsX7UQmOCSOSgtFjr%2FR5UbGb5F11GGoq9ihxTsAlLQYzItFeYwPkQWws8lOz2IgIe7nDj0YydQLms6Bu6qTgwklN%2B3aWg3sf%2BoYCTsrLkebu1AhI21U5w6xxfYq%2FXCDTmoJ%2FcdK9myA2j8iAej0ptYDn%2BcDJNtGxUEME%2BnIeHQ1adLnXTV2UEkdIO%2FjAWBwCxyLtYKv6zjIqhUy4qgsIsrvoSDAImz4gOvixBfPXjoV7RTs9cBxY2oyfYaP9oDxjjVOYYX75q8InzhKAQ9yjusid7MoeQVyVzZ5rypWjLDGsWVwAyZyrTsHlSw13J5bjtJqGww6BrwRnTNNsuRV6UaFiBeGeqXRmXeoqjFWblv7Ek82yIqRxqVHufrghcR1PpItVdZiHzQP3UI7cy0SZw08ncVGCE6OCSpKe95Lx5lTHPybopY%2FS0F2b%2FXdYgpZtww2tSiWv7dqrTlzraJwwWcU5IGkTuvHaXXy%2B%2Fz9XFsYZHW3xPYoi0tmA%2BGFK2BCPhAt6P%2BhEIDP%2BKyLdf4V4jLMwxDD9%2BOe4mTaITsWONDaFGGGcYwbxF4tOToazDt%2F7HPBjqPAX7jTtmWJtBaSrl5%2BESw1VM0FEA58a5oi6orA6yZCh8xVa4CaD6vnOAJNdLDT%2FiIJZgpgRQNLNXsIj2voOwr9nZK%2FU19gfTOPuPghBFISlMtHSB1jZCzIO8%2BXuKbgD2DpcXIrN5rWTFIoW56bFz8nH%2F%2F1i7uNUaebb5hjKJG8Q5T6cfiyNorT59rKY5nkosq&X-Amz-Signature=5cade82f47b9f8c9699f057664f328a7b6f0471783504c272491106a1752d299&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

You can control who can access your Macros and Google Sheets. Fine-tune to which parts of your data specific users have access. This allows you to generate live reports without inviting users to the Cobalt platform.

Import Findings to Google Sheets

Cobalt API Overview

Create a Personal Cobalt API Token

Get an Organization Token

Revoke Your Personal Cobalt API Tokens

Create or Modify an Asset

Cobalt API

How to get started with Cobalt

Getting Started

Risk Advisories

Assets are what we pentest

Asset Types

Create an Asset

Assets

Pentests

Overview

Asset Details

Pentest Details

Scope & Test Period

Preparation

Create a Pentest

Pentest Process

Pentest States

Coverage Checklist

Pentest Expectations

Set Up an In-House Pentest

Complete an In-House Pentest (For Pentesters)

In House Pentests

Finding States

Severity Levels

Remediate Findings

Findings

Customize Your Report

Co-branded Reports

Contents of a Pentest Report

Reports

Engagements Overview

Digital Risk Assessment

Secure Code Review

Engagements

Insights

Planning

Cobalt Methodologies Overview

Web Methodologies

API Methodologies

External Network Methodologies

Internal Network Methodologies

Mobile Methodologies

Cloud Configuration Review Methodologies

Cloud Pentest Methodology

Desktop Methodologies

AI/LLM Methodologies

Digital Risk Assessment Methodology

Secure Code Review Methodologies

Methodologies

Attack Surface Monitoring (ASM)

Attack Surface

DAST Scanner Overview

Best Practices

Integrations

Partial Scans: Reduced Scope

Scans

Sequence recorder

Targets

Target Authentication

Extra Hosts

Blackout Period

DAST Scanner

Account Overview

Account Settings

Password Best Practices

Sign In to Cobalt

Troubleshoot Sign-in Issues

User Account

Collaboration Overview

Collaborate on Pentests

Groups

Manage Pentest Collaborators

Manage Notifications

User Roles and Permissions

Collaboration

Organization Overview

Manage Users

Your Cobalt Contract

Configure SAML SSO

How to Configure SAML 2.0 for Cobalt 

SAML Migration: Update Your Configuration

SCIM Provisioning Setup Guide

Configure Organization Settings

Organization

Track Your Credits

Cobalt Credits

Cobalt PtaaS Tiers

Credits

Cobalt Integrations Overview

Troubleshooting

Create Jira tickets for Findings

Send email notifications for Findings from Outlook

Create GitLab tickets for Findings

Create GitHub tickets for Findings

HTTP Connector

Import Assets from Google Sheets

Map Cobalt Pentest Finding Severity to Jira Issue Priority

Modify Jira Issue Summary to contain Pentest Title

Create Azure DevOps Work Item for Findings

Send MS Teams notifications for Findings

How to Guides

Connect your applications

Integration Builder

Synchronize Cobalt Severity Levels with Jira

Push Cobalt Findings to Jira

Jira Cloud Integration

Jira Data Center Integration

Troubleshoot Your Jira Integration

Switching to a New Jira Instance

Integrate Jira with Cobalt

Slack

Microsoft Teams

Webhooks

DefectDojo

Kenna Security

Vanta

Carried Over Findings

Create Test Finding

Glossary

March 2026

February 2026

January 2026

November 2025 

August 2025

July 2025

June 2025

May 2025

April 2025

March 2025

January 2025

December 2024

November 2024

October 2024

September 2024

August 2024

July 2024

June 2024

May 2024

April 2024

March 2024

January 2024

What's New

Guide

Cobalt Product Documentation

Import Findings to Google Sheets

Share

Share

Import Findings to Google Sheets

Share

Share