==============================dynamic carousel from google sheet ===========================
<script>
    (function() {
        var DOC_KEY = '1D0AzyzWhREOJ_vbUkLHe09YNSjG4b0IZnhe6T6S79tw';
        var API_KEY = 'AIzaSyDB7Mk0_X06DqZHWlllSOont--5XAZ4tao';
        var SHEET_PAGE = 'Sheet1';
        var SHEET_SCOPE = '!A2:D40';

        function fillDynamicContent(dataArray) {
            console.log(dataArray);

            var carousel = document.querySelector('.adoricCustomProductsCarousel');
            var thumbTemplate = carousel.querySelector('.slider-item.tmp-cloned').cloneNode(true);
            carousel.innerHTML = '';
            carousel.appendChild(thumbTemplate);
            dataArray.forEach(function(pr) {
                var duplicateThumb = thumbTemplate.cloneNode(true);
                duplicateThumb.querySelector('IMG.inner-element').src = pr[0];
                duplicateThumb.querySelector('SPAN.adoricCustomTitle.inner-element FONT').innerText = pr[1];
                duplicateThumb.querySelector('.element-button.adoric-slider-item-inner A').href = pr[3];
                duplicateThumb.querySelector('SPAN.adoricCustomPrice.inner-element').innerHTML = pr[2];
                carousel.appendChild(duplicateThumb);
            });
        }

        var URL = "https://sheets.googleapis.com/v4/spreadsheets/" + DOC_KEY + "/values/" + SHEET_PAGE + SHEET_SCOPE + "?key=" + API_KEY;
        var data = null;
        var xhr = new XMLHttpRequest();
        xhr.addEventListener("readystatechange", function() {
            if (this.readyState === 4) {
                var result = JSON.parse(this.responseText);
                var dataArray = result.values;
                console.log(dataArray);
                if(dataArray.length > 4) {
                    fillDynamicContent(dataArray);
                }

            }
        });
        xhr.open("GET", URL);
        xhr.setRequestHeader("cache-control", "no-cache");
        xhr.send(data);
    })();
</script>