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.
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.
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.
https://api.chucknorris.io/jokes/random
https://api.coinbase.com/v2/prices/ETH-USD/buy
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.
Monthly Plan
Lifetime Plan
Annual Plan
.@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!
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.
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.
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.
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.
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.
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.
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