Powerful API to Google Sheets Features on All Plans

Turn Google Sheets into a powerful, flexible API client that pulls API data directly into your spreadsheet.
Install for free to get started.

Standard (Free) Features

Create API requests

Build API requests in a user-friendly interface with input fields for URLs, headers, and POST bodies

Run API requests

Run requests through the sidebar (8 per day) or through the ImportAPI custom function (unlimited)

Save API requests

Save API requests for future access (3 per workbook)

Unlimited rows

No limit on rows returned

Unlimited data sources

No limit on data sources

Request methods

Supports GET, POST, PUT, PATCH, and DELETE methods


Automatically detects + converts all major API data formats (JSON, XML, CSV, text)

Reference cells

Turn sheet cells into variables by referencing cells in your requests

Automatic basic auth

Automatically apply basic authentication

Preview API Response

View and download raw API response from the server

Output modes

Overwrite and append modes

JSON converter

4 different report styles to flatten & convert JSON into a tabular format for Sheets

Print timestamps

Print data refresh timestamps into spreadsheet alongside response

Print request URLs

Print API request URL into spreadsheet alongside response

Truncate headers

Make header rows prettier by displaying a shorter path

ImportAPI custom function

Run requests directly from your sheet

Import files

Import saved configuration files

Import cURL

Import cURL snippets

Copy requests

Copy saved requests rather than starting from scratch

Request logging

Store a log of all requests with completion status

Error messages

Detailed error messages to help with troubleshooting


100+ guides, tutorials, YouTube videos, and pre-set dashboards


Active user forum to supplement the knowledge base


Runs entirely through Google Sheets, using Google’s secure infrastructure

Pro Plan Features – everything above, plus:

Extended limits

Higher run and save limits

Schedule requests

Refresh requests daily, weekly, or monthly

Chain requests

Set the order of scheduled requests

Stack requests

Automatically run through a list of request URLs

Stack POST requests

Automatically run through a list of POST bodies, submitting each body to the same endpoint

Handle pagination

Automatically handle most types of paginated APIs

JMESPath filtering

Fix columns in place and filter data using the powerful JMESPath query language for JSON

Handle rate limits

1.5 second delay automatically inserted into stacked / paginated requests to avoid rate limits

Money-back guarantee

Payment will be 100% refunded for any reason within 14 days of initial purchase

Account management

Cancel account, access invoices, and update billing info through a secure online portal

Business Plan Features – everything above, plus:

Extended limits

Still higher run and save limits

Schedule hourly requests

Refresh requests every 1, 3, 6, or 12 hours

Preset OAuth2 connections

Pre-set connections for FB, Google Ads, GitHub, GA, Harvest, Instagram, Jira, LinkedIn, QuickBooks, Quora, Spotify, Strava, Vimeo, Xero, YouTube, Zoho

Custom OAuth2

Add custom OAuth2 connections

Export requests

Share request configurations with others

Priority support

Fast, helpful support