Builder

1 Data Source

Select the source of your data and fill in the fields for that source.

URL of API endpoint

Method

RapidAPI

Add your RapidAPI Key to connect to any API from RapidAPI.

RapidAPI Key

API Key

Connect to an API that requires authorization via an API Key/Value pair.

Key Name

Value

Add To

Basic Auth

Connect to an API that requires Basic Auth authorization.

Username

Password

Bearer Token

Connect to an API that requires Bearer Token authorization.

Token

URL of JSON file

You can use this sample file for testing purposes which contains chart data: https://apiwidgets.com/sample.json

Sheet ID

Range

Sheet ID is the highlighted section in this example:
https://docs.google.com/spreadsheets/d/1olZyjQ-786O0NYU6txXm1pLTQA48ZV4uGiXsP3F8zcA/edit?usp=sharing

Range can be the name of a sheet or an actual range such as Sheet1!A1:C200.

2 Convert To

Select the Widget type that you want to convert your data into.

3 Test Connection

Click the test connection button to ensure we can connect your data.

Test Connection