# How to get the most out of Coupler.io

Coupler.io is a data integration platform that lets you collect data from 400+ sources, organize it into analysis-ready datasets, and load it into spreadsheets, data warehouses, BI tools, and AI tools. Here's what you can do with Coupler.io:

* [x] Create automated data flows from sources to destinations
* [x] Build multi- and cross-channel reports by blending data from multiple sources
* [x] Get ready-to-use reports using the data set and dashboard templates 
* [x] Analyze data conversationally with AI Agent or external AI tools 

The table below gives you a quick overview of the platform's key capabilities. Each one is covered in detail further in this article.

<table><thead><tr><th width="197.0078125">Capability</th><th width="255.1875">What it does</th><th>Key details</th></tr></thead><tbody><tr><td><strong>Data sources</strong></td><td>Collect data from cloud apps, databases, and files</td><td>400+ supported sources across marketing, sales, CRM, finance, and more</td></tr><tr><td><strong>Transformations</strong></td><td>Shape data before loading — filter, sort, add columns, summarize</td><td>Column management, custom formulas, aggregation</td></tr><tr><td><strong>Data blending</strong></td><td>Combine data from multiple sources into one view</td><td>Append (similar structures) or Join (different structures)</td></tr><tr><td><strong>Data set templates</strong></td><td>Get preconfigured data sets for common use cases</td><td>Select a template, connect a source, and the data set is ready</td></tr><tr><td><strong>Destinations</strong></td><td>Load data to the tools you work in</td><td>Google Sheets, Excel, BigQuery, PostgreSQL, Looker Studio, Power BI, ChatGPT, Claude, and more</td></tr><tr><td><strong>Import modes</strong></td><td>Control how data is updated at the destination</td><td>Replace or Append (spreadsheets and warehouses only)</td></tr><tr><td><strong>Automated refresh</strong></td><td>Keep destination data in sync with sources</td><td>Schedules up to every 15 minutes</td></tr><tr><td><strong>Webhooks</strong></td><td>Trigger or respond to external events</td><td>Incoming (trigger a run) and outgoing (notify on completion)</td></tr><tr><td><strong>AI analytics</strong></td><td>Get answers from your data through conversation</td><td>AI Agent (built-in) + AI tool destinations</td></tr><tr><td><strong>Dashboard templates</strong></td><td>Instant visualizations with no manual setup</td><td>Native Coupler.io dashboards + templates for Looker Studio, Power BI, Tableau, Google Sheets</td></tr><tr><td><strong>Incremental fetching</strong></td><td>Pull only new or changed data</td><td>Reduces load times and API usage</td></tr><tr><td><strong>Macros</strong></td><td>Automate sequences of actions</td><td>Chain multiple data flow operations</td></tr></tbody></table>

***

### Collect data from 400+ sources

Every data flow starts with connecting a data source. Coupler.io supports 400+ apps and services across marketing, sales, CRM, finance, accounting, databases, and cloud drives.

You can connect a source once you've created a data flow or by using the Sources item in the left-side panel.

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FvrSKwcBxnqYoU77Dx00S%2Fimage.png?alt=media&#x26;token=4d1163f0-38c6-4386-a51c-04746a2603e7" alt="" width="375"><figcaption></figcaption></figure></div>

Select a source app and authenticate. For most sources, you just log in to your account.&#x20;

Some sources require specific connection details like a URL or database credentials.

Once connected, configure what data to pull. The options depend on the source. For example:

* **GA4**: select properties, specify the report period, pick metrics, and dimensions
* **QuickBooks Online**: select a data entity
* **Google Ads**: choose the report type, date range, and fields

You can add multiple sources to a single data flow. This is useful for **multi-channel reporting**, e.g., combine data from several ad platforms, or **cross-channel reporting**, e.g., merge GA4 with Google Search Console to analyze URL performance in one place.

<figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FRADMHQn22RPyZotuRBMu%2Fimage.png?alt=media&#x26;token=ec7bf647-317f-4e02-b6bf-ddf6c1a4486d" alt=""><figcaption></figcaption></figure>

***

### Organize raw data into an analysis-ready data set&#x20;

After connecting sources, Coupler.io preloads up to 500 rows of your data. You can preview data from each connected source separately. Use this to verify the data structure and spot any issues before running the export.

#### Basic transformations

Coupler.io offers several transformation options within the data flow:

**Column management** — hide columns you don't need, rename them, reorder, or change the column type. Supported types: string, number (integer, decimal, percent, currency — with precision control), date, and datetime.

**Filtering** — set criteria to include only the rows you need.

**Sorting** — order data by one or more columns.

**Custom columns** — add new columns with calculated values using formulas.

#### Data blending and aggregation

In addition to the basic column-level transformations, Coupler.io enables you to reshape your data via aggregation or combining multiple sources.

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-cover data-type="image">Cover image</th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Append</strong></td><td><em>stacks data from sources with a similar structure. Columns are matched by name</em></td><td><a href="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FllzmZUSG9FTgwIX5lkQ6%2FScreenshot%202026-02-17%20at%2012.44.08.png?alt=media&#x26;token=4780b931-cd34-45e1-ad6c-e122aa1ce3b6">Screenshot 2026-02-17 at 12.44.08.png</a></td><td><a href="../functionality/data-set/combining-data/append-data">append-data</a></td></tr><tr><td><strong>Join</strong></td><td><em>merges data from sources with different structures. You select one or more shared columns to link the data sets</em></td><td><a href="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2F0fomNdyKmn7nvMWvwHIJ%2FScreenshot%202026-02-17%20at%2012.41.23.png?alt=media&#x26;token=22385e43-f5c9-497d-ad0d-4f33609305c4">Screenshot 2026-02-17 at 12.41.23.png</a></td><td><a href="../functionality/data-set/combining-data/join-data">join-data</a></td></tr><tr><td><strong>Aggregate</strong> (summarization)</td><td><em>calculates summary values across rows using sum, average, count, min, or max</em></td><td><a href="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FMN5WdIEfQGA6Zm5JExht%2FScreenshot%202026-02-17%20at%2012.44.41.png?alt=media&#x26;token=a1f32261-a409-4506-a9d2-6bb4c0cd72d4">Screenshot 2026-02-17 at 12.44.41.png</a></td><td><a href="../functionality/data-set/combining-data/aggregate-data">aggregate-data</a></td></tr></tbody></table>

{% hint style="info" %}
Unlike Append and Join, Aggregate doesn't require multiple sources. You can aggregate a single data set to roll up detailed data into totals or averages.
{% endhint %}

#### Data set templates

For common use cases, Coupler.io provides predesigned data set templates. You can use a template when creating a data flow. &#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FyiuoTrcJJkYMPbBaCrtX%2Fimage.png?alt=media&#x26;token=300cd8eb-9826-493e-a4e4-ab824d3792c3" alt="" width="375"><figcaption></figcaption></figure></div>

Select a template, connect your source, and the data set is configured automatically with the right columns, transformations, and blending.&#x20;

<a href="../functionality/data-set-templates" class="button secondary" data-icon="head-side-gear">Learn more about templates</a>

***

### Load data to spreadsheets, warehouses, BI, and AI tools

Once your data is ready, select a destination to load it to. Coupler.io supports four types of destinations:

* **Spreadsheets** — Google Sheets, Microsoft Excel (both Online and Desktop),&#x20;
* **Data warehouses** — BigQuery, PostgreSQL, Redshift, Snowflake
* **BI tools** — Looker Studio, Power BI, Qlik, and Tableau
* **AI tools** — ChatGPT, Claude, Gemini, Perplexity, Cursor, OpenClaw
* **API** — JSON

To connect a destination, click **Destinations** in the data flow setup, select the app, and follow the in-app instructions. For spreadsheets, you just log in and pick a file and sheet. For warehouses and BI tools, you may need to provide connection credentials.

If your data flow has multiple sources or blended data sets, you'll also choose which data view to export: source data, aggregated data, or blended data.

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FQAETXKWQggrYkIOY3Pg0%2Fimage.png?alt=media&#x26;token=fa6aa1d2-ca50-4379-9136-29067092265d" alt="" width="375"><figcaption></figcaption></figure></div>

#### Import modes (spreadsheets and warehouses only)

Import modes control how Coupler.io handles data at the destination on each refresh. The available modes include Replace and Append.

**Replace** overwrites the existing data with the latest pull. **Append** adds new data below the existing rows.

Import modes apply only to spreadsheet and data warehouse destinations. BI tool and AI tool destinations handle incoming data differently.

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FwLvBbYPy4Bvbl8FXGsGf%2Fimage.png?alt=media&#x26;token=5c35b9d5-9d39-4a37-9c31-a6b2185d490f" alt="" width="375"><figcaption></figcaption></figure></div>

***

### Keep your data fresh with automated refresh and webhooks

#### Automatic data refresh

To automate exports from your sources to the chosen destination, enable **Automatic data refresh** in the data flow settings. You can configure:

* Refresh interval (up to every 15 minutes)
* Days of the week
* Time preferences
* Time zone

All transformations and blending are preserved on each refresh.

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FzM12oKDPgPu19kuacxLO%2Fimage.png?alt=media&#x26;token=f395866c-24e7-4a98-b045-40cb080ab1d1" alt="" width="375"><figcaption></figcaption></figure></div>

<a href="../functionality/flow-settings/how-to-set-up-automatic-data-refresh" class="button secondary" data-icon="head-side-gear">Read more about Automatic data refresh</a>

#### Webhooks

Coupler.io supports both outgoing and incoming webhooks for workflow automation.

**Outgoing webhooks** notify external services when a data flow run completes. Use this to trigger downstream actions, e.g., send a Slack notification or update another system.

**Incoming webhooks** let you trigger a data flow run from an external event. This is useful when you need a refresh outside the regular schedule, e.g., after a CRM update or a form submission.

You can find webhooks set up in the data flow settings.

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FCJ4pXHyoKDuLHBLYRMMI%2Fimage.png?alt=media&#x26;token=043e97fd-8189-43ba-95f2-96e4287722ba" alt="" width="375"><figcaption></figcaption></figure></div>

<a href="../functionality/flow-settings/webhooks-support" class="button secondary" data-icon="head-side-gear">Read more about webhooks</a>

***

### Get instant answers with AI analytics

Coupler.io offers two ways to analyze your data with AI: the built-in AI Agent and AI tool destinations.

#### AI Agent

AI Agent lets you ask natural-language questions about the data in your data flows. You can access AI Agent from:

* The sidebar menu (for general data exploration)
* Any completed data flow (for focused analysis)
* The **ASK AI** button in your data flows list

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FkAYvweATyLDVnhdsnfCV%2Fimage.png?alt=media&#x26;token=f3d11158-43ce-4306-9534-badddb9fd99d" alt=""><figcaption></figcaption></figure></div>

AI Agent works with your live data, updated according to your data flow's refresh schedule.&#x20;

#### AI tools as destinations

You can also send your data to external AI by selecting them as destinations in your data flow. Coupler.io supports the following AI tools: ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. This lets you analyze your data conversationally in the AI tool of your choice. See the destination setup section for configuration details.

<figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FpucJDtCo8UgwJ8xyzZF2%2Fdownload.png?alt=media&#x26;token=14bbba7e-a391-4b3c-af78-c6ca50467c28" alt=""><figcaption></figcaption></figure>

***

### Visualize data with dashboard templates

Dashboard templates give you instant insights without building reports from scratch. Coupler.io offers two types:

**Native Coupler.io dashboards** that live inside the Coupler.io interface and equipped with AI-powered insights for faster decision-making.&#x20;

**Dashboard templates for external BI tools** such as Looker Studio, Power BI, Tableau, and Google Sheets.&#x20;

<figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FbPnGfJHJVvSsiDnYsrOV%2Fimage.png?alt=media&#x26;token=0065aba5-ce49-4b10-b1c8-ff39ed87686a" alt=""><figcaption></figcaption></figure>

> **Tip:** For BI tool templates, we recommend setting them up from the [dashboard library](https://www.coupler.io/dashboard-examples) where you'll find detailed configuration instructions on the Readme tab.

***

### Optimize data loads with incremental fetching

By default, Coupler.io pulls the full data set from the source on each refresh. Incremental fetching changes this: it fetches only new or changed data since the last run.

This is useful when you're working with large data sets or sources with API rate limits. It reduces load times, minimizes API usage, and keeps your destination up to date more efficiently.

***

### Automate workflows with macros

Macros let you automate sequences of actions within Coupler.io — for example, running multiple data flows in a specific order or chaining refresh operations.