Powerful API to Google Sheets features
Turn Google Sheets into a flexible API client that pulls API data directly into your spreadsheet.
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
Build request URLs and bodies from values in your sheet
Multi-format
Works with all major API data formats (JSON, XML, CSV, text)
Request methods
Supports GET, POST, PUT, PATCH, and DELETE
Automatic basic auth
Automatically apply basic authentication
Preview API response
View the raw response from the server
Customise output
Output modes
Overwrite, append, and merge modes
JSON converter
Convert JSON into a tabular format for Sheets
Print timestamps
Print data refresh timestamps alongside the response
Print request metadata
Print the request URL or body alongside the response
Set data destination
Choose the sheet and cell the data lands in
Manage requests
Saved requests
Save requests and run them again later
Duplicate requests
Copy saved requests rather than starting from scratch
Request logging
Keep a log of all requests with their completion status
Security and support
Error messages
Detailed error messages to help with troubleshooting
Tutorials
Step-by-step guides in the knowledge base and on YouTube
Security
Runs entirely through Google Sheets, on Google’s secure infrastructure
Pro plan: everything above, plus
Extended limits
Higher run and save limits
Schedule requests
Refresh requests daily, weekly, or monthly
Multi-query requests
Run through a list of request URLs or request bodies
OAuth requests
Connect to APIs that use OAuth
Business and Team plans: everything above, plus
Extended limits
Still higher run and save limits
Hourly scheduling
Refresh requests every hour (Team plan)
Export requests
Bulk export all requests at once
OAuth connections
Preset OAuth connections for popular platforms
Priority support
Jump to the top of the support queue (Team plan)