Unlock the power of data with Apipheny, a free API connector that makes it easy to import data from or push data to any REST JSON or CSV API directly from your Google Sheets™.
Listing updated:June 20, 2024
Works with:
95K+
Overview
Stop copying and pasting data into your spreadsheet and take back control of your time. Apipheny is designed to save you from manual data wrangling by allowing you to create custom data connections to data sources that have an API.

An API is a raw data pipeline that anyone can tap into, and most websites/platforms have an API these days. Using APIs was a process normally reserved for developers, but thanks to Apipheny, no-coders can get the data connections and automations they need without needing to write any code.

To use Apipheny, just enter the API URL, parameters, key, and headers into the add-on, then then click "Run". You can also save your data requests and schedule them to run automatically on a time interval.

Read our tutorials to learn how easy it is to connect to the most common APIs: https://apipheny.io/tutorials/

Features:
- Connect API data sources to Sheets
- Choose from GET, POST, PUT, PATCH, and DELETE request methods
- Includes fields to enter API URL, headers, and body
- Includes JSON Parser/JSON Converter for spreadsheets
- Save your requests for easy access
- Schedule requests to refresh the data in your Sheet automatically (hourly, daily, weekly, or monthly)
- Choose which sheet your data is imported into
- Import JSON API data or CSV API data into Sheets
- Create custom OAuth 2.0 integrations
- Reference the value of any cell in the API URL, headers, or body
- Call the API request without leaving your sheets by using the custom =APIPHENY() formula
- Get multiple pages of results using our pagination feature
- Use our Response Viewer to preview, customize, and filter your API data before you import it

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 Sheets, then just automate that process by connecting your software platform's API with the Google Sheets™ API.

An API is just a data pipeline between two software using a universal format such as JSON or CSV. The process of connecting an external API to Google Sheets™ API is a technical process and requires code, but the Apipheny app makes it easier for non-technical people to use an API in 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.

It works with most APIs. Perfect for anyone who needs an easy and affordable data analysis software to pull API data into a spreadsheet, so you can visualize and manipulate the data however you'd like.

To import 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 your Sheets in just a few seconds.

The add-on includes support for JSON and CSV APIs, as well as GET, POST, PUT, PATCH, and DELETE request methods. Advanced features include the ability to schedule your API requests to refresh automatically every hour or every day, the ability to use our custom =Apipheny() function, and the ability to create an API request by referencing the value of a cell in your API request. Plus, if you need to call the API repeatedly to get all the results, you can automate it using our pagination feature. Or check out our newest feature, the ability to create custom OAuth 2.0 connections.

Don’t waste your time manually exporting and importing data into Sheets. Do it automatically and use the data to create custom reports, or connect the Sheet to a free data visualizer like 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.

Upon installation, enjoy a complimentary 14-day trial, granting you full access to all features, without the need for credit card information. Once your trial period concludes, you will automatically transition to our basic free plan. When you're ready to elevate your experience, explore our range of flexible pricing options available here: https://apipheny.io/pricing
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Apipheny - API connector will ask for the permissions shown below. Learn more
Apipheny - API connector will need access to your Google account
This will allow Apipheny - API connector to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Nihir Morzaria
August 30, 2023
This makes pulling data from an API much easier, doesn't need any real technical knowledge, as long as you can follow instructions, you'll figure this out. The developers are really responsive to suggestions and updates to make the app better are on the way. I love tools that you set up and forget about, and this is pretty much that. You set it up and you now have automated a process that would have been impossible or have required a lot of manual work before.
Is this review helpful?
Yes
No
Profile Picture
Lee Renshaw
January 18, 2024
Apipheny is a great tool for importing data from an API into your spreadsheet. I was having trouble getting it to work with a pretty specific service and the customer service team spent considerable amount of time helping me to trouble shoot the connection to get it to work for my use case. I can't recommend them enough. It's not often you find a company that provides this level of service. Thanks again!
Is this review helpful?
Yes
No
Profile Picture
Sohail Pathan
April 2, 2024
This is a great tool folks. I have used multiple APIs ApyHub and it just works so fine. For those who don't know about ApyHub: It's a catalog of 100+ APIs for processing simple to resource-intensive tasks. You can find some APIs which can help you in automating task in the sheet: https://apyhub.com/catalog
Is this review helpful?
Yes
No
Profile Picture
Sally Spacefox
April 26, 2024
This is not free. Once installed, it notifies you that this is a 14 day free trial. Scammy.
Is this review helpful?
Yes
No
Profile Picture
NorCal Nature
March 22, 2024
Good App, good service
Is this review helpful?
Yes
No
Profile Picture
Bangune Pade
June 8, 2023
Apipheny is a smooth and silently tool that allows tech and non-tech to import data to Google sheet for automation purposes. I've Imported data from EVM to spreadsheet. °FIVE STARS RATE
Is this review helpful?
Yes
No
Profile Picture
Reece Howe
August 10, 2023
Fantastic product and very easy to use
Is this review helpful?
Yes
No
Profile Picture
Jack Bird
January 2, 2023
Works awesome but not for all cases. I use it for my goodreads extraction. But also for my complex eCommerce web-scraping case I would suggest eScraper service for eCommerce.
Is this review helpful?
Yes
No
Profile Picture
Rob Salusbury
February 25, 2022
Extraordinarily useful! Very clever architecture which opens up incredible possibilities for dynamic web-enabled applications. Very handy for merging data in real time from REST APIs as well as many popular SQL databases. Outstanding!
Is this review helpful?
Yes
No
Profile Picture
Ritch Cuvier
July 22, 2022
The best tool to ever allow me to import and make get request, this tool even allow me to make get and post request this definitely will replace Pabbly connect. This tool even allow me to see and to schedule each request. Imagine having a postman that interact with your google sheet 🤩🤩🤩
Is this review helpful?
Yes
No
1-10 of 23
Search
Clear search
Close search
Google apps
Main menu