How do I sync Google Sheets with WordPress?
Publish the sheet from Google Sheets, paste its link into a Google Spreadsheet data source, and place the data source in a post or page with the Tabulizer Data Source block. The site reads the sheet when the page is served, so every edit made in Google Sheets shows up on the page - no export, no upload and no file on your server.
Step by step
The Google Spreadsheet Data Source
This article explains how to use Google Sheets as a data source for Tabulizer tables in Joomla and WordPress. It covers publishing sheets to the web, configuring the data source with Google Spreadsheet URL and Export Format settings, choosing between CSV and HTML export formats, specifying which worksheet to read, and troubleshooting common issues like HTML read as CSV errors, wrong worksheets, and missing edits. It also explains caching, republishing delays, and why private sheets cannot be accessed.
Data Sources · Read the guide
How to create a Dynamic Table
This article explains how to create a dynamic table in WordPress that automatically displays current data without manual post editing. It covers the Tabulizer Table block, the New Dynamic Table wizard, and the concept of data sources stored under Tabulizer › Data Sources. The article details Step 2 (Data source title and Source Type selection), Step 3 (Connection, SQL query, Add header row, Empty Results Message), Steps 4-5 (Ruleset archive and Ruleset), and the resulting tabulizer data source tag format. It also explains caching, table captions, server-side loading, and other advanced settings available on the full Data Sources page.
Wordpress Guides · Read the guide
The Tabulizer Data Source Block
The Tabulizer Data Source block is a WordPress block for displaying existing data sources as tables in posts, pages, and page builders without using the wizard. It explains how to find and select data sources from a dropdown list, configure optional user parameters (user_param_1 through user_param_5) with type specifications, handle empty results, and use the block alongside the Tabulizer Data Source widget and page builder elements. It covers parameter substitution, caching, and how multiple blocks can display the same data source with different parameter values.
Wordpress Guides · Read the guide
See it working
- Feature: Reading Local & Remote Data Sources
- Feature: Dynamic vs Static Content
Have a different question?
The knowledge base covers every wizard, data source and option, and we are happy to answer anything it does not.
All solutions Contact us