How to Build an Event Schedule from Google Sheets in WordPress

Updated July 2026 • 6 min read • By Fahad Murtaza

An event schedule is a perfect fit for Google Sheets + TableCrafter: organizers add events to the spreadsheet, and the WordPress page shows a filtered, sorted, always-current schedule without any CMS involvement. This guide builds a complete schedule with date-range filtering, location dropdown, and speaker search. 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. WordPress sites with interactive tables see 31% longer average session durations (Semrush, 2024).

Step 1: How Do I Structure the Event Sheet?

Create a Google Sheet with these columns in row 1:

Date | Time | Event Name | Location | Speaker | Category | Registration URL

Data entry notes:

• Date, use a consistent format. ISO format YYYY-MM-DD (e.g., 2026-09-15) sorts correctly as text and as a date type. If your team prefers MM/DD/YYYY, TC can handle it, but set the column type to Date and specify the input format.
• Time, plain text like 2:00 PM works fine. TC does not sort by time independently unless you combine it into a datetime column.
• Event Name, the name shown to visitors.
• Location, use exact, consistent spelling. Main Hall and Main hall become two separate filter options.
• Speaker, one name per cell for simple schedules. For multi-speaker events, use a semicolon-separated list and note that filtering by speaker will match the whole cell string.
• Category, Workshop, Keynote, Panel, Networking, etc. This drives the category filter dropdown.
• Registration URL, full URL including https://. TC renders this as a clickable link when the column type is set to URL.

Step 2: How Do I Connect the Sheet to TableCrafter?

For event schedules, whether to use public or private connection depends on whether registration URLs or speaker details are sensitive:

• Public conference agenda with public speakers and open registration → use the public CSV method.
• Internal company all-hands schedule or private event → use the private API method.

In either case, set cache duration to 60 seconds so last-minute room changes appear on the site quickly.

Test this step while logged in as a user with the target role to confirm the expected behavior. Logged-in admin users always see all columns and all rows regardless of role restrictions, which can mask visibility issues during initial configuration.

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.

Step 3: How Do I Map Columns?

In the TC data source column mapping:

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.

• Date, Type: Date. This enables TC's date-range filter. Set display format to match your audience's regional preference (MM/DD/YYYY for US, DD/MM/YYYY for UK, etc.).
• Time, Type: Text. Not date, unless you want time-of-day sorting.
• Event Name, Type: Text, Sortable: yes.
• Location, Type: Text, Filterable: yes. TC will build a dropdown of distinct location values automatically.
• Speaker, Type: Text, Searchable: yes (appears in the search index).
• Category, Type: Text, Filterable: yes. TC builds a category dropdown.
• Registration URL, Type: URL. TC renders this as a clickable button or link. Set the link label to Register in the column settings.

Step 4: How Do I Create the Table?

1. Go to TableCrafter → Tables → Add New.
2. Assign the event schedule data source.
3. Set Default sort column to Date, direction Ascending. Visitors see upcoming events first.
4. Enable Date range filter, this adds a from/to date picker above the table. Visitors can filter to a specific weekend or conference day.
5. Enable Location filter dropdown.
6. Enable Category filter dropdown.
7. Enable Search so visitors can find a specific speaker or event name.
8. Set Rows per page. For a full conference schedule with 50+ sessions, pagination of 20 per page with the filters helps navigation. For a small event with 10 sessions, show all rows.
9. Save the table. Note the ID (e.g., 7).

Step 5: How Do I Embed the Schedule?

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

Add this shortcode to your event page. The date range picker, location dropdown, and category dropdown will render above the table automatically because they were enabled at the table configuration level.

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.

When testing this feature, verify the result while logged in as a user with the target role, not as an admin. WordPress administrators see all rows and columns by default, which means admin accounts will not reflect role-restricted configurations during testing.

The configuration you set here applies to every visitor who loads a page containing this table, regardless of whether they are logged in. Role-specific overrides for columns and rows are a separate layer and do not replace these global display settings. Apply global settings first, then add role restrictions as needed for tables that serve multiple user types.

How Do I Add Events: The Ongoing Workflow?

Once the table is live, adding a new event requires exactly one action from the organizer:

1. Open the Google Sheet.
2. Add a new row with the event details.
3. Done. The table on the WordPress page reflects the new event within 60 seconds.

No WordPress login. No page editing. No republishing. This is the core value proposition of the Sheets-as-CMS approach for event schedules.

This applies to all users who can view the table, regardless of role. Role-specific overrides can be set per column under the column Visibility settings. The table-level setting acts as the default for any column without a role override.

This step completes the connection between your data source and the TableCrafter table engine. Once saved, the plugin caches the connection credentials in the WordPress options table and uses them on every subsequent page load. If you update the source configuration later — for example, rotating an API key or changing a sheet URL — return to this step, enter the new value, and save again. The table updates immediately on next load without any shortcode changes.

How Does Handling Past Events Work?

TC does not automatically hide past events, but you have two options:

If this step produces unexpected output, check the source data directly in the connected system. TableCrafter passes data through without modification — if a cell displays an unexpected value, the source record contains that value. Use the TableCrafter debug log (Settings > Advanced > Debug Mode) to trace the exact query sent to the source and the raw response received, which narrows the diagnosis to either a source-side or rendering-side issue.

• Delete past rows from the sheet. Simple, but you lose the history.
• Add a Status column with values Upcoming / Past and use a Sheets formula to auto-populate it: =IF(A2<TODAY(),"Past","Upcoming"). Then in TC, set the default filter for Status to Upcoming. Visitors see only upcoming events by default, with the option to change the filter to see past events.

How Does Mobile Display Considerations Work?

Event schedules often have many columns that don't fit on a phone screen. In TC's table settings, use Column priority to designate which columns are hidden first on smaller screens:

Changes take effect immediately after saving. No cache flush or page refresh is required for the new configuration to apply to all shortcode instances of this table.

The shortcode accepts all column and filter settings defined in the table builder as defaults, but you can override individual parameters inline. For example, `[tablecrafter id="1" per_page="25"]` overrides the default rows-per-page setting for this specific embed without changing the saved table configuration. This lets you reuse one table definition across multiple pages with different display requirements.

• Priority 1 (always visible): Event Name, Date
• Priority 2 (hidden on mobile, visible on tablet): Time, Location
• Priority 3 (desktop only): Speaker, Category
• Priority 4: Registration URL (move to a detail row that expands on mobile tap)