[Features] Let the script checks for available languages in the Spreadsheet

[ordonezgs]

The script actually only allows to have a stored var of available language. Let's look for a way to check the spreadsheet (this requires to calls to the api) for all the sheets (which are the languages).

[issue-label-bot]

Issue-Label Bot is automatically applying the label feature_request to this issue, with a confidence of 0.94. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[ordonezgs]

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/sheets#Sheet

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets#resource:-spreadsheet

[ordonezgs]

[Doing] ->> Need time

Generalized Proposed Solution:

var datos = null
var datos1 = []
function llamar(){
$.get("https://sheets.googleapis.com/v4/spreadsheets/1kW09NbMJUYU0nNRYUmwsoushZo7I-oQShCfr8hnr_hs/?key=ANY_KEY",function (data){
  datos=data;
  $.each(datos.sheets, function(k,v){
 if (k == 0){
   console.log("Default sheet not inserted into the Array")
 }else{   datos1.push(datos.sheets[k].properties.title);
      }
  }
        );
}
     );
}
llamar()

Returns:
datos1 = ["es-419", "de", "fr", "nl", "pt-BR"]