

The menu on the left contains a list of categories for the available APIs: To browse the available Twitter endpoints, first open the Twitter API documentation page: If you already know the Twitter API base URL and endpoint that you need, or you want to use the same example URL as us, just skip to Step 4. An endpoint is the last part of the API URL that tells the Twitter API what specific data to return back to you.

You can check if the data you need is available from the Twitter API by checking the API documentation to see what endpoints are available. If the data you need is not available via the API, then you’ll need to use another method such as scraping. In this section, we’ll show you how to browse the Twitter API documentation to find an API URL endpoint that retrieves the data you need from Twitter, if the data you want is available from the Twitter API. Step 4.) Choose your Twitter API endpoint Note: If the token/key that you generate has an expiration time, you will need to complete this same process again to get a new token when the old one expires. Your Bearer token will then be displayed in the response.Ĭopy and paste your Bearer token somewhere safe because you will need it in the next steps. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet. 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. Enter Twitter API Request into Apipheny.In this tutorial, you will learn how to connect Twitter to Google Sheets in 6 steps:

There’s a lot of different ways to export data from Twitter to Google Sheets. How to import data from Twitter into Google Sheets using the Twitter API
