API Connector Documentation
API Connector Usage
- Quick Start
- Add a Data Refresh Timestamp
- Add a Request Body to a POST Request
- API Connector Pro
- Basic Authentication (Encode Credentials to Base 64)
- Connect to an OAuth2 API
- Copy Existing Request
- Create API Request Based on a Cell
- Error Messages
- Filter for Specific Fields and Values (JMESPath)
- Frequently Asked Questions
- Import / Export Configuration Files
- IMPORTAPI() Custom Sheets Function
- Include Headers
- Overwrite vs. Append Output Mode
- Pagination Handling
- Report Styles
- Run Multiple Queries in a Single Request
- Scheduling
- Troubleshooting API Requests
Step-by-Step API Guides
- Import ActiveCampaign Data to Google Sheets
- Import Ahrefs Data to Google Sheets
- Import AfterShip Data to Google Sheets
- Import Airtable Data to Google Sheets
- Import Asana Data to Google Sheets
- Import BambooHR Data to Google Sheets
- Import Binance Data to Google Sheets
- Import Chargebee Data to Google Sheets
- Import CJ Affiliate (Commission Junction) Data to Google Sheets
- Import Clickbank Data to Google Sheets
- Import CoinAPI Data to Google Sheets
- Import Coinbase Data to Google Sheets
- Import CoinGecko Data to Google Sheets
- Import Coinmap Data to Google Sheets
- Import CoinMarketCap Data to Google Sheets
- Import Constant Contact Data to Google Sheets
- Import CryptoCompare Data to Google Sheets
- Import Dark Sky Data to Google Sheets
- Import Facebook Ad Data to Google Sheets
- Import Facebook Page Data to Google Sheets
- Import Financial Modeling Prep Data to Google Sheets
- Import Football Data from RapidAPI to Google Sheets
- Import Freshdesk Data to Google Sheets
- Import GitHub Data to Google Sheets
- Import Google Cloud Vision API Data to Google Sheets
- Import Harvest Data to Google Sheets
- Import Hunter Data to Google Sheets
- Import IMDB Data to Google Sheets
- Import Instagram Data to Google Sheets
- Import Intercom Data to Google Sheets
- Import iTunes Data to Google Sheets
- Import Jira Data to Google Sheets
- Import Klaviyo Data to Google Sheets
- Import Kraken Data to Google Sheets
- Import LinkedIn Ads Data to Google Sheets
- Import Mailchimp Data to Google Sheets
- Import Netflix Data from RapidAPI to Google Sheets
- Import Okta Data to Google Sheets
- Import OpenWeatherMap Data to Google Sheets
- Import PayPal Data to Google Sheets
- Import Pipedrive Data to Google Sheets
- Import Product Hunt Data to Google Sheets
- Import Quaderno Data to Google Sheets
- Import QuickBooks Data to Google Sheets
- Import Quora Ads Data to Google Sheets
- Import Shopify Data to Google Sheets
- Import Stripe Data to Google Sheets
- Import SurveyMonkey Data to Google Sheets
- Import The Movie Database (TMDb) Data to Google Sheets
- Import Toggl Data to Google Sheets
- Import Torn API Data to Google Sheets
- Import Trello Data to Google Sheets
- Import Twitter Data to Google Sheets
- Import Vimeo Data to Google Sheets
- Import Visual Website Optimizer (VWO) Data to Google Sheets
- Import Weatherstack Data to Google Sheets
- Import Wikipedia Data to Google Sheets
- Import WooCommerce Data to Google Sheets
- Import Xero Data to Google Sheets
- Import YouTube Analytics Data to Google Sheets
- Import YouTube Data to Google Sheets
- Import Zendesk Data to Google Sheets
Projects
- Build Your Own Realtime Stock Tracking Dashboard in Sheets
- Build Your Own Search Engine Results Pages (SERP) Dashboard in Sheets
- Build a "What to Wear" App for Groggy Children (and Adults)
- Build a Weather Widget on a Website
- Convert Latitude-Longitude Data to Addresses in Google Sheets
- Construct a CRM Dashboard in Google Sheets
OTHER QUESTIONS?
Please submit your question in the new API Connector user community.