Перенос данных из google таблицы на сайт

// BambooHR API details
const BAMBOOHR_API_KEY = '';
const BAMBOOHR_SUBDOMAIN = '';
 
// Google Spreadsheet details
const GOOGLE_SHEET_ID = '';
const GOOGLE_SHEET_INDEX = 4; // Change this the index of your sheet (0-based index)
 
function fetchPublicHolidays() {
  var doc = SpreadsheetApp.openById(GOOGLE_SHEET_ID);
  var sheet = doc.getSheets()[GOOGLE_SHEET_INDEX];
  var range = sheet.getDataRange();
  var values = range.getValues();
  var publicHolidays = [];
  for (var i = 1; i < values.length; i++) {
    var holidayDate = values[i][0]; // Assuming date is in the first column
    var holidayName = values[i][1]; // Assuming holiday name is in the second column
    publicHolidays.push({ date: holidayDate, holiday: holidayName });
  }
  return publicHolidays;
}
 
function uploadToBambooHR(publicHolidays) {
  var url = "https://api.bamboohr.com/api/gateway.php/<BAMBOOHR_SUBDOMAIN>/v1/reports/custom?format=json&onlyCurrent=true";
[
    {
        "id": 4,
        "type": "holiday",
        "date": "holiday.date",
        "name": "holiday.holiday",
        "location": "holiday.countryCode"
    },
]
  var existingHolidays = new Set();
  var newHolidays = [];
 
  for (var holiday of publicHolidays) {
    if (!existingHolidays.has(holiday.holiday)) {
      existingHolidays.add(holiday.holiday);
      var data = {
        type: "holiday",
        start: holiday.date,
        end: holiday.date,
        name: holiday.holiday,
        location: holiday.countryCode
      };
      try {
        var options = {
          "method": "post",
          "headers": headers,
          "payload": JSON.stringify(data)
        };
        var response = UrlFetchApp.fetch(url, options);
        console.log("Successfully uploaded " + holiday.holiday + " on " + holiday.date + " to BambooHR.");
      } catch (error) {
        console.error("Failed to upload " + holiday.holiday + " on " + holiday.date + " to BambooHR. Error: " + error.message);
      }
    } else {
      newHolidays.push({ date: holiday.date, holiday: holiday.holiday });
    }
  }
}
 
public BambooResponse getEmployees() throws IOException, InterruptedException {
HttpRequest httpRequest = HttpRequest.newBuilder()
.header("Accept", "application/json")
.header("Content-Type", "application/json")
.uri(URI.create(String.format("https://api.bamboohr.com/api/gateway.php/%s/v1/reports/custom?format=json&onlyCurrent=true", BAMBOOHR_SUBDOMAIN)))
.POST(HttpRequest.BodyPublishers.ofInputStream(this::createFieldsStream))
.build();
 
  HttpResponse<String> response = httpClient.send(httpRequest, HttpResponse.BodyHandlers.ofString());
  return objectMapper.readValue(response.body(), BambooResponse.class);
}
 
@SneakyThrows
private InputStream createFieldsStream() {
    return new FileInputStream(fields); //fields - json файл, содержащий список полей. Подробнее об этом рассказано ниже
}
 
function main() {
  try {
    var publicHolidays = fetchPublicHolidays();
    uploadToBambooHR(publicHolidays);
  } catch (error) {
    console.error("Error:", error.message);
  }
}