Import Webull Data To Google Sheets

Install the Amigo Google Sheets add-on from the Google Workspace Marketplace to use the Webull API to import Webull data to Google Sheets.

Install the Amigo add-on

Alternatively, you can get it from Google Sheets.

• Open Google Sheets
• Go to Extensions→Add-ons→Get add-ons
• Search for Amigo and install it.

We’ll use a Webull API on RapidAPI to retrieve data from Webull and import them into Google Sheets.

Sign up or log in to RapidAPI.

Once you’re logged in, go to the Webull API documentation in RapidAPI.

Choose a subscription plan from the Pricing menu to use the Webull API to retrieve data from Webull to Google Sheets. You can opt for the Basic (free) plan and upgrade later should you need.

Click Endpoints to go back to the Webull API documentation and scroll down a bit. You will find your API key under the Header Parameters.

On the left side of the Webull API documentation, we’ll find a list of data types that we can retrieve using the Webull API.

Click on any one of the endpoint categories and select an API endpoint. For this tutorial, we will import short-interest data with the get-short-interest endpoint under the “stock” API.

In the required parameter section, enter the ticker ID of the stock you wish to import. 

Note: You can obtain the ticker ID of any stock by using stock/search endpoint.

Click the Test Endpoint button to run the Webull API request.

if the API is working and if the input parameter is valid, then we should see a success message along with the result of the API query.

The Webull API endpoint URL as well as the API headers which we’ll use to retrieve and import Webull data to Google Sheets can be found in the Code Snippets.

Change the language from (Node.js) Axios to (Shell) cURL from the dropdown menu.

Copy the URL excluding the apostrophes and also note the headers.

Go back to Google Sheets and launch the Amigo Data extension to import the Webull data to Google Sheets.

Select Custom API from the list of sources.

Enter the Webull API endpoint URL in the API URL field.

Then expand the Details tab and enter the following as headers (as given in the Code Snippets):

Header 1
Name: X-RapidAPI-Host
Value: webull.p.rapidapi.com
Header 2
Name: X-RapidAPI-Key
Value: Your_key
Replace Your_key with your RapidAPI key.

Then click the PREVIEW button to retrieve and preview the Webull data to import to Google Sheets.

Flatten the nested datasets and then click IMPORT.

The data from Webull will be imported into Google Sheets in a short while. Below is a snippet of the imported data.

You can likewise import other types of data from Webull to Google Sheets using the Webull API. Following are some other examples.

Rating-Pricing-Target data

Using the rating-pricing-target endpoint, you can import the data about the rating, price, and target of a particular stock. In the required parameters section, enter the tickerID of the stock that you wish to search for.

Company profile data

Using the get-company-profile endpoint, you can import data like key holders, key executives, insiders, and many more about a particular company. In the required parameters section, enter the tickerID of the company.