Jump to the top of the support queue
Turn Google Sheets into a powerful, flexible API client that pulls API data directly into your spreadsheet.
Install for free to get started.
Quickly create requests through a large built-in API directory
Create custom API requests in a user-friendly, no-code interface
Reference cells
Works with all major API data formats (JSON, XML, CSV, text)
Supports GET, POST, PUT, PATCH, and DELETE methods
Automatically apply basic authentication
Run requests directly from your spreadsheet
View raw response from the server
Easy no-code interface to filter,
drag & drop, and rename fields
Overwrite, append, and merge modes
4 different report styles to convert JSON into a tabular format for Sheets
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
Run requests directly from your spreadsheet
View raw response from the server
Import and export saved API requests
Import cURL snippets
Copy saved requests rather than starting from scratch
Store a log of all requests with completion status
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
Higher run and save limits
Refresh requests daily, weekly, or monthly
Set the order of scheduled requests
Automatically run through a list of request URLs or request bodies
Still higher run and save limits
Refresh requests every 1, 3, 6, or 12 hours
Bulk export all requests at once
Add custom 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
Jump to the top of the support queue