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 Table Manager > Table Manager on the left section and click on “Create Table”.

 

Now you will be able to see a spreadsheet with a lot of options in the right section 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.

 

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

 

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 in 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 you wp table to finish the Wordpress Google sheets synchronization, go to the table that you have created before on Table Manager > Table Manager and click on the table that you have created before, there will be a panel on the right side where will appear a lot of options, click on “Table”.

 

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 and click on “Fetch data”.

 

Select the auto-synchronization 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 to yes, 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 ;).

 

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

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

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 21 November 2019

Captcha Image