Import SEC Filings Data to Google Sheets

Login to RapidAPI here. If you don’t have an account created, you will need to click the Sign-up option and create one.

Search for SEC Filings API and click on the result selected below.

Click on the Subscribe to Test option and choose the plan you wish to subscribe to. The paid plans will allow you to make significantly more requests than the free plan, i.e., the Basic Plan.

Upon subscribing your API key will be generated and automatically added as one of the required parameters in the API documentation segment.

In the leftmost section of the API documentation, you will find the list of endpoints available with which you can import SEC filings data to Google Sheets.

For the purpose of this article, we will import SEC filings data to Google Sheets. To do so, simply click on SEC Filings in the list of API endpoints available.

In the centre section of the API documentation, you will find a list of query names and their parameters. While the required parameters will be automatically filled with default values, we can modify the query parameters to obtain data according to our preferences. 

For instance, to import SEC filings data of Amazon to Google Sheets, we need to change the Identifier value to Amazon’s stock ticker, i.e., AMZN or we can input Amazon’s central index key instead.

The Central Index Key (CIK) is a unique 10-digit number allotted by the United States SEC to any individual, company or foreign government that has filed disclosure with the SEC. To find an organization’s CIK, click here and input the organization’s name in the search box.

Once you have inputted the optional parameters click on Test Endpoint. If you have entered proper query values, you will find a success message at the rightmost section of the API documentation. 

Click on Code snippets and change the programming language from (Node.js) Axios→ Shell→cURL.

Copy the API endpoint URL and take note of the headers and their values. The same will be used later while using the Amigo Data extension to establish a connection between your sheets and the source from where data will be imported.

The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding. 

You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:

1. Open a new google sheet
2. Click on Extension→ Add-ons→ Get Add-on
3. Search for “Amigo Data” and install it.

Go to the Google Sheet in which you want the data to be pasted. Click on Extensions→Amigo Data→Connect

Select Custom API from the list of sources

Paste the API endpoint URL copied earlier under the API URL section. Select the Details tab and add the following headers along with their values noted earlier and click Preview.

Key: X-RapidAPI-Host
Value: last10k-company-v1.p.rapidapi.com

Key: X-RapidAPI-Key
Value: Your_Key_Value

Click on Flatten to present the data in separate columns. Once the data are separated into columns, click on Import.

Amigo Data Add-on will shortly import SEC Filings Data to Google Sheets and all the disclosures made by the concerned organization with the SEC will be displayed on your sheet.