Method: At the top of the Apipheny sidebar, select the HTTP method ( GET or POST) required by your API endpoint. With the Import tab open, enter these details into the add-on: Now go back to your Google Sheet and make sure that the Apipheny add-on is open on the “Import” tab. Step 4.) Enter your JotForm API request into Apipheny Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.Īll API calls for JotForm should be made to the base domain if you are from Europe, or to if you are from the USA or from another country. In the dropdown list you should see Apipheny. There is a 30 day free trial included.ġ.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: Ģ.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more.
Step 1.) Install and open the Apipheny add-on for Google SheetsĪpipheny is an API connector for Google Sheets.
#GOOGLE JOTFORM HOW TO#
In this tutorial, I’ll show you how to connect the JotForm API to Google Sheets in 5 steps: We can use the JotForm API to import data from JotForm into Google Sheets. JotForm is an easy-to-use online form builder for every business. Connecting the JotForm API to Google Sheets