API Connector for Google Sheets

API Connector for Google Sheets

Sync data sources and automate data refreshes within Google Sheets, streamline workflows, and most importantly - save time. Apipheny is a powerful no-code API connector that makes it easy to connect APIs to Google Sheets.

Say goodbye to copy and paste. ✌️

Connect APIs to sheets & boost productivity.

• Most modern platforms & websites have an API, which is a raw data pipeline.
• We can use APIs to do things like extract data, or send updates.
• Apipheny makes it easy to connect APIs to Google Sheets.

⭐️ ⭐️ ⭐️ ⭐️ ⭐️ 4.6 (52) • 90,000+ installs

How it works 👇

Apipheny is a Google Sheets add-on that needs to be installed in the Google app store. After installing Apipheny, you can open it in your Google Sheet by clicking Extensions.

1.
1. Start by installing Apipheny, a Google Sheets extension.

Click here to install Apipheny. There's no credit card required and you will never be automatically charged anything unless you decide to upgrade.

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 the API Connector.

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, endpoint, parameters, key, and headers.

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

Lastly, choose your method (GET, POST, PUT, PATCH, DELETE), enter your API details into the dedicated fields in the Apipheny add-on, and click Run.

After making a successful request, save and schedule your API request to run automatically every hour or day, even when your Google Sheet is closed.

If you want to do a quick test with Apipheny, try this URL:
Copy Text
Just copy and paste this API URL into Apipheny and click Run.
After you install Apipheny first, of course:

Features

to make your life easier.

Methods

Choose Method

Make GET, POST, PUT, DELETE, and PATCH API requests.

Learn More
API URL

Enter API URL

Call one or multiple API URLs at a time.

Learn More
Headers

Add Headers

Enter headers required to make your API request.

Learn More
pagination

Paginate

Cursor, Next Page, Page Number, & Offset Limit.

Learn More
Reference cell value

Reference Cell

Replace values in your API request with variables from your sheet.

Learn More
settings

Customize

Append imported data, insert date and timestamp, and more.

Learn More
saved requests

Save Requests

Save your API requests for easy access later and access them in the Manage tab.

Learn More
schedule requests

Schedule Requests

Schedule your API requests and your data will refresh automatically every hour, day, week, or month.

Learn More
formula

Formula

Use the custom =APIPHENY() formula.

Learn More
custom-oauth2

Custom OAuth

Create custom connections to APIs that use OAuth 2.0.

Learn More
response-viewer

Filter Data

Use the Response Viewer to preview, customize, and filter your API data.

Learn More

Don’t see a feature you need? Just let us know.

Sync your data, without breaking the bank.

Apipheny is an affordable API connector that can be used in conjunction with or as an alternative to other data collection and automation tools. If you’re not sure whether Apipheny is the right solution for you, just message us and let us know what you’d like to accomplish.
Free
$0
/month/user
50 Calls/Mo
5 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Get Cell Value
URL Stacking
Import/Export
Support
Continue
Hobby
$5
/month/user
500 Calls/Mo
10 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
Upgrade

* within Google’s limits.

24/7 Cancellation

Cancel your subscription anytime in the billing portal.

7-Day Refund

Try it risk free. We offer a 7-day refund for any reason.

20% Discount

When you choose annual billing during checkout.

14-Day Free Trial

Try all features free for 14 days. No credit card required.

Start free trial

✅ Trusted by 90K+ users

to be more productive.

🤠 Made for data wranglers, automaters, & data-driven teams.

Call APIs in Google Sheets

Apipheny is a powerful data automation tool that makes it easy to pull API data into Google Sheets from JSON and CSV API sources.

No Scripts Required

Apipheny is a code-less, universal API connector 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 and privacy approval process. We don't have access to any of your data and the add-on only requires basic permissions to run.

Integrate Any API

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

Affordable Alternative

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

Like Magic

Work with your APIs directly in Google Sheets. Manipulate the data in Sheets or integrate your Sheet with a data visualizer like Looker Studio. There are no limits. Great for marketers, SEO consultants, and data analysts.

What is an API?

An Application Programming Interface is a raw data pipeline that allows two programs to talk to each other.

Learn More

Find APIs to connect to

Read out tutorials to learn how to use Apipheny to connect to popular APIs, step-by-step.

Get Started

Free APIs for testing

Browse our list of API URLs you can use for testing that do not require authentication.

Browse APIs