> For the complete documentation index, see [llms.txt](https://docs.halosecurity.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.halosecurity.com/docs/integrations/feeds/using-feeds-with-google-sheets.md).

# 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="/pages/XJhvmApgXJIxJCZ1CTJ3" %}
[Feeds](/docs/integrations/feeds.md)
{% endcontent-ref %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.halosecurity.com/docs/integrations/feeds/using-feeds-with-google-sheets.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.