To pull data from the Yelp API into Google Sheets without coding, you’ll first have to install and open the Apipheny Google Sheets add-on.
Apipheny is a no-code API integrator for Google Sheets that you can use to pull API into Google Sheets, make unlimited API requests, connect to unlimited APIs, save API requests, schedule API requests, and more. Click here for more information about Apipheny. There’s a 30-day free trial included, then it’s $19-$29/month.
1. Install Apipheny by opening the following link in on desktop and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746
2. After you’ve installed Apipheny, open a Google Sheet and then click on the Add-Ons option in the top menu. In the add-ons menu, you should see Apipheny. Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheets.
Your next step is to make sure you’re logged in to your Yelp account, then go to https://www.yelp.com/developers/v3/manage_app and in the Create App section, complete the App Name, Industry, Contact Email and Description fields:
After filling out the fields, click the Create New App button:
Your app has been created and your client id and API Key will be displayed:
Copy your Client ID and API Key somewhere safe because you will need them in the next steps.
In this section, we’ll show you how to browse the Yelp API documentation to find an API endpoint URL that retrieves the information you need from Yelp.
If you already know your Yelp API URL, or you want to use the same example URL as us, just skip to Step 4.
First, open the Yelp API documentation page: https://www.yelp.com/developers/documentation/v3/
The main page contains a structured view of the available endpoints for the Yelp API:
An example endpoint is the Transaction Search endpoint, that returns a list of businesses which support food delivery transactions:
The documentation for this endpoint contains a short description of the endpoint’s purpose, the HTTP method used (GET), the request URL, a table describing the accepted parameters and the expected response body:
After choosing your Yelp API endpoint, go back to your Google Sheet and make sure that the Apipheny add-on is open on the “Import” tab. With the Import Tab open, enter these details into the add-on:
Method: At the top of the Apipheny sidebar, select the HTTP method (GET or POST) required by your API endpoint. For this example, we are using the GET method.
API URL: In Step 3, we explained how you can find the Yelp API endpoint that you need. Now copy the complete URL into the Apipheny add-on, where it says API URL Path (JSON / CSV), followed by any GET parameters required for your query.
For this example, we are using the Business Search endpoint that returns up to 1000 businesses based on the provided search criteria. The corresponding URL for this endpoint is:
With this endpoint, you can modify the categories and location parameters according to your preference.
In the Headers section of the Apipheny add-on, add one row with the following key and value:
Header: Key: Authorization Value: Bearer <your_API_key>
For this header, <your_API_key> value is the token you generated previously, in Step 2. There should be a space between Bearer and <your_API_key>. Do not include the carrots “<>” around your API key.
Finally, click the Run button at the bottom of the Apipheny add-on and then wait for the Yelp API data to be imported into your Google Sheet:
After making a successful request to the Yelp API, try querying a different Yelp API endpoint, or try using one of the more advanced features in the Apipheny add-on, such as:
If you want to integrate the Yelp API data with Google Data Studio, just follow the same steps above and then connect your Google Sheet to your Google Data Studio report.