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