Construct Table from Google Sheets
Integrate with Google Sheets
Ninja Tables version 3.0 has come up with some fantastic features that will fill your mind with joy. Now, you can import your Google sheet tables directly into Ninja Tables and whenever your Google Sheets data changes, it will be automatically reflected in Ninja Tables too.
Using Ninja Tables, you won’t have to do a single thing once you have established the connection. But the question is how can you do all that?
For demonstration purpose, we have created a Google Sheet data chart here for making you understand.
Now, let’s import it to Ninja Tables. To make this happen, Go to Ninja Tables from your WordPress dashboard sidebar. Click on ‘add table‘ from the top right corner of the dashboard.
Then, you will see that a pop-up window will appear. Select ‘Connect Google Sheets’ from the sidebar.
Give your table a name. It can be either your Google Sheet’s table name or anything you want.
To get the ‘data URL’ go back to your Google Sheet, then click on the File from the top bar and select ‘publish to the web’.
In the ‘Link’ segment, select your predefined sheet. In this case, it’s ‘Sheet 1’ that we have created for demonstration purpose.
Then select ‘Comma separated values’ from drop down, and click on the ‘publish’ button.
There is one more thing to do. In the ‘publish content and settings’ option, make sure that ‘automatically republish when changes are made’ is marked.
Now, copy the link and go back to your Ninja Tables’ dashboard and paste it in ‘data source URL’ and proceed to the next.
Select the entry fields you want to add, and save it. That’s how all your data will be automatically imported here.
Now, again go to your Google Sheet, add some more data here and check if the updated data are added automatically to your Ninja Tables.
But, in this case, you have to wait for 5 minutes after you are done adding the data. The reason is Google updates table data cache at every 5 minutes interval. Let’s fast forward the waiting process.
As 5 minutes over, go back to your Ninja Tables and reload the page. Now you can see the magic, there are now data rows at the bottom of the table that yo just have added 5 minutes ago.
That’s it, whenever someone updates or add any data in Google Sheet, those data will be added in Ninja Tables as well.
That’s all about the process of constructing tables from Google Sheets using Ninja Tables WordPress plugin.