News Blog: WordPress & Joomla Extensions

How to synchronize a WordPress table with a Google Sheet?

google-sheet-synchro-wordpress

Possibly you are here looking for a way to easily synchronize your google tables with your wp tables and let me tell you that you are in the right place! Just here you will learn how with wp table manager you can synchronize and in this way have your tables on your wordpress page.

WP table manager is the only plugin that offers you a complete repertoire of tools for spreadsheets when creating tables, yes…! Like Excel ;).

This amazing plugin offers you other really excellent tools like the google spreadsheet synchronization, that allows you to synchronize your WP table with your spreadsheet just with a copy/paste and a click, yes… It sounds impossible but in this post, we are going to learn how to do it.

Prepare your Wordpress table for the synchronization

First of all, we should know how to create a table with wp table manager and it is really easy so… Let´s do it!

Go to Tables Manager > All tables on the left section and click on Create New > Table.

new-table

 

Now you will be able to see a spreadsheet with a lot of options at the top to edit the table and customize it as you like but for this example, we are not going to edit this table because we are going to synchronize it.

empty-table

 

The plugin offers you a lot of options as you can see here.

top-options

 

For the synchronization purpose, we are going to leave that spreadsheet in blank like the image and we are done here.

 

looking for the google sheet information

 

Now let’s say we have a google sheet with prices and services and we want to show it in our wp site, so we have created the wp spreadsheet.

 

As we can see there is a spreadsheet that we should show on our wp site in order to inform our clients, so let’s start. 

First, your google sheet has to be published so click on “publish to the web”.

 

Select the spreadsheet and “web page”.

 

Then you will get the link to publish your google spreadsheet, copy it.

 

Finishing the Wordpress Google sheets synchronization

 

We are almost done! We just have to paste the link in your wp table to finish the Wordpress Google sheets synchronization, go to the table that you have created before on Tables Manager > All tables and click on the table that you have created before, there will be a top panel, click on Import & Sync > Google Sheets.

google-sheet-option

 

These are the options to edit the structure of the table, we are going to go almost to the button for an option called “Spreadsheet link” In that textbox, we are going to paste the link for the google spreadsheet that we get from the "Publish on the web" and click on “Fetch data”.

fetch-data

 

Select the Auto Sync if you want, it is to automatically synchronize the google spreadsheet with your wp table and you won’t have to click on the “Fetch Data” button.

Set the “Fetch style” option, it is to copy the spreadsheet style from google sheets, so you won’t have to add the style to the spreadsheet again.

And you are done! The synchronization is finished ;).

 

Automatic Sync directly from Google Sheets

Now that we know how to connect and sync our Google Sheet to WP Table Manager, there is one feature that we just named but didn't talk about that at all, this is the Auto Sync.

auto-sync

That will enable the option to Auto Sync the Google Sheet with our Table automatically without having to click on Fetch Data every time, but now the question would be, how much do I want to wait for it to sync? The answer is: The decision is all yours ;)

You can define the time delay for your automatic sync from No delay to 48 Hours, meaning that you have a lot of options to choose to start from no delay so you won't have to wait for the sync to happen.

In order to define this delay, go to Tables Manager > Configuration.

 

configuration

In this section, go to Main Settings, you will see the Synchronization Delay option with a dropdown to select the time, click on the period that you want it to be synced, and finally, click on Save Settings, and we are done, your tables will be synced depending on the delay that you selected here.

 

save-settings

Then, the process will be as easy as enable the Auto Sync when Fetching the Google Sheet into your Table.

 

Modify your WP tables from your Google sheets page

Now that all your data has been synchronized, you are going to be able to edit your wp table from your google page.

For this example, we are going to post the table in an article and modify it from the google sheets page, first of all, we are going to create a post and add the Gutenberg block, go to Posts > Add New, click on “+” and look for the “Wp Table Manager” block.

 

Now select the table and click on “Publish…”

 

Now that the table has been published, it will look like this:

 

Just like the one that we have created in google sheets and what happens if we modify the prices from the Google Sheets page? Let’s see.

We are going to change the prices and set them to 255$.

 

Now let’s check the table, you will be able to see that the prices have been changed on your WP Table published.

 

And yes…! Now you have the possibility to allow your editors to manage the tables without giving them access to the wordpress administrator panel and you will have more comfort when creating your spreadsheets since you will use all the tools that you are familiar with as it is google sheets, As you could see WP Table Manager also allows you to send the styles of spreadsheets to your wordpress page and automatically synchronize after a certain period of time your spreadsheets so you won’t have to click on "Fetch data".

What are you waiting for? Go ahead and purchase your membership now here

3
New Gallery Manager in WP Media Folder Addon
Generate Galleries from Folders in the WordPress G...
 

Comments 4

Guest - Marco on Monday, January 06 2020 06:32

C'è un unico problema... wp table manager non esiste tra i plugin da installare.
Dove lo trovo?

C'è un unico problema... wp table manager non esiste tra i plugin da installare. Dove lo trovo?
Tristan on Monday, January 06 2020 08:42

Hi,

What do you mean? You have a membership and you're not available to install the plugin?

Hi, What do you mean? You have a membership and you're not available to install the plugin?
ASFPM on Monday, January 20 2020 16:13

How long is the sync period and how often will it sync? I have made changes on the Google Sheets side and it is not updating the styles to WPTables (I have Fetch Style on). Please advise.

How long is the sync period and how often will it sync? I have made changes on the Google Sheets side and it is not updating the styles to WPTables (I have Fetch Style on). Please advise.
Tristan on Tuesday, January 21 2020 06:14

You can define a synchronization delay from the settings, then it's triggered by WordPress. If you still have problems with synchronization don't hesitate to drop us a support ticket, the support team will find a solution.

You can define a synchronization delay from the settings, then it's triggered by WordPress. If you still have problems with synchronization don't hesitate to drop us a support ticket, the support team will find a solution.
Already Registered? Login Here
Guest
Tuesday, October 19 2021

Captcha Image