Apipheny

Apipheny is a powerful no-code API connector that allows you to seamlessly import API data into Google Sheets or export data from Google Sheets to an API. This tool helps you sync data sources, automate data refreshes, streamline workflows, and most importantly, save time. Apipheny eliminates the need for copy and paste by making it easy to connect APIs to Google Sheets.

To install and start using Apipheny in Google Sheets:

1. Install Apipheny: Go to the Google app store and install the Apipheny add-on. No credit card is required, and you will never be automatically charged unless you decide to upgrade.
2. Open Apipheny: Open a Google Sheet, click on Extensions > Apipheny > Import API to open the API Connector.
3. Enter API Request: 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. Enter these details into Apipheny and click Run.
4. Automate: Save and schedule your API request to run automatically every hour or day, even when your Google Sheet is closed.

Apipheny supports multiple API request methods including GET, POST, PUT, PATCH, and DELETE. This flexibility allows you to perform a wide range of operations with your APIs directly from Google Sheets.

Apipheny offers a variety of features to enhance API data management in Google Sheets, including:

• Choose Method: Make GET, POST, PUT, DELETE, and PATCH API requests.
• Enter API URL: Call one or multiple API URLs at a time.
• Add Headers: Enter headers required to make your API request.
• Paginate: Support for Cursor, Next Page, Page Number, & Offset Limit.
• Reference Cell: Replace values in your API request with variables from your sheet.
• Customize: Append imported data, insert date and timestamp, and more.
• Save Requests: Save your API requests for easy access later.
• Schedule Requests: Schedule your API requests to refresh data automatically every hour, day, week, or month.
• Formula: Use the custom =APIPHENY() formula.
• Custom OAuth: Create custom connections to APIs that use OAuth 2.0.
• Filter Data: Use the Response Viewer to preview, customize, and filter your API data.

Apipheny offers several pricing plans to suit different needs:

• Free: $0/Month/User, includes 50 API Calls/Month, 5 Saved Calls/Sheet, and other basic features.
• Hobby: $8/Month/User, includes 500 API Calls/Month, 10 Saved Calls/Sheet, and additional features.
• Pro: $15/Month/User, includes 5K API Calls/Month, 15 Saved Calls/Sheet, and more advanced features.
• Business: $29/Month/User, includes 50K API Calls/Month, 30 Saved Calls/Sheet, and comprehensive features.
• Unlimited Lifetime Deal: $249 One-Time Payment, includes unlimited API Calls/Month, unlimited Saved Calls/Sheet, and all features.

All plans include features like GET, POST, PUT, PATCH, DELETE requests, request settings, custom OAuth, response viewer, pagination, cell reference, URL stacking, import/export, and support. Additionally, there are options for a 14-day free trial, a 7-day refund policy, and a 20% discount for annual billing.