How to Build a Live Leaderboard from Google Sheets in WordPress

Updated July 2026 • 7 min read • By Fahad Murtaza

A live leaderboard is one of the best showcases for the Google Sheets + TableCrafter combination: the organizer updates scores in Sheets, and the embedded WordPress table refreshes automatically every 60 seconds without anyone touching the site. This guide builds a complete leaderboard with rank column, score data bars, and top-3 status badges. WordPress powers 43% of all websites globally (W3Techs, July 2026), and TableCrafter bridges the gap between the data you collect and the tables your users need to see, no custom PHP, no dashboard access required for viewers, and no per-row limits on the free tier. The free version on WordPress.org supports CSV, JSON, Google Sheets, and Excel. Pro adds Gravity Forms, Airtable, Notion, WooCommerce, REST APIs, inline cell editing, export to CSV/PDF, role-based column visibility, and auto-refresh. Every table embeds on any page with a [tablecrafter] shortcode or the native Gutenberg block. In a 2024 study of business WordPress sites, 68% of teams needed non-admin users to update form data at least weekly (WP Engine Survey, 2024).

What Is the Architecture?

Your Google Sheet is the single source of truth. Organizers update it however they want, manually, via a form, or via a script. TableCrafter polls the sheet on a 60-second cache interval and re-renders the table for the next visitor after a change. The visitor sees near-real-time data without any page refresh mechanism needed on the frontend.

This setting persists across table rebuilds. If you change the data source later, you may need to revisit this step to remap columns from the new source to the existing table configuration.

This configuration interacts with any caching or CDN layer active on your WordPress installation. If you use WP Rocket, LiteSpeed Cache, or a CDN such as Cloudflare, flush the page cache after making this change to ensure the updated configuration is reflected in the cached HTML served to visitors. TableCrafter's server-side output is regenerated on the next uncached request.

Step 1: How Do I Structure the Google Sheet?

Create a sheet with these columns in row 1:

Rank | Name | Team | Score | Status

Column notes:

• Rank, a number you calculate in Sheets using =RANK(D2,$D$2:$D$100,0) in each row, where column D is Score. Alternatively, leave this out and let TC sort by Score descending to imply rank.
• Name, participant or team name.
• Team, optional grouping column.
• Score, numeric. No currency symbols or commas, keep it a plain number so TC can sort correctly.
• Status, a text badge column. Use a Sheets formula to auto-populate: =IF(C2=1,"Gold",IF(C2=2,"Silver",IF(C2=3,"Bronze",""))) where C2 is the Rank column.

Step 2: How Do I Publish or Connect the Sheet?

For a public leaderboard where scores are meant to be seen:

• Use File → Share → Publish to web → CSV as described in the public sheet guide.

For a private competition where only site visitors with the URL can see results, but you don't want the raw sheet exposed:

TableCrafter validates this configuration on save. If validation fails, the admin panel displays a specific error message identifying which field caused the problem. Correct the field value and save again without needing to restart the setup process.

After completing this step, verify the result by viewing the page as a logged-out visitor in an incognito window. This confirms the table behaves correctly for public visitors rather than reflecting admin-level permissions that may hide configuration issues during initial setup. Check both the rendered output and the browser console for any JavaScript errors.

• Use the API key method.

Step 3: How Do I Create the Data Source in TableCrafter?

1. Go to TableCrafter → Data Sources → Add New.
2. Choose your connection type (Public CSV or Private API).
3. Enter the URL or Sheet ID.
4. Set Cache duration to 60 seconds. This is the refresh interval, every 60 seconds, TC will fetch fresh data from Google when the next page request comes in.
5. Click Save and Fetch Preview to confirm columns are detected.

Step 4: How Do I Map Columns for Leaderboard Display?

In the column mapping interface:

• Rank, Type: Number, Sortable: yes
• Name, Type: Text, Sortable: yes
• Team, Type: Text, Filterable: yes (lets viewers filter by team)
• Score, Type: Number, Sortable: yes, Data Bar: enabled
• Status, Type: Text, Badge Mode: enabled

Configuring the Score Data Bar

In TC's column editor for Score, enable Data Bar and set:

• Min value: 0
• Max value: Auto (TC reads the max from the current dataset) or enter a known maximum like 1000 for a fixed-scale competition.
• Bar color: Choose a color that fits your site's palette. A blue-to-green gradient works well for scores.

Configuring Status Badges

In TC's column editor for Status, enable Badge mode and map values to colors:

• Gold → #FFD700 background, dark text
• Silver → #C0C0C0 background, dark text
• Bronze → #CD7F32 background, white text
• (empty) → no badge rendered

Step 5: How Do I Create and Configure the Table?

1. Go to TableCrafter → Tables → Add New.
2. Assign the leaderboard data source.
3. Set Default sort column to Score, direction Descending.
4. Set Rows per page to show all participants (or paginate for large competitions).
5. Enable Search so visitors can find specific players by name.
6. Enable Team filter if you mapped Team as filterable.
7. Disable Export if you don't want participants downloading the full score list.
8. Save the table. Note the assigned ID (e.g., 5).

Step 6: How Do I Embed on Your WordPress Page?

Edit the page where you want the leaderboard. In the Gutenberg editor, add a Shortcode block and paste the shortcode from Step 5. For a leaderboard with search and column filters:

[tablecrafter id="5" filter="true" search="true"]

For a fully automated leaderboard that shows the current top entries without any visitor controls, use the minimal form:

[tablecrafter id="5"]

Publish or update the page. The leaderboard is live and will reflect the current rankings from your Google Sheet on every page load (subject to the cache TTL you configured in Step 2). To verify the display is correct, view the page while logged out — the table should show the same data a visitor would see, with rankings sorted by your configured default sort column. If you configured auto-refresh in Step 4, wait one refresh cycle (the interval you set) and confirm the table updates in place without a page reload.

How Does Testing the Live Refresh Work?

1. Open the page in one browser tab.
2. In another tab, open the Google Sheet and change a score value.
3. Wait 60 seconds, then reload the WordPress page.
4. The updated score and recalculated rank should appear.

If the update does not appear after 70 seconds, check whether a caching plugin (WP Rocket, W3TC, NitroPack) is serving a cached page. Exclude the leaderboard page URL from full-page caching, or append a query string to bust the cache during testing: ?nocache=1.

What Is Advanced: Auto-Numbering Rank Without a Rank Column?

If you sort by Score descending and enable TC's Row number column option (under Table Settings → Display), TC automatically prepends a sequential row number to each row. For a simple competition where ties are not a concern, this eliminates the need for a Rank column in Sheets entirely.

The setting is stored in the WordPress options table under the table's configuration key. It does not modify the original data source and can be changed at any time without affecting the underlying records.

The column mapping you define here is stored as a JSON configuration in the WordPress database. You can export this configuration using the TableCrafter export tool and import it to another table or another site. This is useful when replicating a table layout across multiple pages or when migrating a table to a staging environment for testing before going live.