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

API directory

Quickly create requests through a large built-in API directory

Custom requests

Create custom API requests in a user-friendly, no-code interface

Reference cells

Use cell values in requests


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

Customize Output

Visual field editor

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

Output modes

Overwrite, append, and merge modes

JSON converter

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

JMESPath filtering

Filter data using the powerful JMESPath query language for JSON

Print data refresh timestamps into spreadsheet alongside response

Print API request URL or body into spreadsheet alongside response

Set data destination

Choose where to send response data

Flatten fields

Flatten repeated values into separate columns

Manage Requests

Import API requests

Import and export saved API requests

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

First-Class Security and Support

Error messages

Detailed error messages to help with troubleshooting


150+ 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

Multi-query requests

Automatically run through a list of request URLs or request bodies

Handle pagination

Automatically handle most types of paginated APIs

Handle rate limits

2 second delay automatically included to avoid rate limits

Money-back guarantee

100% refund provided for any reason within 30 days

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

Export API requests

Bulk export all requests at once

Custom OAuth2

Add custom OAuth2 connections

Preset OAuth2 connections

One-click OAuth connections for AdRoll, Ahrefs, Asana, Etsy, Facebook Ads, Facebook Pages, FreshBooks, GitHub, Google Ads, Google Analytics (UA, GA4), Google Business, Google Calendar, Google Classroom, Google PageSpeed, Google Search Console, Harvest, Hubspot, Instagram Insights, Jira, LinkedIn Ads, LinkedIn Pages, Mailchimp, Pinterest Ads, Pipedrive, Procore, QuickBooks, Quora Ads, Spotify, Spotify Ads, Strava, TD Ameritrade, Vimeo, Xero, YouTube, Zoho CRM

Priority support

Jump to the top of the support queue