Apipheny is a Google Sheets add-on that simplifies the process of connecting to APIs and importing data without requiring code. It targets data wranglers, automaters, and data-driven teams who need to sync data sources and automate data refreshes within Google Sheets.
Key Features:
- No-Code API Connector: Import data from JSON and CSV APIs into Google Sheets without writing scripts.
- Wide Range of API Integrations: Connect to various APIs, including Binance, CoinMarketCap, Facebook, Github, Mailchimp, Shopify, and YouTube.
- Data Automation: Schedule API requests to run automatically every hour or day, even when Google Sheets is closed.
- Method Support: Supports GET, POST, PUT, PATCH, and DELETE methods.
- Parsing Options: Offers parsing options for data manipulation.
- Custom OAuth 2.0: Supports custom OAuth 2.0 for secure API connections.
- Pagination: Handles API pagination for large datasets.
- =APIPHENY() Formula: Allows using a custom formula for API calls.
- Save and Import/Export Requests: Save API requests for reuse and transfer them between accounts.
Use Cases:
- Data Analysis: Import data from various sources for analysis and reporting in Google Sheets.
- Marketing Automation: Automate data collection from marketing platforms like Facebook and Mailchimp.
- Financial Tracking: Track cryptocurrency prices using APIs like Binance and Coinbase.
- E-commerce Reporting: Import sales and product data from Shopify.
- Project Management: Integrate with project management tools like Harvest and Github.
