Title: SheetDB – get your Google Spreadsheet data
Author: sheetdb
Published: 2019-يىلى 13-نويابىر
Last modified: 2026-يىلى 19-فېۋرال
---
قىستۇرما ئىزدە
# SheetDB – get your Google Spreadsheet data
يازغۇچى [sheetdb](https://profiles.wordpress.org/sheetdb/)
[چۈشۈر](https://downloads.wordpress.org/plugin/sheetdb.zip)
* [تەپسىلاتلار](https://ug.wordpress.org/plugins/sheetdb/#description)
* [باھالاشلار](https://ug.wordpress.org/plugins/sheetdb/#reviews)
* [ئورنىتىش](https://ug.wordpress.org/plugins/sheetdb/#installation)
* [ئىجادىيەت](https://ug.wordpress.org/plugins/sheetdb/#developers)
[قوللاش](https://wordpress.org/support/plugin/sheetdb/)
## چۈشەندۈرۈش
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–`[
sheetdb url="https://sheetdb.io/api/v1/YOUR_API_ID"][/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 – 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}}–{{
name}} [/sheetdb]
You can use following optional attributes:
* limit – The number of rows that should
be returned * offset – Row from which it should start (how many rows to skip) *
sheet – 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 – 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 – The column you want to sort
by * sort-order – sort in `asc` or `desc` order * lazy-loading – 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. `