Having trouble finding out how to integrate Google sheets into WordPress?
While there are many useful WordPress plugins that allow you to add tables to your site, sometimes you need the full flexibility of Google Sheets and it’s best to integrate your table directly from Google Sheets.
This ensures that your spreadsheet data is always up to date, and for large spreadsheets, the data processing tasks are removed from your WordPress site server.
Fortunately, integrating Google Sheets into WordPress is quite easy – and in this article I’ll show you how.
I’ll give you a few different options, from the simplest integration directly from Google Sheets, to some WordPress plugins from Google Sheets that offer interesting features, including importing data from Google Sheets into a spreadsheet for self-hosting on your site.
Let’s go, let’s go, let’s go, let’s go!
How to add Google Cards to WordPress
In this first section I will show you how to use the built-in integration option for Google spreadsheets to add your spreadsheet to WordPress. This method does not require a plugin – just generate the embed code from the Google Sheets interface and paste it into the WordPress editor.
In this tutorial we assume that you have already created the spreadsheet to be implemented. Otherwise, do it first and then come back here for WordPress-specific details.
For this example, I created a simple worksheet with random financial data. We want to add it to WordPress now.
1. Code generation for integration in Google Sheets
You start working in the Google Sheets interface – don’t forget to open the spreadsheet you want to integrate.
In the Google Sheets interface, open the File menu and select Publish to the Web :
A pop-up window will open. In this window, click the Embed tab and choose whether you want to embed the entire document or just one sheet (useful if you have multiple sheets, but only want to embed one of them in your WordPress site).
If you expand the Publish content and settings area, you can also choose to republish the spreadsheet when you make changes to an existing document:
- If you don’t check this box, your embedded spreadsheet will always be synchronized with what you see in the Google Sheets interface. As soon as you change something, that change is automatically updated on your WordPress site.
- If you uncheck this box, you will need to republish the spreadsheet manually if you want to update the data. Otherwise, the version in WordPress is essentially just a snapshot of the current version of the spreadsheet.
When you have made your choice, click on Publish:
Once you’ve done that, you should see the commissioning code. Keep this integration code at hand as you will need it for the next step:
2. Code added to integrate Google Sheets in WordPress
Then go to your WordPress dashboard and create a new post or page to add your table (or edit existing content).
Using the WordPress block editor, you can add a custom HTML block and paste code into it to integrate it into Google Sheets. If you go to the preview setting, you should see your integration there in the editor (although it might look a bit weird in the background).
If you are using TinyMCE’s classic editor, you can insert the embed code in the editor’s Text tab (not in the Visual tab).
When you publish/update an article, you should see a Google Sheets document embedded at the end. As you can see, my worktop is quite large, so it looks a bit clumsy in the foreground:
You can add height and width parameters to the embed code to solve this problem. For example, I set the width to 100% (this takes up the full width of your content space) and the height to 500 (500 px – you can adjust this to your needs):
And with these parameters added to the integration code, the result is much better:
Best WordPress plugins for Googlesheets
While the manual integration method I described above works in some situations, in other situations you can use the Google Sheets WordPress plugin.
Depending on the plugin chosen, you can create a more user-friendly interface, automatically import (and sync) Google’s sheets into WordPress, and so on.
Let’s take a look at some of the best options….
Viewing Google Spreadsheets on the Internet
Inline Google Spreadsheet Viewer is a very popular free plugin that allows you to integrate an integrated PDF viewer based on a system of simple shortcuts. This is useful if you don’t want to integrate the entire Google Sheets interface and you prefer this plugin to display spreadsheets.
It also allows you to add your own CSS, giving you full control over the look and feel of your spreadsheet.
The plugin is well documented, so you can see the many options on the WordPress.org page.
View Google’s spreadsheets online
wpDataTables
If you only care about the data in your spreadsheet, but don’t really need the Google Sheets interface, wpDataTables may be a good option. This is a popular WordPress spreadsheet plugin that allows you to easily import data from Google Sheets into a self-service spreadsheet. Best of all, it also allows you to automatically synchronize this information with Google Sheets.
So when you update the original spreadsheet in Google Sheets, you can synchronize these changes with the version of your choice on your WordPress site.
This is a premium plugin that costs $59. To learn more and see it in action, read our full overview of wpDataTables.
Getting wpDataTables
Table-top printer
TablePress is a free and popular WordPress table plugin. The Auto Periodic Table Import extension allows you to automatically import Google sheets into WordPress according to a schedule of your choice.
Simply create a CSV export URL for Google Sheets and add it to TablePress. Go to →. Publish online in the Google Sheets interface and select CSV under Link.
Get the TablePress
Viewer
Visualizer is another popular plugin for WordPress tables / charts. With the free version you can import the sheets once from Google into WordPress. And if you upgrade to the Premium version, you can also sync your spreadsheets automatically to keep your data up to date.
The free version of the Document Camera is available on WordPress.org, while the premium version is available from $59.
Get a viewer
Essential extensions for element
If you are using the popular Elementor Page Generator (which we use and recommend here at WPLift), the third party Essential Addons for Elementor plugin includes a widget that allows you to import data from Google Sheets into a table of your Elementor themes.
You can see a demonstration here or in the documentation.
Large additions cost $39.97.
receive basic benefits
Integration of Google Sheets in WordPress today
The easiest way to add Google spreadsheets to WordPress is to publish the spreadsheet online and paste the embed code anywhere on your WordPress site.
Or, if you are only interested in the data from Google Sheets (and not in the Google Sheets interface itself), you can choose the Google Sheets WordPress plugin, which allows you to import data from your spreadsheet into your WordPress site.
Depending on the chosen plugin, you can even synchronize your site with Google Sheets on a regular basis to keep your data up-to-date.
Do you still have questions about adding Google sheets to WordPress? Leave a comment and we’ll try to help you!
Related Tags:
nhúng google sheet vào wordpress,add spreadsheet to wordpress,how to use embedpress,wordpress google sheets zapier,tablepress google sheets,how to embed google docs in wordpress,google sheets to wordpress post,inline google spreadsheet viewer,wordpress google sheets api,embed google sheet elementor,wp plugin google sheet,embed google sheet di wordpress,embed press elementor,vlookup wordpress plugin,ninja forms google sheets,embed google doc iframe,change size of embedded google doc,embed google doc pdf in wordpress,embed editable google doc,embed google doc in wordpress,wordpress google docs plugin,google spreadsheet plugin wordpress,inline google spreadsheet viewer wordpress,wordpress pull data from google sheet,wordpress spreadsheet plugin