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:
- Log in to RapidAPI and generate the API key
- Choose the endpoint
- Install the Amigo Data Add-on
- 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.
Click on Subscribe to Test and select the Basic Plan to obtain the API subscription without incurring any costs.
Once subscribed, your API key will be automatically generated in the API documentation section beside the list of endpoints that can be used.
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.
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
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.
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.
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.
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:
- Open a new google sheet
- Click on Extension→ Add-ons→ Get Add-on
- 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
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: finance-social-sentiment-for-twitter-and-stocktwits.p.rapidapi.com
Key: X-RapidAPI-Key
Value: Your_key
Flatten the data until it’s divided into separate columns along with relevant headings and click Import.
In a few minutes, the data imported will be displayed on your Google Sheets as shown below.
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