# Using Feeds with Google Sheets

## 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

{% hint style="info" %}
**Note**: If using IP restrictions, ensure [Google's IP ranges](https://support.google.com/a/answer/10026322?product_name=UnuFlow\&hl=en\&visit_id=638749025513300272-2991542976\&rd=1\&src=supportwidget0\&hl=en) are allowed
{% endhint %}

### 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

{% hint style="info" %}
**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.
{% endhint %}

For more information about Feed configuration options, see:

{% content-ref url="" %}
[](https://docs.halosecurity.com/docs/integrations/feeds)
{% endcontent-ref %}