Title: SheetDB Ìtumọ̀ Yorùbá: – get your Google Spreadsheet data
Author: sheetdb
Published: <strong>Bélú 13, 2019</strong>
Last modified: Èrèlé  19, 2026

---

Ṣàwárí àwọn plugin

![](https://ps.w.org/sheetdb/assets/banner-772x250.jpg?rev=2192251)

![](https://ps.w.org/sheetdb/assets/icon-256x256.jpg?rev=2487092)

# SheetDB Ìtumọ̀ Yorùbá: – get your Google Spreadsheet data

 Láti ọwọ́ [sheetdb](https://profiles.wordpress.org/sheetdb/)

[Ṣe ìgbàsílẹ̀](https://downloads.wordpress.org/plugin/sheetdb.zip)

 * [Àwọn àlàyé](https://yor.wordpress.org/plugins/sheetdb/#description)
 * [Àwọn àgbéyẹ̀wò](https://yor.wordpress.org/plugins/sheetdb/#reviews)
 *  [Ìgbéwọlẹ̀](https://yor.wordpress.org/plugins/sheetdb/#installation)
 * [Ìdàgbàsókè](https://yor.wordpress.org/plugins/sheetdb/#developers)

 [Ìrànlọ́wọ́](https://wordpress.org/support/plugin/sheetdb/)

## Àpèjúwe

The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet
to your wordpress site. To add content, simply add shortcode that looks like this
Ìtumọ̀ Yorùbá: – `[sheetdb url=&#34;https://sheetdb.io/api/v1/YOUR_API_ID&#34;][/
sheetdb]`. Content from within will be rendered as many times as there are rows 
in the spreadsheet (excluding the first row, which are column names Ìtumọ̀ Yorùbá:–
definition). Each time a new row is rendered, you can refer to any value using the
braces notation: `{{column_name}}`

Example spreadsheet: [Example spreadsheet document](https://docs.google.com/spreadsheets/u/3/d/1YiMOrIFnMaksK032-zv6Sch2tTVTRhEpsFom_5qSLXM/edit)

Example code:
 [sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40" element="ul"
limit=3 search="id=*" sort-by="id" sort-order="desc" lazy-loading="true"] {{id}}
Ìtumọ̀ Yorùbá: – {{name}} [/sheetdb]

You can use following optional attributes:
 * limit Ìtumọ̀ Yorùbá: – The number 
of rows that should be returned * offset Ìtumọ̀ Yorùbá: – Row from which it should
start (how many rows to skip) * sheet Ìtumọ̀ Yorùbá: – If you want to use a different
sheet than the first one (default), enter the name of the tab you want to use here.*
search Ìtumọ̀ Yorùbá: – You can search for specific data in your sheet. If you want
to use more than one condition join them using & symbol. Example: search="name=Tom&
age=15" * sort-by Ìtumọ̀ Yorùbá: – The column you want to sort by * sort-order Ìtumọ̀
Yorùbá: – sort in `asc` or `desc` order * lazy-loading Ìtumọ̀ Yorùbá: – If you set
this attribute to true, the api call will be executed only when the user reaches
the point of the table. If your table is lower on the page this can help reduce 
request consumption.

HTML rendering and safety:
 * Using `{{name}}` renders plain text only. Any HTML
is escaped and will not be executed or rendered. * Using `{{html:name}}` allows 
most safe HTML tags to render (e.g. `a`, `p`, `ul`, `li`, `strong`, `em`, `img` 
with safe attributes). Potentially dangerous tags and attributes (e.g. `<script>`,`
<iframe>`, `<object>`, `<embed>`, inline `on*` event handlers, and `javascript:`
URLs) are stripped/sanitized.

This behavior is intentional for security reasons to prevent XSS and code injection
from spreadsheet content.

Security recommendation:
 * For best security, configure your SheetDB API as read-
only: enable only `GET` and disable `POST`, `PATCH`, and `DELETE`. This prevents
anyone from modifying your data via exposed API keys or URLs.

Additional information:
 This plugin use SheetDB.io to fetch data from Google Spreadsheet.
You must have an account at SheetDB Ìtumọ̀ Yorùbá: – account is free for 500 requests
per month. More information at [SheetDB.io](https://sheetdb.io) or at [privacy policy](https://sheetdb.io/privacy-policy)

### Re-use

If you want to re-use your data, you can use the `save` attribute in your [sheetdb]
element. To re-use your data use [sheetdb-slot]. You can use the same data inside
as in the parent. To match them the value of save and slot must be the same.

Example:

[sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40" save="slot-name"]

{{id}} Ìtumọ̀ Yorùbá: – {{name}}

[/sheetdb]

[sheetdb-slot slot="slot-name"]

{{name}}

[/sheetdb-slot]

That way, you only use 1 request instead of 2. Slots have access to the same data
as the parent. You canÌtumọ̀ Yorùbá: ’t change things like limit or search.

## Àwọn àwòrán ìbòjú

[⌊Use SheetDB shortcode⌉⌊Use SheetDB shortcode⌉[

Use SheetDB shortcode

[⌊Content on the site will be download from spreadsheet with every pageload.⌉⌊Content
on the site will be download from spreadsheet with every pageload.⌉[

Content on the site will be download from spreadsheet with every pageload.

[⌊The Google Spreadsheet content⌉⌊The Google Spreadsheet content⌉[

The Google Spreadsheet content

## Ìgbéwọlẹ̀

Add SheetDB plugin to your site, activate it, then all you need to do is use the[
sheetdb] shortcode wherever you want.

## Àwọn àgbéyẹ̀wò

![](https://secure.gravatar.com/avatar/2c1649f010c724b55c3a04b279e0b986ea0aaae3ce2e683959e476b0f9d1cf35?
s=60&d=retro&r=g)

### 󠀁[Great but needs updating](https://wordpress.org/support/topic/great-but-needs-updating-2/)󠁿

 [ahmad21](https://profiles.wordpress.org/ahmad21/) Ẹrẹ́nà 10, 2023 1 ìdáhùn

Security is essential to customer data and you should know this!! Please update 
for WordPres 6.1.1 asap!!

![](https://secure.gravatar.com/avatar/667ccdea9664d56a73be14d8a339434cf91a57dfd9e7de3f2ae668a5356dcfcd?
s=60&d=retro&r=g)

### 󠀁[it works!!!](https://wordpress.org/support/topic/it-works-2113/)󠁿

 [Wong](https://profiles.wordpress.org/wsjwong/) Èbìbí 20, 2021

Thanks for creating this. It works easily with the short code config.

![](https://secure.gravatar.com/avatar/a6bd4ce0c7956d1f8e0db6cb1a3dfdc53151c6931c93fe50360bfa33e74875e2?
s=60&d=retro&r=g)

### 󠀁[Thank Goodness!](https://wordpress.org/support/topic/thank-goodness-21/)󠁿

 [GMRobbins](https://profiles.wordpress.org/gmrobbins/) Èrèlé 26, 2021

Where have you been these past months (years) while I searched and searched for 
such a plugin? This does exactly what I, and a zillion others, have needed, desired,
and waited for! It is awesome! Thank you. Thank you. Thank you! Everyone, if youÌtumọ̀
Yorùbá: ’ve been seeking a way to display your form data on a WP page, look no more!
This will do the trick. Your wait is over. IÌtumọ̀ Yorùbá: ’ve only downloaded and
installed it today, so I canÌtumọ̀ Yorùbá: ’t quite know all itÌtumọ̀ Yorùbá: ’s
features. However, out of the box and with a few simple tweaks, I have accomplished
in moments what IÌtumọ̀ Yorùbá: ’ve tried to do for months!

![](https://secure.gravatar.com/avatar/549daa8239f1667b4b8fc136c6c1eba7500320e277e24288e071f9a30c1a5d70?
s=60&d=retro&r=g)

### 󠀁[the best solution](https://wordpress.org/support/topic/the-best-solution-15/)󠁿

 [boek71](https://profiles.wordpress.org/boek71/) Igbe 10, 2020

I have been using SheetDB for over a year. The best solution available on the market.
I would recommend!

![](https://secure.gravatar.com/avatar/c0068f3fb11ec488cbeb6b4b0c284d695028d07fb935c18beacd635a44f1ef3e?
s=60&d=retro&r=g)

### 󠀁[Great for prototyping](https://wordpress.org/support/topic/great-for-prototyping/)󠁿

 [kgolajek](https://profiles.wordpress.org/kgolajek/) Bélú 13, 2019

Can propagate site with real data really fast.

 [ Ka gbogbo àwọn àgbéyẹ̀wò 5 ](https://wordpress.org/support/plugin/sheetdb/reviews/)

## Àwọn Olùkópa & Olùgbéejáde

“SheetDB Ìtumọ̀ Yorùbá: – get your Google Spreadsheet data” jẹ́ ètò ìṣàmúlò orísun
ṣíṣí sílẹ̀. Àwọn ènìyàn wọ̀nyí ti ṣe ìkópa sí plugin yìí.

Àwọn Olùkópa

 *   [ sheetdb ](https://profiles.wordpress.org/sheetdb/)

[Túmọ̀ “SheetDB Ìtumọ̀ Yorùbá: – get your Google Spreadsheet data” sí èdè rẹ.](https://translate.wordpress.org/projects/wp-plugins/sheetdb)

### Ṣe o nífẹ̀ẹ́ sí ìdàgbàsókè?

[Ṣàwárí koodu](https://plugins.trac.wordpress.org/browser/sheetdb/), ṣàyẹ̀wò [ibi ìpamọ́ SVN](https://plugins.svn.wordpress.org/sheetdb/),
tàbí ṣe àgbékalẹ̀ sí [àkọsílẹ̀ ìdàgbàsókè](https://plugins.trac.wordpress.org/log/sheetdb/)
nípasẹ̀ [RSS](https://plugins.trac.wordpress.org/log/sheetdb/?limit=100&mode=stop_on_copy&format=rss).

## Àkójọpọ̀ Meta

 *  Ẹ̀yà **1.3.6**
 *  Ìgbàgbọ́hùn tó kẹ́yìn **oṣù 6 sẹ́yìn**
 *  Àwọn ìgbéwọlẹ̀ tó ṣiṣẹ́ **700+**
 *  Ẹ̀yà WordPress ** 4.0 tàbí ju bẹ́ẹ̀ lọ **
 *  Dánwò dé **6.9.0**
 *  Ẹ̀yà PHP ** 5.4 tàbí ju bẹ́ẹ̀ lọ **
 *  Èdè
 * [English (US)](https://wordpress.org/plugins/sheetdb/)
 * Àwọn àmì
 * [api](https://yor.wordpress.org/plugins/tags/api/)[Google API](https://yor.wordpress.org/plugins/tags/google-api/)
   [Google Sheets](https://yor.wordpress.org/plugins/tags/google-sheets/)[google spreadsheet](https://yor.wordpress.org/plugins/tags/google-spreadsheet/)
 *  [Ìwòye Tó Péye](https://yor.wordpress.org/plugins/sheetdb/advanced/)

## Àwọn ìbò

 4.8 lára àwọn ìràwọ̀ 5.

 *  [  4 5-star reviews     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=5)
 *  [  1 4-star review     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=4)
 *  [  0 3-star reviews     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=3)
 *  [  0 2-star reviews     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=2)
 *  [  0 1-star reviews     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/sheetdb/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/sheetdb/reviews/)

## Àwọn Olùkópa

 *   [ sheetdb ](https://profiles.wordpress.org/sheetdb/)

## Ìrànlọ́wọ́

Nǹkan wà tí o fẹ́ sọ? Ṣé o nílò ìrànlọ́wọ́?

 [Wo àpéjọ ìrànlọ́wọ́](https://wordpress.org/support/plugin/sheetdb/)