Sticker Sticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker
Articles

How to embed Google sheets to WordPress using Sheets to WP Table Live Sync plugin – best WordPress table plugin

How to embed Google sheets to WordPress using Sheets to WP Table Live Sync plugin – best WordPress table plugin

There are ample WordPress table plugins available but today we are going to show you how to embed Google Sheets to WordPress using the WP Table Live Sync plugin. And discuss why this plugin stands out from the crowd.

Suppose you have a travel website. You want to show all the data as to the timings of your plane, bus and train schedules. However, showing so much data can be a daunting task. Because showing this much information in an organized manner can be complicated.

However, you can easily solve this problem using a table. You can show all your data in a table. If you are using WordPress on your site, then we have the best WordPress table plugin for you. ” Sheets to WP Table Live Sync”. This one-of-a-kind plugin helps you to import data from your Google spreadsheet and export it into the WordPress table. That means it has an auto-sync feature.

Once you update your Google sheet, it automatically updates on WordPress without touching anything. The sync is always live. So, today we are going to show how to embed Google sheets to WordPress. Let’s begin, shall we?

Table of content

How to install Google Sheets to WP Table Live Sync?

To embed Google Sheets to WordPress you need to install the plugin. Installing the Google Spreadsheet to WP Table Live Sync Plugin is very easy and simple. You can easily install this plugin just like any other WordPress Table plugin. Moreover, you can install this plugin right on your website.

To install the plugin navigate to WP Admin–> Plugins–> Add New. You need to type Google Sheets to WP Table Live Sync. You will find the WP Table plugin. Install and activate the plugin.

How to embed Google sheets to WordPress using Sheets to WP Table Live Sync plugin – best WordPress table plugin
Sheets to WP Table Live Sync Plugin

How to use Google sheets for WordPress Table Live Sync Plugin?

When you are done installing the WordPress plugin, you need a guide on how you can easily create the table that will fetch the data from your Google Spreadsheet.

Starting with your first table

So, we are going to start with creating your first table using this Google Spreadsheet to the WordPress plugin.

Hopefully, you have a Google SpreadSheet already created. Otherwise, you need to create an excel sheet using Google Spreadsheets. However, we prefer you to use an existing one because the existing one will have more data.

After creating the sheet, click on the File option and click the Publish On The Web button. It will publish your sheet to the web and it will be easily accessible.

Publishing to Google Sheets to WordPress Table Live Sync
Google Sheets to WordPress Table Live Sync

Choose Entire Document and select Publish.

Publishing to Google Sheets to WordPress Table Live Sync
Publishing to Google Sheets to WordPress Table Live Sync

For you to customize the table right from your WordPress dashboard you need to give editor access. You need to click the Share button and give the Editor access.

Copying to Google Sheets to WordPress Table Live Sync
Copying to Google Sheets to WordPress Table Live Sync

Go back to the WordPress dashboard. There navigate to WP Admin–> Sheets to Table –> Create Table.

To make your WordPress table unique you need to pick a name. Select the Google Spreadsheet option from the drop-down box. Now, enter the URL on the sidebar. Click on the Fetch Data button to continue.

Fetch data from Google Sheets to WP Table Live Sync plugin
Fetch data from Google Sheets to WP Table Live Sync

You will see the table is exported.

Google Spreadsheet to WP Table Live Sync
Exported Table

After the table is exported you can go to Display Settings and,

  • Enable to show the table title
  • Select default rows per page
  • Enable info block
  • Show X entries
  • Swap filters
  • Swap bottom elements.
Google Spreadsheet to WP Table Live Sync
Display Settings of SWPTLS

If you go to Sort & Filter, you will find some options there as well,

Sort and filter for Google Spreadsheet to WP Table Sync
Multiple options of Sort & Filter of SWPTLS

If you navigate to Table Tools you will see that you can select how to import the table. Like CSV, JSON, PDF, Excel, Print, etc. Click on Save Table to finish.

Tools in Google Sheets to WordPress Table Sync. Embed Google Sheets to WordPress.
Tools in Google Sheets to WordPress Table Sync

Managing the table

When you go to Sheets to Table –> Manage Table, you will find the shortcode for the table you created, for that table which you can use to insert the table on any page.

Manage tables in Google Sheets to WordPress Table Live Sync plugin
Manage tables

Also, you can update the table,

Update Google Sheets to WordPress Table Live Sync plugin Embed Google Sheets to WordPress
Updated Table

While you can delete the table from here as well.

Delete Google Sheets to WordPress Table Sync Embed Google Sheets to WordPress
Delete Table

General settings

If you navigate to WP Admin–> Sheets to Table –> General Settings, you will find three options,

  • Asynchronous Loading, when you enable this feature to load the table in the frontend after loading all content with a pre-loader. This will help your website load fast.
  • Multiple Spreadsheet Tab, with this feature will let you choose and save multiple spreadsheet tabs
  • Table Connection: With this function will let you connect multiple tables in a single page.
link support Embed Google Sheets to WordPress
link support Embed Google Sheets to WordPress

That is how you can set up Google Sheets to WordPress Table Live Sync plugin.

Google Sheets to WordPress Table Live Sync Plugin Features

So, now you know how to embed Google Sheets to WordPress using the Google Sheets to WordPress Table Live Sync plugin. But that’s not all, this plugin has some unique features that set it apart from any other WordPress table plugin in the WordPress repository.

Also, as you can see from above, installing and using this WordPress table plugin is quick and simple. After you have imported the data from your Google Spreadsheet to the WordPress table. you don’t need to do anything else. Since this table plugin has the feature to automatically sync all the data.

That means when you add or update your Google SpreadSheet data, the data in the table on your WordPress site will update as well. How cool is that? This is just the tip of the iceberg. This plugin has other features as well.

Those features include,

🔄 Live Data Synchronization

💾 Leverage cache to ensure faster loading

[] Shortcode Support

⚙️ Pagination Support

🎲 Gutenberg Block

🖱Vertical scrolling

📝 Elementor Widget Support

⚙️ Unlimited row sync from Google sheet

🗃 Export table from CSV, Excel, PDF, JSON

🎨 6 pre-built table styles

📝 Custom CSS

🔥 And more.

Conclusion

Now you know how to embed Google Sheets to WordPress.

As we said earlier, showing a lot of data without any proper organization can lead to disaster. And when you can’t show your data accordingly, you will lose the interest of your users. Because they won’t get or find the desired data they are looking for and leave your site.

But, when you use a table to show these data, then you can convince your users. And when you have a table plugin like Sheets to WordPress Table Live Sync, then adding a table on your site won’t be a problem.

Leave a Comment

Subscribe to get product updates

Get exclusive updates on discounts, product updates, WordPress news & tips

Easy Video Reviews
X

{{startingCount}}
{{time(finishingCount)}}
{{trans(`You have no camera installed on your device or the device is currently being used by other application`)}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.limits))}}
{{trans('Seconds')}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.limits))}}
{{trans('Uploading video...')}}
{{send.message}}

{{trans('Upload video')}}

{{trans('Drag your files here or click in this area')}}
{{uploader.file}} {{uploader.size}} x