•  455
Import JSON into Google Sheets, easily. Connect any JSON or CSV API and pull API data into your Google Sheets. Make GET & POST requests. API integrator for Google Sheets.
Import JSON data to Google Sheets with Apipheny, a Google Sheets add-on that makes it easy to integrate a JSON or CSV API with Google Sheets. Just enter your API URL, key, and headers into the add-on, then click "Run". Your API data will automatically import into your Google Sheets. Save your requests, and make API calls based on the value of a cell by referencing the cell value in your API request.

- Connect API to Google Sheets 
- Connect to an unlimited number of data sources
- Import JSON or CSV data
- Includes fields to enter API URL, Headers, and POST Body
- Includes JSON Parser/JSON Converter
- Save API requests for easy access
- Choose which sheet your request is tied to
- COMING SOON: Schedule API requests to refresh the data in your Google Sheet automatically (hourly, daily, weekly, monthly) [coming soon/under maintenance]
- GET request in Google Sheets
- POST request in Google Sheets
- Create API request based on cell value: reference cell value (eg. {{{Sheet1!A1}}}) in API URL, headers, or POST body
- Call API request in Google spreadsheet using the custom =APIPHENY() function

Cost: It takes time and money to develop, support, and advertise this add-on, so we ask for a fee in exchange for the service. The add-on comes with a free 30 day trial, then it's $29/month, or $19/month when paid annual. Thank you for your patronage.

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 Google Sheets. An API is just a data pipeline between two software using a universal format such as JSON or CSV. The process of connecting an API to Google Sheets is technical and requires code, but the Apipheny app makes it easier for non-technical people to use 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. Our product 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 JSON or CSV 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. Check out my video demo above to see what I mean..

The add-on includes support for JSON and CSV APIs, and GET and POST requests. Advanced features include the ability to use our custom =Apipheny() function, and the ability to create an API request by referencing the value of a cell eg. {{{x}}} in your API URL, headers, or POST body.

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.

When you install Apipheny, you’ll get a free 30 day trial that has all the same features the paid version has. Once the 30 days expire, you’ll have the option to upgrade to an affordable annual or monthly subscription plan. The annual plan comes out to $19/month/user and the monthly plan comes out to $29/month/user.  If you are a teacher or student and price/cost is an issue to you, just email us.

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: It’s easy to make an API call in Google Sheets 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 - Adform API, Adobe API, Adroll API, Active Campaign API, Ahrefs API, Amazon API, Asana API, Bing API, Constant Contact API, Criteo API, Doubleclick API, Github API, Google Analytics API, Google Ads API, Google Adsense API, Google Search Console API, Google My Business API, Google Maps API, Google Indexing API, Facebook API, Facebook Ads API, Harvest API, Hubspot API, Imbd API, Indeed API, Instagram API, Intercom API, iTunes API, Jira API, Kelly Blue Book API, Linkedin API, Mailchimp API, Moz API, Netflix API, Optimizely API, Outbrain API, OpenWeather API, Paypal API, Pinterest API, Product Hunt API, Quora API, Quickbooks API, Reddit API, Salesforce API, Searchmetrics API, Semrush API, Shopify API, Snapchat API, Spacex API, Spotify API, Stripe API, Surveymonkey API, Taboola API, Tiktok API, Trello API, Tumblr API, Twitter API, Vimeo API, Yahoo API, Yandex API, Youtube API, Wikipedia API, Wordpress API, Xero API, Ziprecruiter API, Crypto Price API, Government Data API, CRM API, HR API, News API, Stocks API, Sports API, Weather API, Video Game API and Esports 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. Apipheny.io is a Supermetric alternative that can connect to multiple data sources and get all of your data into Google Sheets. Then connect your Google Sheet to a free visualizer like Google Data Studio. 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”. 

- 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, or you need help creating a dashboard from Google Sheets, just contact us and we’ll help you for free. You can email us or chat with us live on our website.
Sort by:
A User of Apipheny - API Tool
March 30, 2020
Thank you for trying Apipheny. You can email me or chat with me live on our website if you have any questions. I'm happy to help. We're currently experiencing an issue with the scheduling feature and it will be fixed soon. If you run into an issue where the add-on is not loading or working correctly, it could be because you're signed in to multiple Google accounts. Try signing out of your other Google accounts and see if that fixes the issue. Cheers, -Meelad Mashaw Co-founder Apipheny
Is this review helpful?
A user of Apipheny - API Tool
April 22, 2020
you are cool
A User of Apipheny - API Tool
March 14, 2020
Easy to use.
Is this review helpful?
A user of Apipheny - API Tool
April 22, 2020
yes it is
A user of Apipheny - API Tool
March 15, 2020
Thank you, we appreciate you trying it out.
A User of Apipheny - API Tool
March 12, 2020
is there any document how to use it?
Is this review helpful?
A User of Apipheny - API Tool
March 12, 2020
amazing application.
Is this review helpful?
A user of Apipheny - API Tool
March 12, 2020
Thanks! Glad you like it.
1-4 of 4
Additional information
Terms of Service
Clear search
Close search
Google apps
Main menu