admin管理员组

文章数量:1401916

I want to embed data from a Google sheet in a Wordpress page. As far as I understand, the easiest is to do it inside an iframe, but that requires that I buy some plugin. Alternatively, one can use a custom html block, which also requires something to be unlocked.

On the other hand, if instead I use a shortcode block I understand that it works without any specific requirements.

What is the complete syntax for writing a Shortcode block for a Google sheet?

I want to embed data from a Google sheet in a Wordpress page. As far as I understand, the easiest is to do it inside an iframe, but that requires that I buy some plugin. Alternatively, one can use a custom html block, which also requires something to be unlocked.

On the other hand, if instead I use a shortcode block I understand that it works without any specific requirements.

What is the complete syntax for writing a Shortcode block for a Google sheet?

Share Improve this question edited Apr 4 at 6:43 Francesco Potortì asked Apr 3 at 22:13 Francesco PotortìFrancesco Potortì 1012 bronze badges 2
  • What have you tried? Are you asking someone to write it for you? – Tony Djukic Commented Apr 7 at 18:25
  • In my own answer below I explain what I have found and what I am still missing. – Francesco Potortì Commented 2 days ago
Add a comment  | 

1 Answer 1

Reset to default 0

After looking around on the net, I came up with this solution which works for me. However, I still do not know what is the complete syntax.

First, on the Google sheet you must publish the sheet of interest and ask for the code to write to embed it into an iframe. Then instead of writing it into an iframe, you use that code to fill the a Shortcode block like this one:

[/] Shortcode

 [googleapps domain="docs" height=350 dir="spreadsheets/d/e/2PACX-1vTpRfd83GccrIsp0sxn5Zbj-sND4PCsk-1vJ0BomWlP-cHsP6aOZlAU73gy3QbNQJQtjlytI6SrWv5r/pubhtml" query="gid=1312633965" /]

本文标签: googleWhat39s the syntax for embedding a Goggle sheet in a shortcode