Coupler.io
An easy way to gather your data in Google sheets
Last updated
Was this helpful?
An easy way to gather your data in Google sheets
Last updated
Was this helpful?
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.
Begin by setting up an API endpoint on Directual. Any data exchange with third-party applications in Directual is organized through API endpoints. 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.
Visit the G Suite Marketplace and install the Coupler.io add-on for your Google account. After installation, open Google Spreadsheet, click Add-ons – Coupler.io – Open dashboard.
In the Coupler.io dashboard, select JSON client as your data source:
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).
Coupler.io will automatically grab data from Directual API-endpoint (with a certain schedule which you can setup).
If your API-endpoint contains links or arrayLinks, Coupler.io will map the objects to flat table.