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. Most websites and platforms have an API these days. This was a process normally reserved for developers, but thanks to Apipheny, anyone can get the data they need to automate their work.

To use Apipheny, enter the API endpoint, 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
- Use GET, POST, PUT, PATCH, and DELETE request methods
- Includes fields to enter API URL, headers, and body
- Includes JSON Parser/JSON Converter for spreadsheets
- Customize how arrays are imported into Google Sheets with flexible parsing options
- Save requests for easy access
- Schedule requests to refresh the data in your Sheet automatically (hourly, daily, weekly, or monthly)
- 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

If you're manually exporting JSON or CSV files from a software platform and pasting the data into Sheets, you'll save time and eliminate mistakes with an automatic connection.

It works with most APIs so you can visualize and manipulate the data however you'd like. 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.

On installation enjoy trial access to all features, without the need for a credit card. Once your trial concludes, you will automatically transition to our free basic plan. When you're ready to elevate your experience, explore our options here: https://apipheny.io/pricing

We recommend a private browser window for initial install to ensure everything goes smoothly. If there's any issue reach out to our support email and we'll have our team on it shortly. We're here for you every step of the way.