Connect & import API data into Google Sheets, quick n' easy.

Connect & import API data into Google Sheets, quick n' easy.
Animated imageAnimated imageAnimated imageAnimated imageAnimated imageAnimated image

No more manually copying and pasting data into Google Sheets.

Call an API in your Google Sheet faster than you can make a cup of coffee β˜•οΈ

β€’ Most modern platforms & websites have an API, which is a raw data pipeline
β€’ We can use these APIs to extract the data we need into Google Sheets
β€’ Apipheny makes it easy to connect APIs to Google Sheets
β€’ GET, POST, PUT, PATCH, & DELETE methods available

How it works πŸ‘‡

1.
1. Start by installing Apipheny, a Google Sheets add-on.

Click here to install Apipheny. Try if free for 30 days to see if it's the right fit for you. There's no credit card required and you won't be automatically charged anything at the end of the trial (manual upgrade required). The trial version includes all the same bells and whistles as the paid version.

Import JSON to Google Sheets
2.
2. Open Apipheny and enter your API request.

After installing Apipheny, open a Google Sheet. In the menu click Extensions > Apipheny > Import API to open Apipheny.

If you haven't already, sign up for a developer account on your API of choice, read the API documentation, and get your API URL with an endpoint.

Your API request might also need a key/token, parameters, body, and headers, depending on the API and the endpoint you need to call.

Supermetrics alternative
3.
3. Sit back and enjoy your auto-updating spreadsheet.

Lastly, choose your method (GET, POST, PUT, PATCH, DELETE) and enter your API URL and other components like headers into the dedicated fields in the Apipheny add-on.

Then just click Run and you're done. Your API will be called without you even having to leave your sheets.

If you want to do a quick test with Apipheny, try these URLs:
Chuck Norris Jokes: https://api.chucknorris.io/jokes/random
Price of Ethereum: https://api.coinbase.com/v2/prices/ETH-USD/buy
Just copy and paste one of these URLs into Apipheny and then click the Run button.
Google Cloud Partner
Integrate Google Sheets with an unlimited number of API data sources and make API calls directly in your spreadsheet.

Integrate Google Sheets with an unlimited number of API data sources and make API calls directly in your spreadsheet.

Automate data pulls in Google Sheets, without breaking the bank.

Apipheny is an affordable tool that can be used in conjunction with or as an alternative to other data collection tools. 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 Geckboard or Google Data Studio to create enterprise level charts and dashboards, without the enterprise price tag. If you're not sure whether Apipheny is the right solution for you, just message us and let us know what you want to accomplish.

$12/month

Monthly Plan

  • Features: same as Lifetime Plan
  • Your first month free (30 day trial, no credit card needed)
  • 30 day refund for any reason
  • Cancel anytime
Start free trial

$249/life

Lifetime Plan

  • Your first month free (30 day trial, no credit card needed)
  • Access for 1 Google account
  • Unlimited API requests
  • Unlimited Sheets
  • GET, POST, PUT, PATCH, DELETE β“˜
  • Save API requests β“˜
  • Request settings β“˜
  • Schedule API requests β“˜
  • Stack URLs β“˜
  • Reference cell value β“˜
  • =APIPHENY() function β“˜
  • Run all requests β“˜
  • Transfer requests β“˜
  • Customer support
  • 30 day refund for any reason
  • Cancel anytime
Start free trial

$132/year

Annual Plan

  • Features: same as Lifetime Plan
  • Your first month free (30 day trial, no credit card needed)
  • 30 day refund for any reason
  • Cancel anytime
Start free trial

Made for data wranglers 🀠

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 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

Apipheny uses Google Apps Script to connect Google Sheets API with the API of companies like Binance, CoinMarketCap, Facebook, Github, Harvest, Mailchimp, Paypal, Quickbooks, Shopify, Surveymonkey, Typeform, and Youtube.

Affordable Alternative

You don't need an expensive data integration/visualization platform like Funnel.io to connect a REST API to Google Sheets. Do-It-Yourself with Apipheny, a Supermetrics alternative that you can use to get the data you need fast and cheap from any paid or free API.

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.

What is an API?

What is an API?

API stands for application programming interface and it is a raw data pipeline that allows two programs to talk to each other. APIs can seem intimidating at first, but learning how to use an API is not as difficult as it seems.

Learn more
Apipheny

Made in California

By Meelad & Chris