I’m working on a Google Sheets project and need help with coding. The goal is to retrieve data from an API, store it in Google Sheets, and perform analyses.
If anyone has experience with Google Sheets and programming and can assist, I would appreciate it.
Here is how you can pull from a Google Sheets AppScript:
Just call =FearGreed() from a cell
function FearGreed() {
var url = “https://fear-and-greed-index.p.rapidapi.com/v1/fgi”;
var headers = {
“contentType”: “application/json”,
“headers”:{“X-RapidAPI-Host”: “fear-and-greed-index.p.rapidapi.com”,
“X-RapidAPI-Key”: “XXXXXXXXXXXXXXXXXXXXXXXX”},
muteHttpExceptions: true,
request: “GET”};
var response = UrlFetchApp.fetch(url, headers);
var data = JSON.parse(response.getContentText());
Logger.log(data);
var PullDate = new Date ();
var PullTime= PullDate.toLocaleTimeString();
const object = {
Date: PullDate,
Time: PullTime,
Current_Score: data.fgi.now.value,
Rating: data.fgi.now.valueText,
One_Week_Ago: data.fgi.oneWeekAgo.value,
Week_Rating: data.fgi.oneWeekAgo.valueText,
One_Month_Ago: data.fgi.oneMonthAgo.value,
Month_Rating: data.fgi.oneMonthAgo.valueText,
One_Year_Ago: data.fgi.oneYearAgo.value,
YearRating: data.fgi.oneYearAgo.valueText
}
return Object.entries(object);
}
Hi,
I’m working on a Google Sheets project and need help with coding. The goal is to retrieve data from an API, store it in Google Sheets, and perform analyses.
If anyone has experience with Google Sheets and programming and can assist, I would appreciate it.
Thanks in advance!
Best regards,
Hello,
Yeah, this API has no examples. It’s a free API so just try using the API to get real values.
Regards.