Title: SheetDB – get your Google Spreadsheet data
Author: sheetdb
Published: <strong>2019 年 11 月 13 日</strong>
Last modified: 2026 年 2 月 19 日

---

搜索插件

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

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

# SheetDB – get your Google Spreadsheet data

 作者：[sheetdb](https://profiles.wordpress.org/sheetdb/)

[下载](https://downloads.wordpress.org/plugin/sheetdb.zip)

 * [详情](https://cn.wordpress.org/plugins/sheetdb/#description)
 * [评价](https://cn.wordpress.org/plugins/sheetdb/#reviews)
 *  [安装](https://cn.wordpress.org/plugins/sheetdb/#installation)
 * [开发进展](https://cn.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=&#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 – 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. `<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 – 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}} – {{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’t change things like limit or search.

## 屏幕截图

[⌊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

## 安装

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

## 评价

![](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/) 2023 年 3 月 10 日 1 回复

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/) 2021 年 5 月 20 日

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/) 2021 年 2 月 26 日

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’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’ve only downloaded and installed it today, so
I can’t quite know all it’s features. However, out of the box and with a few simple
tweaks, I have accomplished in moments what I’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/) 2020 年 4 月 10 日

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/) 2019 年 11 月 13 日

Can propagate site with real data really fast.

 [ 阅读所有5条评价 ](https://wordpress.org/support/plugin/sheetdb/reviews/)

## 贡献者及开发者

「SheetDB – get your Google Spreadsheet data」是开源软件。 以下人员对此插件做出了
贡献。

贡献者

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

[帮助将「SheetDB – get your Google Spreadsheet data」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/sheetdb)

### 对开发感兴趣吗?

您可以[浏览代码](https://plugins.trac.wordpress.org/browser/sheetdb/)，查看[SVN仓库](https://plugins.svn.wordpress.org/sheetdb/)，
或通过[RSS](https://plugins.trac.wordpress.org/log/sheetdb/?limit=100&mode=stop_on_copy&format=rss)
订阅[开发日志](https://plugins.trac.wordpress.org/log/sheetdb/)。

## 额外信息

 *  版本 **1.3.6**
 *  最后更新：**4 月前**
 *  活跃安装数量 **700+**
 *  WordPress 版本 ** 4.0 或更高版本 **
 *  已测试的最高版本为 **6.9.0**
 *  PHP 版本 ** 5.4 或更高版本 **
 *  语言
 * [English (US)](https://wordpress.org/plugins/sheetdb/)
 * 标签
 * [api](https://cn.wordpress.org/plugins/tags/api/)[Google API](https://cn.wordpress.org/plugins/tags/google-api/)
   [Google Sheets](https://cn.wordpress.org/plugins/tags/google-sheets/)[google spreadsheet](https://cn.wordpress.org/plugins/tags/google-spreadsheet/)
 *  [高级视图](https://cn.wordpress.org/plugins/sheetdb/advanced/)

## 评级

 4.8 星（最高 5 星）。

 *  [  4 条 5 星评价     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=5)
 *  [  1 条 4 星评价     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=4)
 *  [  0 条 3 星评价     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=3)
 *  [  0 条 2 星评价     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=2)
 *  [  0 条 1 星评价     ](https://wordpress.org/support/plugin/sheetdb/reviews/?filter=1)

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

[查看全部评论](https://wordpress.org/support/plugin/sheetdb/reviews/)

## 贡献者

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

## 支持

有话要说吗？是否需要帮助？

 [查看支持论坛](https://wordpress.org/support/plugin/sheetdb/)