Apipheny

The product is a no-code API connector add-on for Google Sheets that imports data from APIs and automates refreshes to eliminate manual copy-paste and keep spreadsheets updated. It is for data, marketing, and operations users in businesses of all sizes, including individual consumers, who work with APIs and Google Sheets. It is delivered as a Google Workspace add-on installed from the app store and runs scheduled requests even when sheets are closed.

Key features

• GET POST PUT PATCH DELETE methods
• Custom OAuth 2.0 authentication
• Pagination handling
• Save and schedule requests
• Hourly/daily/weekly/monthly refresh
• Stack multiple URLs
• Run all requests at once
• Response viewer
• Parsing options
• =APIPHENY() formula with cell reference
• Request settings
• Import/export requests