Full Circle Apps

To pull the winning names from your Google Sheet directly into your **GeneratePress** site (or any Shopify/Custom Extension front-end), you can use a **Fetch API** script. This allows your blog to update the "Current Winners" live without you having to edit the HTML manually.

# # # 1. Prepare the Google Sheet

1. In your Google Sheet, go to **File > Share > Publish to web**.
2. Select the **Scoreboard** tab and choose **Comma-separated values (.csv)**.
3. Copy the generated URL.

# # # 2. The JavaScript Snippet

Add this code to your GeneratePress site using a **Hook Element** (set to `wp_footer`) or directly into your Shopify `theme.liquid`.

```javascript
async function updateSportsWinners() {
const csvUrl = 'YOUR_PUBLISHED_CSV_URL_HERE';
const displayElement = document.getElementById('winner-display');

try {
const response = await fetch(csvUrl);
const data = await response.text();
const rows = data.split('\n').map(row => row.split(','));

// Assuming Winner Names are in Column 5 (Index 4)
// Rows 2, 3, 4, and 5 are 1st, 2nd, 3rd, and Final
const winners = {
q1: rows[1][4],
q2: rows[2][4],
q3: rows[3][4],
final: rows[4][4]
};

displayElement.innerHTML = `

Q1: ${winners.q1} |
Q2: ${winners.q2} |
Q3: ${winners.q3} |
FINAL: ${winners.final}

`;
} catch (error) {
console.error('Idplrbot Sync Error:', error);
}
}

// Run on load
document.addEventListener('DOMContentLoaded', updateSportsWinners);

```

# # # 3. The HTML for your Blog/Extension

Place this HTML wherever you want the names to appear (Sidebar, Header, or Homepage):

```html

Loading live winners from ...



.winner-ticker {
background: ;
color: ;
padding: 10px;
font-family: 'Courier New', Courier, monospace;
border: 1px solid #333;
text-align: center;
}
.winner-ticker span { margin: 0 15px; }


```

---

# # # Integration via AdHeart & Shopify

* **AdHeart.me / MyShopify:** If you are running ads to this pool, you can use this snippet to show "Social Proof" by displaying real-time winners. This increases trust for the "4.5 Unit" buy-in.
* **Extension Performance:** Using the `async/await` method ensures that your site speed isn't affected while the script fetches the payload data from the sheet.

# # # Pro-Tip for Idplrbot

If you want the bot to "shout out" the winners on your blog's comments section or a Discord/Telegram channel, you can hook the CSV data into a **Zapier** or **Make.com** trigger that monitors the "Winner Name" cells for changes.

**Would you like me to help you set up the CSS to make this look like a scrolling "ticker tape" across the top of your blog?**

A new US Postal Service plan to raise cash could cost the agency its biggest customer | CNN Business For years, a huge Amazon contract has been one of the few bright spots in the US Postal Service’s finances. But now the USPS plans to offer those last-mile services to additional customers to stem billions in ongoing losses – a move that risks losing its biggest customer.