Import API data into Google Sheets, quick n' easy.

Import API data into Google Sheets, quick n' easy.
Animated imageAnimated imageAnimated imageAnimated imageAnimated imageAnimated image



Pull JSON or CSV API data into Google Sheets
faster than you can make a cup of coffee. ☕️

✓ Connect API to Google Sheets
✓ Eliminate manual data pulls
✓ Make GET & POST requests
✓ Includes JSON converter
– Reference cell value in API request
– No scripts or coding required
– Get started in 3 simple steps
Apipheny G-Suite
1.
1. Install Apipheny, an API integrator, in the G-Suite Marketplace.

Connect multiple data sources and import API data into Google Sheets with the Apipheny API integrator. Try if free for 30 days and if you don't like it then we'll take it back, no questions asked. No credit card required.

The trial version includes all the bells and whistles like unlimited JSON & CSV API requests, unlimited data sources, and unlimited saved requests.

Import JSON to Google Sheets
2.
2. Open the app and enter your API URL.

After installing Apipheny, open a new or existing Google Sheet. In the Google Sheets menu, click Add-ons > Apipheny > Import API to open Apipheny.

If you haven't already, sign up for a developer account on your data source/API of choice, read the API documentation, and get your API URL. Your API request might also need a key/token, endpoint, parameter(s), and header(s), depending on the API and the data that you need.

If you want to use a free public API for testing, you can use this Cat Facts API:
https://cat-fact.herokuapp.com/facts

Supermetrics alternative
3.
3. Sit back and enjoy using the best API integrator for Google Sheets on this side of the Mississippi.

Lastly, add your API URL and other components like headers into the Apipheny add-on. Then just click "Run" and you're done. Your API data will automatically import into Google Sheets.

Use the API data to create custom blended reports in Google Sheets 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 enterprise data integration and visualization platforms.

Connect to an unlimited number of API data sources and make unlimited API calls.

Connect to an unlimited number of API data sources and make unlimited API calls.

  • JSON viewer: Easily work with JSON in Google Sheets
  • Save, delete, and duplicate API requests
  • Choose which sheet the request is connected to
  • Call API requests in spreadsheet with custom =APIPHENY() function
  • Create API request based on cell value - reference cell value in the API URL, headers, or POST body with 3 curly braces {{{x}}}
  • COMING SOON: Scheduling feature (hourly, daily, weekly, monthly)
  • Google Sheets allows exports as XLSX, ODS, PDF, HTML, CSV or TSV

Import API data into Google Sheets,
without breaking the bank.

Apipheny starts at $19/mo and is an alternative to Supermetrics' custom JSON/CSV connector tool which starts at $99/mo. Use your Apipheny-powered spreadsheet to create affordable marketing reports with PPC, social, SEO, and analytics data. Make your data pretty using Google Sheets Templates, or integrate your Sheet with a free data visualizer like Google Data Studio to create enterprise level charts and dashboards, without the enterprise price tag. We can create custom solutions, too! If you're not sure whether Apipheny is the right solution for you, just message us and we'll let you know if you could benefit from a custom solution.

$0

30 Day Free Trial

Features: same as annual plan.

Start now

$228/yr

Annual Plan

Features:
1. 1st Month free, no credit card needed
2. JSON & CSV API Integrator for Google Sheets
3. GET & POST Requests
4. Unlimited API requests in unlimited Sheets
5. Save API requests for easy access later
6. Run multiple API URLs in the same request
7. Reference the value of a cell in your API request
8. Call API in your Google Sheet with the custom =APIPHENY() function

+ 34% off (save $120/year) when you invest in a year upfront. It comes out to $19 USD/month.

Start now

$29/mo

Monthly Plan

Features: same as annual plan.

Start now

Made for those who want to automate their data pulls - data analysts, marketers, agencies, and everyone in between.

Import API data into Google Sheets

Apipheny is a data analysis software and marketing automation tool that you can use to pull API data into Google Sheets from JSON and CSV sources. Make GET requests and POST requests directly in Google Sheets using a user-friendly app.

No Scripts Required

We're jumping on the no-code bandwagon. Apipheny is a code-less, universal API connector and easy to use JSON converter that is designed to save you time and money. Simply enter your API URL and key in the add-on to import JSON into Google Sheets.

Privacy First

Every app that Google approves must go through a strict security & privacy approval process, including ours. We don't have access to view any of your Sheets or API information. The add-on only requires very basic permissions to run.

Integrate Any API

Use almost any API in Google Sheets. Apipheny works with the API of companies like Binance, CoinMarketCap, Facebook, Github, Harvest, Mailchimp, Paypal, Quickbooks, Shopify, Surveymonkey, Typeform, and Youtube. New APIs are being added all the time.

Affordable Alternative

You don't need an expensive data integration/visualization platform. Do-It-Yourself with Apipheny, a Supermetrics alternative custom JSON connector that you can use to get the data you need fast and cheap.

It's Like Magic

Call, parse, and post data from one or multiple APIs all in Google Sheets. Manipulate the data in Sheets or integrate your Sheet with a data visualizer like Google Data Studio. There are no limits.

We're here to help!

We're here to help!

If you need help to import JSON into Google Sheets, or create a dashboard from Google Sheets, just contact us. We're a team of data analytics and data visualization experts and we can help you get set up and started. If you need to import XML to Google Sheets, or you have a more complicated use case, just message us to discuss custom solution options.

Data Privacy

Data Privacy

Every app that Google approves must go through a strict security & privacy approval process, including ours. When you first install the add-on, you'll be asked to allow access to three basic permissions that are required for the add-on to work properly. We do not have access to view any of the information stored in your Sheets nor any of your saved API information. All of your spreadsheet/API information is stored on Google servers and none of your information is synced to our servers.

Privacy Policy
Apipheny
Made in California

by Meelad & Nate

Get Apipheny

Help