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
Multi-format
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
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 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