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 ☕️
How it works 👇
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.
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.
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.
Integrate Google Sheets with an unlimited number of API data sources and make API calls directly in your spreadsheet.
- Easily connect external APIs to the Google Sheets API
- Make GET, POST, PATCH, PUT, & DELETE requests
- Save, schedule, and modify your saved API requests
- Choose which sheet the API request is connected to
- Use the custom =APIPHENY() function directly in sheet cells
- Reference any cell value in your API request
- Run multiple requests at once, stack requests, and export requests
- Unlimited possibilities: customize your Google Sheets exactly how you want with unlimited possible workflows, integrations, automations, and formulas
- All at a fraction of the cost of enterprise data integration and visualization platforms.
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
$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
$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
.@apipheny may be the most underrated Google Sheets extension I've seen. If you want JSON pulled in every hour into a dynamic Google Sheet...IT. IS. AMAZING.
— Andrew Walls 🇺🇦 (@TheEdTechSchool) April 17, 2022
Discovered @apipheny add-on for Google Sheets. I can now connect Simplecast's API and automate our podcast client reports. HUGE
— Joe Stone (@_joe_stone_) September 8, 2022
@apipheny Begun experimenting with your service. Would make a great addition to my no-code toolset. Being able to connect additional APIs to a Google Sheet. Could be great for Hackathons & No Code lowing barriers to entry to test ideas pic.twitter.com/ODtynbO680
— Dominic (Mr. Hackathon) Norton (@dominiconorton) October 23, 2020
🧵 Pulling LIVE $LOOMI price from @CoinMarketCap into your google sheet (portfolio)
— razrunelord.eth 🦎🕯🌕 (@razrunelord_) February 3, 2022
- Creating a CMC API key
- Installing Apipheny extension to Google
- Schedule a trigger to refresh price at intervals@CBCreepz pic.twitter.com/gXnZjgdO6a
Sharing this for my #nocode people. This is exactly what I needed today. https://t.co/0579KciISX@apipheny
— Hans, that Cold Email Guy 🤙 (@Hanseflats) April 27, 2020
Apipheny is the keyhttps://t.co/0b6G0OizGB
— psy^ (@psyOPs_) May 25, 2022
i have about 10k pages I need to constantly improve (SEO) and it drives me nuts, so I'm building myself a flow for focusing better on seo for my own projects.
— Flavio Amiel - SEO for growing Startups (@fba) April 19, 2022
With apipheny + Google Sheets and a self-made quality algo to focus only on those with good volume, $, both or none.
Sharing some favorite tools I depend on as a digital marketing consultant:@Upwork @QuickBooks @googlecloud @GoogleWorkspace @reclaimai @apipheny @Supermetrics @clickup
— Matt Bosma (@mattwbosma) May 3, 2022
Thanks for helping me be successful!
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?
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