Automate Seeking Alpha Data Imports To Google Sheets

Reading Time: 5 minutes

In this article, we will learn how to automate Seeking Alpha data imports to Google Sheets using Amigo Data add-on. Using Seeking Alpha API, you can also import various kinds of data like stock quotes, stock-specific news, dividends data, and many more. Amigo Data gives you the flexibility to update your data automatically, and not only update the data but sent you alerts so that you can also stay abreast with the latest data wherever you are. Just set it up once and let Amigo Data do the job for you.

Shown below is a snippet of day watch market data with top gainers, losers, stocks in the news, and so on imported from Seeking Alpha to Google Sheets.

Day watch data from Seeking Alpha data to Google Sheets

To import Seeking Alpha data to Google Sheets using Seeking Alpha API, we will follow the steps below:

Seeking Alpha data imports to Google Sheets

Here’s the step-by-step guide to import Seeking Alpha data to Google Sheets.

Install the Amigo Data add-on

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Click here to install.

Install Amigo to import Seeking Alpha data to Google Sheets

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Generate the Seeking Alpha API key

We’ll be using a third-party API on RapidAPI to import Seeking Alpha data to Google Sheets. This API offers all the functionality while being easy to use.

Sign up to RapidAPI.

RapidAPI page to sign up

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

Learn how to automate seeking alpha data imports to Google Sheets

Click Pricing and subscribe to the API by choosing a subscription plan. We’ll choose the Basic plan. Upon subscription, we’ll be able to use the Seeking Alpha API and retrieve data to Google Sheets.

Go back to the API endpoints list by clicking Endpoints. Scroll down a bit to find your API key under the Header Parameters. This is the RadpiAPI key which also serves as the Seeking Alpha API key.

Choose an endpoint

On the left side is the list of all available data endpoints that we can use to import data from Seeking Alpha to Google Sheets. Select the one that you want to retrieve.

For this tutorial, we will import from get-day-watch endpoint. This endpoint provides us with different kinds of data for the day like top gainers, top losers, most active stocks and many more. 

Expand the market category and click market/get-day-watch.

Market day watch endpoint for Seeking Alpha API

This endpoint requires no parameter. So we can just go ahead and test the endpoint. Click the Test Endpoint option to run the query.

The success message indicates that the endpoints are functioning correctly. 

On the right side under Code Snippets, select Shell-> cURL from the dropdown menu.

Select the cURL from Shell

Copy the Seeking Alpha API endpoint URL excluding the apostrophes and also note the headers. This is the endpoint URL of the Seeking Alpha data to import to Google Sheets.

Seeking Alpha API endpoint URL and headers

Import data to Google Sheets

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

Launch Amigo to automate Seeking Alpha data imports to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the Seeking Alpha API endpoint in the API URL bar.

Pasting the endpoint

Then expand the Details tab and enter the following as headers:

Name: X-RapidAPI-Host, Value:

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Seeking Alpha API headers

Click the PREVIEW button.

Then flatten the nested datasets and then click IMPORT to pull the data from Seeking Alpha to Google Sheets.

Preview, flatten and import the data

The data from Seeking Alpha will be imported into Google Sheets in a few moments. Below is a snippet of the imported data.

A snippet of imported data

You can similarly import other types of data from Seeking Alpha API. Following are some other examples.

Dividend investing data

Using the market/get-dividend-investing endpoint, you can import dividend data like trending dividend stocks, dividend exdates, and more.

Stock fundamentals data

With the symbols/get-fundamentals endpoint, you can import fundamentals of a particular stock. In the required parameters section, enter the ticker symbol of a stock for which you want to fetch fundamentals data. You can go through the list of ticker symbols.

Similarly, you can also explore other endpoints. Seeking Alpha API has so much to offer. To explore more endpoints go through the documentation of Seeking Alpha API.

After importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.

There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data,  Coinmarketcap data, Nasdaq data, and many more. Visit our blog to find out the kinds of data you can import to Google Sheets.

Some related articles you may be interested in:

Get Real-time Stock Data In Google Sheets Using MarketStack API

Import CoinMarketCap Data To Google Sheets

Import Data From Nasdaq To Google Sheets

Leave a Reply