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

Run Requests

Create API requests

Build API requests in a user-friendly interface, without code

Run API requests

Run requests through the sidebar or the IMPORTAPI custom function

API library

Access our library of pre-set API requests

Reference cells

Use cell values in requests

Multi-format

Works with all major API data formats (JSON, XML, CSV, text)

Request methods

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

Automatic basic auth

Automatically apply basic authentication

ImportAPI custom function

Run requests directly from your spreadsheet

Preview API Response

View raw response from the server

Unlimited rows

No limit on rows returned

Unlimited data sources

No limit on data sources

Customize Output

Visual Field Editor

Easy no-code interface to filter, drag & drop, and rename fields

Output modes

Overwrite and append modes

JSON converter

4 different report styles to 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

Options

Options to truncate headers, clear sheet if no data found, etc.

Manage Requests

Save requests

Save API requests for future access

Import files

Import saved configuration files

Import cURL

Import cURL snippets

Duplicate requests

Copy saved requests rather than starting from scratch

Request logging

Store a log of all requests with completion status

Get Support

Error messages

Detailed error messages to help with troubleshooting

Tutorials

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

Forum

Active user forum to supplement the knowledge base

Security

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

Pro Plan Featureseverything 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

Filter data using the powerful JMESPath query language for JSON

Handle rate limits

1.5 second delay automatically included 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 Featureseverything above, plus:

Extended limits

Still higher run and save limits

Schedule hourly requests

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

Export requests

Share request configurations with others

Custom OAuth2

Add custom OAuth2 connections

Preset OAuth2 connections

Pre-set connections for AdRoll, Ahrefs, Asana, Facebook Ads, Facebook Pages, FreshBooks, GitHub, Google Ads, Google Analytics (UA, GA4), Google Calendar, Google Classroom, Google PageSpeed, Google Search Console, Harvest, Hubspot, Instagram Insights, Jira, LinkedIn Ads, Mailchimp, Pinterest Ads, QuickBooks, Quora Ads, Spotify, Strava, Stripe, Vimeo, Xero, YouTube, Zoho CRM

Priority support

Fast, helpful support