Import Ultradea Data To Google Sheets

Reading Time: 4 minutes

This article will teach you how to import Ultradea data to Google Sheets. Market sentiment plays a huge role in determining the prices of tradeable securities including cryptocurrencies. Investors can get a brief idea of how bullish or bearish the market participants are in regard to a particular stock or cryptocurrency and make their investment decisions accordingly.

To import Ultradea data to Google Sheets, we follow the steps below:

  1. Log in to RapidAPI and generate the API key
  2. Choose the endpoint
  3. Install the Amigo Data Add-on
  4. Import the data

How to import Ultradea data to Google Sheets

Follow the steps given below to learn how to import Ultradea data to Google Sheets.

Step 1: Get the API key

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 Ultradea API and click on the result according to the snippet below.

Searching for Ultradea API using rapid API

Click on Subscribe to Test and select the Basic Plan to obtain the API subscription without incurring any costs.

Subscribing to the Ultradea API available

Once subscribed, your API key will be automatically generated in the API documentation section beside the list of endpoints that can be used.

API key

Step 2: Choose the API endpoint 

On the left-hand side of the page, you will find the list of API endpoints available from which you can import Ultradea data to Google Sheets.

List of API endpoints available

For the purpose of the tutorial, we will use an endpoint that provides us with the top 20 securities trending based on the number of posts on Twitter.

To access the endpoint click on Top Trending Tickers→ /get-social-trending/posts

Choosing the endpoint that provides us data regarding trending posts

By the list of endpoints available through which you can import Ultradea data to Google Sheets, you will find a section in which you can modify queries to filter the data that is to be imported. While some queries which are required are automatically filled, the optional parameters can be edited according to your preferences.

For instance, we will increase the limit from 10 to 20 to obtain a list of 20 securities ranked on the basis of posts in the last 24 hours on Twitter. To do so, just select the value of the query and fill in your desired value.

Query parameters and their values

Once you have inputted the optional parameters click on Test Endpoint. On the right side, you will notice a successful response to the data that you requested. 

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

Changing the format of the code

Copy the endpoint URL and take note of the headers. You will need to input these in the Amigo Data Add-on to import Ultradea Data to Google Sheets.

API endpoint URL

Step 3: Get Amigo Data Google Sheets extension

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.

Step 4: Import the data to Google Sheets

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

Accessing the Amigo Data Add-on

Select Custom API from the list of sources

List of sources to connect

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: finance-social-sentiment-for-twitter-and-stocktwits.p.rapidapi.com

Key: X-RapidAPI-Key
Value: Your_key

Adding the headers, specifying the key and their values

Flatten the data until it’s divided into separate columns along with relevant headings and click Import.

Raw data imported

In a few minutes, the data imported will be displayed on your Google Sheets as shown below.

Import Ultradea data to Google Sheets

Amigo Data allows users to set a refresh schedule that automatically updates the data imported to ensure that the user is provided with the latest data without any manual input. To learn how to automatically update your data at regular intervals and receive alerts for the same on your email or Slack channel, click here

In this article, we learned to import Ultradea Data to Google Sheets. To learn how to import data from other sources, check out our blog.

See Also

Here are a few other articles that you might find useful.

Get real time crypto prices in Google Sheets with Live Coin Watch API

Import Coin Metrics data to Google Sheets

Import Stripe Data to Google Sheets