Using Feeds with Google Sheets

Integrate Halo Security data directly into Google Sheets for custom analysis and reporting of your attack surface data.

Feed Configuration

1. Navigate to Events → Feeds

2. Click the + icon to create a new Feed

3. Configure the Feed settings:

   1. Name: "Google Sheets Data" (or your preferred name)

   2. Type: Choose based on your needs:

      1. Assets: For attack surface inventory

      2. Targets: For monitored assets

      3. Events: For security events and changes

      4. Format: CSV

   3. Output: Basic

Note: If using IP restrictions, ensure Google's IP ranges are allowed

Google Sheets Integration

1. Create a new Google Sheet

2. In cell A1, enter the IMPORTDATA formula: =IMPORTDATA("https://api.halosecurity.com/feeds/[your-feed-id]?format=csv")

3. The sheet will automatically populate with your Feed data

Best Practices

• Create a dedicated sheet tab for the raw Feed data

• Use separate tabs for analysis and visualizations

• Remember that IMPORTDATA refreshes periodically (typically every hour)

• Consider using cell references instead of direct calculations on the IMPORTDATA range

Common Use Cases

• Asset Inventory Dashboard

  • Create pivot tables to analyze assets by domain

  • Track asset counts over time

  • Identify patterns in your attack surface

• Security Metrics

  • Calculate risk statistics

  • Track discovered assets by type

  • Monitor changes in your attack surface

• Custom Reports

  • Generate executive summaries

  • Create department-specific views

  • Build custom risk calculations

Troubleshooting

If your data isn't loading:

• Verify the Feed URL is accessible

• Ensure the CSV format is selected

• Check that the data size isn't exceeding Google Sheets limits

• Confirm your Feed URL includes the format parameter: ?format=csv

Note: Be cautious when sharing sheets containing Feed data, as they will provide live access to your security data. Consider using Google Sheets' sharing restrictions appropriately.

For more information about Feed configuration options, see:

Feeds