Did you know that you can embed Google Sheets in WordPress? It is a free and easy way to add full-blown spreadsheet functionality to your website or blog, and in this article I will show you a couple ways to do it.
How to Embed Google Sheets in WordPress
Publish the Google Sheet you want to embed. This first step is where most people get stuck because they think they can just use the normal sharing link, but no, that won’t work.
To embed a Google Sheet, you first need to publish it as a web page. Open Google Drive and select the document you want to embed. Then click File > Share and select Publish to the web from the drop down menu.
Customize the embed settings. Before clicking Publish you should customize the settings how you want them. For example, if you want to embed just the current sheet instead of the whole document, first toggle the Entire Document option to the specific sheet you want to share.
When you have the settings how you want them, click Start Publishing and select the Embed tab to get the iframe embed code.
Once published, you need to copy the embed code, which looks like this:
Go to your WordPress admin dashboard and select Pages > Add new
On the link editor, select Text then paste the iframe in the text field. WordPress will recognize that it is an embed code. Click Update to finish.
How to Embed Google Sheets in WordPress using a Plugin
I showed you how to embed a Google Sheet using an embed code, but now I’m going to show you an alternative way using a plugin called EmbedPress.
To install the plugin, log in to your WordPress admin, select Plugins > Add new and search for “EmbedPress.”
Once you have installed and opened EmbedPress, follow the steps below.
Publish your Google Sheet to the web. It’s the same steps as in the first instructions: open the Google Sheet document, click File > Share and select Publish to the web from the drop down menu. Doublecheck the settings, and click Publish.
Copy the link instead of the embed code. This time choose the Link tab and copy the url instead of the embed code.
Return to WordPress. In Gutenberg, click on the “+” button and find the EmbedPress block.
This will give you a dropdown menu of document types to embed. Select Google Sheets.
Paste the Google Sheets URL in the box and click the Embed button.
And that’s it! You can publish your update to set it live.
It’s one thing to add a table to your web page, but quite another to unleash the full capability of Google Sheets in your site.
In this article I showed you just how easy that is to do. But if you are looking to embed a spreadsheet to share with a client, I have an even better solution for you.
Ahsuite client portals are built specifically for embedding things like Google Sheets and sharing them in a clean, easy-to-use portal that clients love.
You can use Ahsuite for free for up to three clients, so there’s no risk to try it out. You can have a Google Sheet embedded in a client portal in minutes!