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. 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 and install the Coupler.io 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:
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).
Step 4. Save and run
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.