Unlock the power of data with Apipheny, a free API connector that makes it easy to import data from or push data to any REST JSON or CSV API directly from your Google Sheets.
Listing updated:November 19, 2023
Works with:
Stop copying and pasting data into Google Sheets and take back control of your time. Apipheny is designed to save you from manual data wrangling by allowing you to create custom data connections to data sources that have an API.

An API is just a raw data pipeline that anyone can tap into, and most websites/platforms have an API these days. Using APIs was a process normally reserved for developers, but thanks to Apipheny, no-coders can get the data connections and automations they need without needing to write any code.

To use Apipheny, just enter the API URL, parameters, key, and headers into the add-on, then then click "Run". You can also save your data requests and schedule them to run automatically on a time interval.

Learning to use an API might seem like a big task, but it's actually quite simple. Read our tutorials to learn how easy it is to connect to the most common APIs: https://apipheny.io/tutorials/

- Connect API data sources to Google Sheets
- Choose from GET, POST, PUT, PATCH, and DELETE request methods
- Includes fields to enter API URL, headers, and body
- Includes JSON Parser/JSON Converter for Sheets
- Save your requests for easy access
- Schedule requests to refresh the data in your Google Sheet automatically (hourly, daily, weekly, or monthly)
- Choose which sheet your requests are tied to
- Import JSON API data or CSV API data into Google Sheets
- Reference the value of any cell in the API URL, headers, or body
- Call the API request without leaving your sheets by using the custom =APIPHENY() formula
- Get multiple pages of results using our pagination feature
- Use our Response Viewer to preview, customize, and filter your API data before you import it
- and much more

Upon installation, enjoy a complimentary 14-day trial, granting you full access to all features, without the need for credit card information. Once your trial period concludes, you will automatically transition to our basic free plan. When you're ready to elevate your experience, explore our range of flexible pricing options available here: https://apipheny.io/pricing

Eliminate manual data pulls and save time. If you're manually exporting JSON or CSV files from a software platform and pasting the data into Google Sheets, then just automate that process by connecting your software platform's API with the Google Sheets API.

An API is just a data pipeline between two software using a universal format such as JSON or CSV. The process of connecting an external API to Google Sheets API is a technical process and requires code, but the Apipheny app makes it easier for non-technical people to use an API in Google Sheets, and people who want to save time.

If you’re wondering how to call an API in Google Sheets, wonder no more. With Apipheny, you can easily connect and import API data without writing any code. For example, you can use it to get data from the CoinMarketCap API in Google Sheets. Or connect the Trello API and Asana API to Google Sheets.

It works with most APIs. Perfect for anyone who needs an easy and affordable data analysis software to pull API data into a spreadsheet like Google Sheets, so you can visualize and manipulate the data however you'd like.

Connect to as many data sources as you want and make as many data requests as you want. Apipheny has no limits. The only limits you might run into would be either the Google Sheets limits/quotas or Google API limits/quotas.

To import API data, all you need to do is enter your API URL and headers/key into the add-on, then click “Run” and you’re done. Your API data will automatically import into Google Sheets in just a few seconds.

The add-on includes support for JSON and CSV APIs, as well as GET, POST, PUT, PATCH, and DELETE request methods. Advanced features include the ability to schedule your API requests to refresh automatically every hour or every day, the ability to use our custom =Apipheny() function, and the ability to create an API request by referencing the value of a cell in your API request. Plus, if you need to call the API repeatedly to get all the results, you can automate it using our pagination feature.

Don’t waste your time manually exporting and importing data into Google Sheets. Automatically get data into Google Sheets and then use the data to create custom reports, or connect the Sheet to a free data visualizer like Google Data Studio to create custom views of all your data in one place. All at a fraction of the cost of other enterprise API data integration and visualization platforms.

More features and information:

- Google Sheets add-on: Apipheny is a Google Sheets add-on that you can install in the G-Suite Marketplace. Once you install the add-on, you can import an API by opening a Google Sheet and then click Add-ons > Apipheny > Import API.

- Make API Call Google Sheet: Connect to the Google Sheets API and making an API call in Google Sheets is easier than you think, with Apipheny. Just enter your API URL, headers, and key in the app and then click “Run” and your API data will automatically be called into your spreadsheet.

- Import JSON to Google Sheets: you can use this Google Sheets add-on to connect and import API data from any JSON or CSV API. Most modern software and platforms use a universal JSON format for their API, which works perfectly with this add-on. To import JSON all you have to do is sign up for a developer account on your platform(s) of choice, get your API URL, key, and headers, then plug them into this add-on and click Run. Works with most APIs.

- Universal API connector: Apipheny works with almost any API. Here’s some of the examples of APIs that you can (technically) manually integrate with Google Sheets using the Apipheny app. Experience and usage varies by platform - Active Campaign, Ahrefs, Asana, Bing, Constant Contact, Criteo, Github, Facebook, Facebook Ads, Harvest, Hubspot, Imbd Indeed, Instagram, Intercom, iTunes, Jira, Kelly Blue Book, Linkedin, Mailchimp, Moz, Netflix, Optimizely, Outbrain, OpenWeather, Paypal, Pinterest API, Product Hunt, Quora API, Quickbooks, Reddit API, Salesforce Searchmetrics, Semrush API, Shopify, Snapchat, Spacex, Spotify, Stripe, Surveymonkey, Taboola, Tiktok, Trello, Tumblr, Twitter, Vimeo, Yahoo API, Youtube, Wikipedia, Wordpress, Ziprecruiter, Crypto Price API, Government Data API, CRM API, HR API, News API, Stocks API, Sports API, Weather API.

- JSON parser/JSON converter: You can use Apipheny to easily get raw JSON parsed in an easy to read format right in Google Sheets. Our JSON parser requires no additional coding or scripts from you - it’s included and ready to use.

- Supermetrics alternative: If you’re looking for an alternative to Supermetrics custom JSON connector tool then look no further. You can connect to almost any API via our easy to use JSON API importer. You can also use Apipheny as an affordable alternative to other data integration and automation software such as Ad Stage (Adstage), KPIbees (KPI Bees), Klipfolio, Flex.io, Funnel.io, Power My Analytics, Reportgarden, Excelify, Improvado, Whatagraph, Analytics Canvas, Zoho Analytics, Stitch.io, Zapier, and IFTT.

- Crypto price Google Sheets: Use our add-on as a cryptofinance alternative. Get Coinmarketcap API in Google Sheets by connecting to the Coinmarketcap API or the API from any cryptocurrency website or exchange like Altcointrader, Alpha Vantage, Btcmarkets, Binance, Bitfinex, Bitpay, Bithumb, Bitstamp, Bittrex, Blockchain, CoinMarketCap, CoinAPI, Coinbase, Coingecko, Cryptopia, Fixer, Idex, ICOwatchlist, Gemini, Gdax, Hitbtc, Huobi, Livecoin, Kraken, Kucoin, Luno, Poloniex, Qtrade, and more. Get Bitcoin, Ethereum, and other cyrptocurrency data and crypto prices in your Google spreadsheet.

- GET request Google Sheets: You can make a GET request in Google Sheets with Apipheny by choosing the “GET” method in the “Import” tab of the add-on. Then enter your API URL, headers, and key if you have one. Then click “Run” and you API data will automatically pull into your Google Sheet.

- POST request Google Sheets: With Apipheny it’s easy to make a POST request and add a POST body in Google Sheets. You can make a POST request in your Google Sheet by choosing the “POST” method in the “Import” tab of the add-on. Then add your API URL, your POST Body, and click “Run”. 

- PUT request Google Sheets: You can make a PUT API request in your Google Sheet by choosing the PUT request method in Apipheny. Then just enter your request details (URL, body, etc.) and click the Run button to process your request without leaving your sheet.

- PATCH request Google Sheets: You can make a PATCH API request in your sheet by using the PUT request method in Apipheny. After choosing the PATCH method, just enter your request details (URL, body, etc.) and click the Run button to process your request.

- DELETE request Google Sheets: You can make a DELETE API request by choosing the PUT request method in the Apipheny add-on. Then enter your request details (URL, etc.) and click the Run button to process your DELETE request.

- Data analysis software: pull data in from one or multiple data sources with this easy to use data analysis software. Easily visualize and manipulate API data in your spreadsheet. Use one of the advanced features to supercharge your spreadsheet like create reference the value of a cell (eg. {{{Sheet1!A1}}}) in the URL, headers, or POST Body of your API request, or call an API request inside a cell of your spreadsheet with the =APIPHENY() function.

- Data visualization tool: you can use this add-on to create a visual dashboard with a tool like Google Data Studio. Just connect one or multiple API to Google Sheets, then integrate your Google Sheet with Google Data Studio to get custom views of all your data in one place.

- Marketing automation tool: Apipheny.io is a popular marketing automation tool for freelance marketers and marketing agencies who want to automate data pulls from a software or a platform and get data from multiple sources like PPC, SEO, social media, and analytics all into one place without breaking the bank. Use Apipheny to get enterprise level data integration, automation, and reporting at an affordable price.

- Data privacy: your API and spreadsheet information is stored in Google’s servers. None of your API nor spreadsheet information is synced to our servers and we don’t have access to view any of your spreadsheet or API data. The add-on requires only basic permissions to run.

- Technical support: we’re here to help. If you have any questions about importing an API into Google Sheets, just contact us on our website.

Google Finance, GoogleFinance, Market View, Investar.com, MarketView, Crypto, Morningstar, Refinitiv, S&P,  CryptoWallet, XERO, Alpha Vantage, Currency Converter, SketchUp for Schools, LucidChart Diagrams, BetterCloud, Pear Deck, Lucidpress, BrainPOP, Form Ranger, Awesome Table, AODocs, EasyBib, GAT+, formLimiter, Smartsheet, Doctopus, Hapara Teacher, diagrams.net, SMART Learning Suite, Nearpod, Kami, Mavenlink, Flubaroo, NoodleTools, MindMeister, Form Publisher, MathType, Backupify, Choice Eliminator, EasyBib, Bark, Digication, Cisco Webex, Form Mule, MindMup, SysCloud Security, Expensify, One Up, Xero, Zoho, Cryptosheets, Cryptofinance, Screencastify, Spanning Backup, Doc Appender, DocHub, Pixton for Schools,  Wrike, Virtu/Virtru, Super Quiz, PowerSchool, JoeZoo Express, gPanel, LumApps, Asana, GQueues, chromebookInventory, Timify.me, DocuSign eSignature, Easy Accents, Kaizena, Kabanchi, Grackle Docs, Power Tools, PlanbookEdu, VoiceThread, Sketchboard, Mindomo, Mojo Helpdesk, Slido, Stupeflix, Certify'em, StackEdit, Colaboratory, GoFileDrop, Drag, PerformFlow, Avery Easy Merge, Avery Label Merge, Foxy Labels, Taskboard, Google Tasks Desktop, OK Goldy, Google Apps Training, Slides Translator, Turnitin Draft Coach, ProjectWork, Math Equations, CoRubrics, Mail Merge, Document Studio, Control Accepting Responses, Mover, s, Publigo, Folgo, Hew Viewer with Drive, Koalendar, Zipbooks, Smallpdf, Magic Rainbow Unicorns, Sedja, Apptivo, Adveronix, Evernote, WhatsApp, Poshmark, Quilgo, PDFfiller, Airtable, OnlyOffice, ScheduleOnce, BeFunky, Photopea, AdRoll, Ahrefs, Asana, Facebook Ads, Facebook Pages, Github, Google Ads, Google Analytics, Google Calendar, Google Classroom, Google PageSpeed Insights, Google Search Console, Harvest, Hubspot, Instagram Insights, Jira, LinkedIn Ads, Mailchimp, Pinterest Ads, Procore, QuickBooks, Quora Ads, Spotify, Strava, Stripe, TD Ameritrade, Vimeo, Xero, YouTube, CRM, Bitcoin, crypto currency, CoinMarketCap, Binance, CoinGecko, likes, follows, impressions, clicks, tweets, retweets, SEO analysis, Mailchimp emails, Asana, Trello, Shopify store, Postman, Zapier, Supermetrics, apigee, ActiveCampaign, Algolia, AngelList, Anymail, Apify, Autopilot, Aweber, Azure, Basecamp, Bing, Bitbucket, IFTTT, Insomnia, Coupler, Simplescraper, Data Slayer, Bubble, Buffer, Calendly, Campaign Monitor, Capsule, Chargebee, Chatfuel, Clearbit, ClickFunnels, Constant Contact, ConvertKit, cPanel, WHM, Dandelion, DataBox, Discord, Disqus, Docupilot, Drip, Egnyte, Elasticsearch, EmailHippo, Etsy, Eventbrite, Evernote, Feedly, Fieldbook, Firebase, Flickr, Foursquare, FreshBooks, FinnHub, Freshdesk, Front, FTP, G2Crowd, GetResponse, GitLab, Google Maps, Gravity Forms, Harvest, Help Scout, HipChat, Hootsuite, HTTP, IFTTT, Indeed, Infusionsoft, Insightly, Integromat, Invoice Ninja, JIRA, Kickbox, KissFlow, Klaviyo, Knack, Leady, LionDesk, Listrak, Magento, Mailgun, Mandrill, ManyChat, Marketo, Mattermark, Mattermost, Medium, Meetup, MessageBird, Microsoft Teams, MongoDB, MonkeyLearn, Moosend, Moz, MyTimeStation, NetSuite, Ninox, OneDrive, OneNote, OpenAI, Paperform, Patreon, PayPal, Pinterest, Pipefy, Pipeline Deals, Pitchbook, Plivo, Plutio, Pocket, Podio, RAYNET, Rebrandly, Recurly, Redshift, RSS and Atom feeds, Runkeeper, Salesflare, Salesforce, ScheduleOnce, Segment, SendGrid, SendinBlue, SendPulse, Sendy, ServiceNow, SFTP, ShipStation, Shopio, SigParser, Slack, Smartsheet, SoundCloud, Spotify, SQL Server, Square, StackExchange, Streak, Stripe, SugarCRM, Survey Monkey, Teamgate, Telegram, Todoist, Toggl, Tumblr, Twilio, Twist, Twitch, Twitter, Typeform, Unbounce, Wasabi, Watson, Webflow, Weebly, Wild Apricot, WooCommerce, WordPress, Wrike, Wufoo, Wunderlist, Xero, YouTube, Zapier, Zendesk, ZeroBounce, Zoho, Notion, Wazirx, Airboxr, Axios, Crunchbase, Excelify, CoinMarketCap, MercadoBitcoin, Poloniex, Block, Coinigy, CoinLayer, Livecoin, Blockchain, Cryptonator, Nexchange, Zloader, CoinRanking, Coinlore, Coinlib, CoinDesk, ICObench, Binance, BitcoinAverage, Coinbase, CryptoStandardizer, IEX, Bitfinex, Coinpaprika, BitcoinCharts, Coinbase Pro, CoinGecko, WorldCoinIndex, NiceHash, Bitmex, Bittrex, Gemini, CoinAPI, Messari, CryptUnit, WhatToMine, Nomics, CryptoCompare, Paradigm, The Block, Coinmetrics, Cointracking, Shrimpy, CCXT, Chainz, Crypto51, Earn, Etherscan, Ethplorer, OpenFIGI, Cryptowatch, FOAM, Amberdata, Cryptosheets, Bloxy, Bitwise, Kryptocal, Tokeninsight, Kaiko, Flipside Crypto, Huobi, LocalBitcoins, Kraken, Covalent, TokenAnalyst, DeFi Pulse, Compound, Coinbase Prime, GlassNode, Binance, 1inch, XRP, Radar Relay, Cryptocontrol, Binance US, Coinbase Custody, Smartable Coronavirus API, EOD Historical Data, Bybit, ByteTree, Covidtracking, Bitstamp, KuCoin, Stellar, TokenView, CryptoAPIs.io, Beaconchain, WAVES, Bonfida, OpenSea, Uniswap
Additional information
PricingFree of charge
Privacy policy
Terms of service
Apipheny - API connector will ask for the permissions shown below. Learn more
Apipheny - API connector will need access to your Google account
This will allow Apipheny - API connector to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu