> For the complete documentation index, see [llms.txt](https://readme.directual.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://readme.directual.com/api-integrations/other-integrations/coupler.io.md).

# Coupler.io

An easy way to gather your data in Google sheets

## What is Coupler.io?

[Coupler.io](https://www.coupler.io/) is an add-on for Google Sheets that allows to pull data from various apps to Google Sheets on a set schedule with no coding required.

## How to pull data from Directual to Google Sheets using Coupler.io?

### Step 1. Configure API-endpoint in Directual

Begin by setting up an API endpoint on Directual. Any data exchange with third-party applications in Directual is organized through [API endpoints](/api-integrations/api-endpoints-security-layer.md). In the API builder, create a new endpoint where you can select the fields that will be accessible for reading. Additionally, you can set up filtering and sorting options.

### Step 2. Install Coupler add-on

Visit the [G Suite Marketplace ](https://workspace.google.com/marketplace)and install the [Coupler.io ](https://workspace.google.com/marketplace/app/couplerio/532272210531)add-on for your Google account. After installation, open Google Spreadsheet, click **Add-ons** – **Coupler.io** – **Open dashboard.**

### Step 3. Connect your API-endpoint

**‍**In the Coupler.io dashboard, select ***JSON client*** as your data source:

![](https://3071851461-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4Nnmtk9_gFGWOddsf6%2F-MQhPHXiTXv6ewr2paMX%2F-MQkDqC01Lmrg2P3gYbP%2Fgoogle.jpg?alt=media\&token=ffe76e8d-824a-4fe9-8243-29caa82ed371)

Then, paste your API-endpoint URL to the **JSON URL**. Click 'Show advanced'. You'll find a field 'URL query string' there. Type to that field **pageSize: N**, where **N** is a number of objects which Spreadsheet will receive (by default pageSize = 30).

![](https://3071851461-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4Nnmtk9_gFGWOddsf6%2F-MQhPHXiTXv6ewr2paMX%2F-MQkEAgFCl3J9ShhDIUd%2Fgoogle-2.jpg?alt=media\&token=da530236-0441-42dd-8e8b-0f3b06f01837)

### Step 4. Save and run

Coupler.io will automatically grab data from Directual API-endpoint (with a certain schedule which you can setup).

![](https://3071851461-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4Nnmtk9_gFGWOddsf6%2F-MQhPHXiTXv6ewr2paMX%2F-MQkEHjybSHjAVhx0Bf-%2Fgoogle-3.jpg?alt=media\&token=0ca4f2bd-bf6d-4434-a054-882f92a1931e)

If your API-endpoint contains **links** or **arrayLinks**, Coupler.io will map the objects to flat table.