Bosch Professional 5 TOOL KIT 12V GSR/GST/GOP/GKS/GSA 3X3 XLB

<ul id="products" class="brxe-block cta-section-papa__options-wrapper"></ul>

<script src="https://cdnjs.cloudflare.com/ajax/libs/axios/0.21.1/axios.min.js"></script>
<script>
    // Your Google Sheets ID and API key
    const SHEET_ID = '1yfivXQj0vmJjUpXqTMNbpoYTtT3t8j9TK_dv-cmbO4Q';
    const SHEET_NAME = 'API: Sellers';
    const API_KEY = 'AIzaSyAueq1JUzAJEh-__oxjGk5AkUz1phGAs4A';
    const PRODUCT_IDS_TO_DISPLAY = ['3531303775205349044']; // Array of product IDs to display

    // Fetch data from Google Sheets
    async function fetchSheetData() {
        try {
            const response = await axios.get(`https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}/values/${SHEET_NAME}?key=${API_KEY}`);
            //console.log('Sheet data fetched:', response.data.values);
            return response.data.values;
        } catch (error) {
            console.error('Error fetching sheet data:', error);
            return null;
        }
    }

    // Render data to the webpage
    async function renderProducts() {
        const data = await fetchSheetData();
        if (!data) {
            console.error('No data returned from fetchSheetData');
            return;
        }
        const productsContainer = document.getElementById('products');

        // Clear the container before adding new elements
        productsContainer.innerHTML = '';

        data.slice(1).forEach(row => { // Skip the header row
            const productId = row[0]; // Assuming product ID is in the first column

            if (PRODUCT_IDS_TO_DISPLAY.includes(productId)) {
                //console.log('Processing row:', row);

                // Create list item for each product
                const productItem = document.createElement('li');
                productItem.className = 'product';

                // Create anchor tag to wrap the title and price
                const sellerLink = 		document.createElement('a');
                sellerLink.href = row[10]; // Seller URL
              sellerLink.className="brxe-text-link cta-section-papa__link";

                // Create span for the product title
                const title = document.createElement('span');
                title.className = 'product-title';
                title.textContent = row[17]; // Product title

                // Create span for the price
                const price = document.createElement('span');
                price.textContent = `${row[12]} kr`; // Product price and currency

                // Append title and price to the anchor tag
              	sellerLink.appendChild(price);
                sellerLink.appendChild(title);
                

                // Append the anchor tag to the list item
                productItem.appendChild(sellerLink);

                // Append the product item to the container
                productsContainer.appendChild(productItem);
            }
        });
    }

    // Call the function to render products when the page loads
    document.addEventListener('DOMContentLoaded', renderProducts);
</script>

#products{
  align-items:stretch;
  display:flex; 
  flex-direction:column;
  width:100%;
  list-style:none;
  max-width:50rem;
}