0:00
Hi everyone, welcome to K2 blogging and in this video I will show you how you can embed
0:04
Google Sheet in your WordPress website. So as you can see that I have opened the Google Sheet here and I want to embed it in my WordPress website
0:12
Then how I can do that. So here you need to go to the file section
0:16
Click on this share and then you will see this option publish to web
0:19
So just click on here. Now here you will see this option embed
0:24
Here you can select entire document. So if you have multiple sheet, then you can embed multiple sheet at once or you can select
0:31
an individual sheet from here. So I will select entire document here and let's click on publish
0:37
Let's click on OK. Now it will publish the sheet to the web
0:41
Now you can copy this code and use it in your WordPress website
0:45
So for this, let's go to the WordPress dashboard, open the all blog post here
0:50
Now let me just open the existing blog post here. Now I want to embed the sheet in this blog post
0:57
So I will click on plus and I will click on browse all. And here you need to search the custom HTML blog
1:04
So if you are using Elementor, then you will also find the custom HTML blog
1:09
So let's paste the code here and here you need to make sure to assign the width and
1:15
height in this iframe code. So for this, I will click on here and I will set the width equal to and in double quote
1:24
I have to assign the width. So you can assign the width according to your website layout
1:30
So here in my case, let me assign 800 width and then I have to assign the height
1:37
So let me just add the height here like this and let's assign height of 800 pixel or 1000 pixel
1:46
So here let me choose 700 pixel like this. Now you have assigned the width and height to the iframe code
1:55
Let's click on preview here and as you can see that this is how the Google sheet looks
2:00
So as you can see that data is limited in this sheet. So we can reduce the height a little bit
2:06
So let me keep the sheet height to 400. Let's click on preview and this is how you can embed a sheet in your WordPress website
2:15
So let's click on update. Now let me just open this blog post and as you can see that we have successfully embedded
2:21
the Google sheet in our WordPress website. So if you have any doubt regarding this, then you can ask me in the comment section and
2:28
if you found this video helpful, then make sure to hit the like button and I will see
2:32
you in the next one. Bye bye