Solutions · WordPress

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

1

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

2

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

3

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

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