trivy-to-google-sheets 0.3.0

A tool to run Trivy scans and export results to Google Sheets

Trivy to Google Sheets

trivy-to-google-sheets is a Python package that automates running Trivy scans on container images and exporting the results to a Google Sheet. It also automatically shares the generated sheet with specified emails and can be used as a command-line tool.

Features

Run a Trivy scan on a Docker container image.

• Export Trivy scan results directly to Google Sheets.
• Automatically create a new Google Sheet if it doesn't exist.
• Share the created Google Sheet with multiple users via email.
• Use the package via CLI for quick access.

Installation

Install the package from PyPI:

pip install trivy-to-google-sheets

Usage

Environment Variables

Before running the script or using the CLI tool, ensure the following environment variables are set:

• GOOGLE_SHEETS_CREDS: Path to your Google service account credentials JSON file.
• WORKSHEET_NAME: (Optional) Name of the Google Sheet worksheet (tab) where the data will be inserted. Default - default-trivy-name
• SPREADSHEET_NAME: (Optional) Name of the Google Sheet - Default -trivy-vulnerabilities-spreadsheet
• SHARE_EMAILS: Comma-separated list of emails to share the Google Sheet with.

Example

export GOOGLE_SHEETS_CREDS=/path/to/credentials.json
export WORKSHEET_NAME="vulnerability-scan"
export SHARE_EMAILS="[e-mail],[e-mail]"

Running the Script Programmatically

You can run the script directly in Python by initializing the TrivyToGoogleSheets class:

from trivy_to_google_sheets import TrivyToGoogleSheets

# Initialize the process
trivy_gsheet = TrivyToGoogleSheets(image_name="your-container-image")
trivy_gsheet.run()

Using as a Command-Line Tool

After installing the package, you can use the trivy-to-google-sheets command directly in your terminal.

trivy-to-google-sheets your-container-image

Google Setup