# Integrations Detail Views

**URL:** <https://connective.celigo.com/t/integrations-detail-views/692>\
**Category:** Integrator.io\
**Tags:** snowflake, google-sheets, export, integration-app\
**Created:** [August 8, 2022, 3:12pm UTC](https://connective.celigo.com/t/integrations-detail-views/692 "2022-08-08T15:12:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mahsaebad](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@mahsaebad](https://connective.celigo.com/u/mahsaebad)\
**Post date:** [August 8, 2022, 3:12pm UTC](https://connective.celigo.com/t/integrations-detail-views/692/1 "2022-08-08T15:12:34Z")

</div>

Hi team,

We're looking for a way to grab the list of all integrations and underlying flows and corresponding details for each flow to better track them. I was wondering:

1- How we can export this data into gsheet or csv file? it is possible to grab the list of all integrations --\> flows --\> connections as a gsheet?

2- Can we access this data as a table in Snowflake? basically the list of all integrations, flows and connections as a table

3- Is there any way to automate/visualize it?

---

<div class="post-metadata">

**Author:** ![kathyanaqueeman](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kathyanaqueeman/32/9122_2.png) [@kathyanaqueeman](https://connective.celigo.com/u/kathyanaqueeman)\
**Post date:** [August 19, 2022, 5:24pm UTC](https://connective.celigo.com/t/integrations-detail-views/692/2 "2022-08-19T17:24:36Z")

</div>

HI @mahsaebad,

I'm aware that someone responded to you via email, but I'm posting the response here as well for other users that might have the same question:

Our automation platform is designed to cater to such use cases. As a starting point, here are articles that can help you build this automation using our connectors: 

- **Export the list of integrations, flows, or connections in your account** – We have a [connector for integrator.io](https://docs.celigo.com/hc/en-us/articles/360038520652-Set-up-a-connection-to-integrator-io). You can extract a list of resources like flows, connections, etc using this connector.
- **Push this data to Snowflake** – You can create a [Snowflake import](https://docs.celigo.com/hc/en-us/articles/360049317752-Import-data-into-Snowflake) to accomplish this task.
- **Create a GSheet import** – We have a [connector for Google Sheets](https://docs.celigo.com/hc/en-us/articles/360057234491-Set-up-a-connection-to-Google-Sheets) to import the data easily.

Separately, you can also extract this data through the integrator.io REST API. You can export the raw JSON [integration](https://docs.celigo.com/hc/en-us/articles/7708333454747-Integration-API-endpoints), [flow](https://docs.celigo.com/hc/en-us/articles/7707985934363-Flow-API-endpoints), and [connection](https://docs.celigo.com/hc/en-us/articles/7707491444763-Connection-API-endpoints) data and add it to Snowflake as a [variant data type](https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html) instead of converting it into rows/columns in a CSV file first. This is a popular method with Snowflake ([ELT vs. ETL](https://www.snowflake.com/guides/etl-vs-elt)).

Please feel free to reach out if you have any other questions!