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
JMESPath filtering
Filter data using the powerful JMESPath query language for JSON
Print timestamps
Print data refresh timestamps into spreadsheet alongside response
Print request URLs
Print API request URL into spreadsheet alongside response
Set data destination
Choose where to send response data
Manage Requests
Save requests
Save API requests for future access
Import API requests
Import 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
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 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
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 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
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, LinkedIn Pages, Mailchimp, Pinterest Ads, Pipedrive, Procore, QuickBooks, Quora Ads, Spotify, Strava, Stripe, TD Ameritrade, Vimeo, Xero, YouTube, Zoho CRM
Priority support
Fast, helpful support