REST API Connector has an easy-to-use interface that lets you connect to any API directly from your Google Sheet. Import/Export data, live test, automate jobs, chain different requests.

Features:
GET, POST and PUT requests
Save your API requests and configuration for future access
Reference cells in API requests for dynamic queries
Path filtering of API results
IMPORTJSONAPI() custom function 
Demos, tutorials and support at https://restapiconnector.dev-worthy.com/how-to/

Pro Features: 
Schedule requests to refresh data automatically
Chain requests to start one after another
Automatically handle pagination
Advanced filtering and selection of API results