Google Sheets is now a central hub for managing, sharing, and analyzing data collaboratively in real time. Whether it’s tracking inventory, organizing event schedules, or analyzing financial data, teams and individuals rely on it to ensure accessibility and convenience.
When it comes to websites, the need for dynamic and up-to-date information was, is, and will always be present. You can eliminate repetitive manual updates and keep your content fresh for visitors by utilizing Google Sheets in WordPress.
In this guide, we’ll show you how to minimize your effort in embedding Google Sheets into WordPress using two distinct approaches. The aim is to find you a method that makes embedding sheets both easy and effective.
Method 1: Embed Without a Plugin
This method offers a simple yet efficient way to embed Google Sheets into your WordPress site without the need for a plugin.
Step 1: Adjust Sharing Settings
Open the Google Sheet you want to embed. First, ensure the sheet’s sharing settings allow access for the intended audience by setting it to “Anyone with the link” or similar.
Step 2: Publish to the Web
From the Google Sheets menu, click on File > Share > Publish to the web.
In the dialog box that appears, move to the Embed tab. Choose whether to embed the entire document or a specific sheet. After selecting your preferred option, click the Publish button and confirm the action.
Step 3: Copy the Embed Code
Once published, an embed code will be generated. Copy this code for the next step.
Step 4: Add a Custom HTML Block
From your WordPress dashboard, open the post or page where you want to display the Google Sheet and move to the exact position. Click on the Block Inserter (+) button to add a new block, search for a Custom HTML block, and add it.
Step 5: Paste the Embed Code and Adjust the Size
Paste the code obtained earlier into the Custom HTML block.
By default, the screen size used to display the Google Sheet might be too small. To specify the dimensions yourself, add the width and height attributes to the iframe tag. Simply include these attributes like this: width=”650″ height=”450″ before ></iframe> at the very end of the code. Adjust the values to achieve your preferred size.
Preview your page every now and then to ensure the sheets are displaying correctly. Once satisfied, click Publish or Update to save your changes. Below is an example of how this embedded Google Sheet might look on your WordPress site.
Method 2: Embed with the help of a Plugin
There are many great plugins for embedding Google Sheets in WordPress. For this guide, we’re using EmbedPress—a reliable option that makes the process simple and code-free.
Step 1: Install and Activate the EmbedPress Plugin
Go to your WordPress dashboard, navigate to Plugins > Add New, and search for “EmbedPress”. Click on Install Now, then Activate the plugin.
Step 2: Publish the Google Sheet to the Web
Open the Google Sheet you want to embed. In the Google Sheets menu, click on File > Share > Publish to the web.
In the dialog box that appears, decide whether you want to display the entire document or a specific sheet. Later, click Publish and confirm the action to generate a link.
Copy the link provided.
Step 3: Add the EmbedPress Block in WordPress
Open the WordPress post or page where you want to display the sheet. Click on the Block Inserter (+) button, search for the EmbedPress block, and add it to your page.
Step 4: Paste the Google Sheet Link
Paste the link you copied earlier into the EmbedPress block and click Embed. The plugin will automatically embed the Google Sheet on your page.
Step 5: Adjust Display Settings and Publish
Click on the block and use the block settings to adjust the dimension of the embedded Google Sheet directly within WordPress. Once satisfied with how it looks, click Publish or Update to save your changes. Preview the page to ensure everything is displayed correctly.
Conclusion
The methods in this guide let you decide how hands-on you want to be. Whether you prefer the control of a manual embed or the ease of using a plugin, you’re equipped to integrate Google Sheets in a way that works best for you.
Now’s the time to take your website to the next level. Start embedding Google Sheets and let your content stay as fresh and dynamic as the ideas behind it.
