![Import JSON to Google Sheets For Free [No Code] | Apipheny (1)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/Apipheny.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (1)")
Sync JSON data sources and automate data refreshes within Google Sheets, streamline workflows, and most importantly - save time. Apipheny is a powerful no-code JSON API connector that makes it easy to import JSON data to Google Sheets.
Get it free ➜
Say goodbye to copy and paste. ✌️
Import JSON to sheets & boost productivity.
![Import JSON to Google Sheets For Free [No Code] | Apipheny (2)](https://i0.wp.com/workspace.google.com/static/img/marketplace/en/gwmBadge.svg? "Import JSON to Google Sheets For Free [No Code] | Apipheny (2)")
⭐️ ⭐️ ⭐️ ⭐️ ⭐️ 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.
![Import JSON to Google Sheets For Free [No Code] | Apipheny (3)](https://i0.wp.com/apipheny.io/wp-content/uploads/2021/11/apipheny-google-workspace.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (3)")
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 For Free [No Code] | Apipheny (4)](https://i0.wp.com/apipheny.io/wp-content/uploads/2020/03/apipheny-1.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (4)")
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.
![Import JSON to Google Sheets For Free [No Code] | Apipheny (5)](https://i0.wp.com/apipheny.io/wp-content/uploads/2020/03/api-data.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (5)")
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:
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.
![Import JSON to Google Sheets For Free [No Code] | Apipheny (7)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/Methods.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (7)")
Choose Method
Make GET, POST, PUT, DELETE, and PATCH API requests.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (8)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/API-URL.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (8)")
Enter API URL
Call one or multiple API URLs at a time.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (9)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/Headers.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (9)")
Add Headers
Enter headers required to make your API request.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (10)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/pagination.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (10)")
Paginate
Cursor, Next Page, Page Number, & Offset Limit.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (11)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/Reference-cell-value.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (11)")
Reference Cell
Replace values in your API request with variables from your sheet.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (12)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/settings.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (12)")
Customize
Append imported data, insert date and timestamp, and more.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (13)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/saved-requests.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (13)")
Save Requests
Save your API requests for easy access later and access them in the Manage tab.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (14)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/schedule-requests.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (14)")
Schedule Requests
Schedule your API requests and your data will refresh automatically every hour, day, week, or month.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (15)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/04/formula.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (15)")
Formula
Use the custom =APIPHENY() formula.
Learn More
![Import JSON to Google Sheets For Free [No Code] | Apipheny (16)](https://i0.wp.com/apipheny.io/wp-content/uploads/2023/07/pika-1690129080447-1x.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (16)")
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.
Import JSON to Google Sheets, without breaking the bank.
Apipheny is an affordable JSON importer 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 API Calls/Month
GET, POST, PUT, PATCH, DELETE
Request Settings
5 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Cell Reference
URL Stacking
Import/Export
Support
Continue
Hobby
$8
/Month/User
500 API Calls/Month
GET, POST, PUT, PATCH, DELETE
Request Settings
10 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Cell Reference
URL Stacking
Import/Export
Support
Pro
$15
/Month/User
5K API Calls/Month
GET, POST, PUT, PATCH, DELETE
Request Settings
15 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Cell Reference
URL Stacking
Import/Export
Support
Business
$29
/Month/User
50K API Calls/Month
GET, POST, PUT, PATCH, DELETE
Request Settings
30 Saved Calls/Sheet
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Cell Reference
URL Stacking
Import/Export
Support
Unlimited Lifetime Deal
$249
One-Time Payment
∞ API Calls/Month*
GET, POST, PUT, PATCH, DELETE
Request Settings
∞ Saved Calls/Sheet*
∞ Sheets*
Day/Week/Mo Refresh
Hourly Refresh
Custom OAuth
Response Viewer
=APIPHENY()
Pagination
Cell Reference
URL Stacking
Import/Export
Support
* 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.
Import JSON into Google Sheets
Apipheny is a powerful data automation tool that makes it easy to pull JSON API data into Google Sheets.
No Code Required
Apipheny is a code-less, universal JSON connector that is designed to save you time and money.
Privacy First
Every app that Google approves must go through a strict security and privacy approval process, including Apipheny.
Integrate JSON APIs
Apipheny uses Google Apps Script to help you import JSON data into your sheet.
Affordable Alternative
You don't need an expensive data integration/visualization platform to import JSON to Google Sheets. Do-It-Yourself with Apipheny.
Like Magic
Work with JSON directly in Google Sheets. Manipulate the data in Sheets or integrate your Sheet with a data visualizer like Looker Studio.
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
![Import JSON to Google Sheets For Free [No Code] | Apipheny (18)](https://i0.wp.com/apipheny.io/wp-content/uploads/2020/01/apipheny-logo-white-150x35-2-1.png "Import JSON to Google Sheets For Free [No Code] | Apipheny (18)"){kind=logo}
![Import JSON to Google Sheets For Free [No Code] | Apipheny (2024)](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mP8/h8AAvMB+NzmkbcAAAAASUVORK5CYII=)