Title: Dan's GSheets Data Embedder Author: Dan D Published: 2016年11月21日 Last modified: 2019年6月5日 --- プラグインを検索 ![](https://s.w.org/plugins/geopattern-icon/dans-gsheets.svg) # dans-gsheets * [詳細](https://ja.wordpress.org/plugins/dans-gsheets/#description) * [レビュー](https://ja.wordpress.org/plugins/dans-gsheets/#reviews) * [開発](https://ja.wordpress.org/plugins/dans-gsheets/#developers) [サポート](https://wordpress.org/support/plugin/dans-gsheets/) ## 説明 このプラグインの公開は2024年10月13日に停止されており、ダウンロードできません。 この 公開停止は永久的なものです。 理由: 作者からのリクエスト。 ## 評価 ![](https://secure.gravatar.com/avatar/18d539cb813222a867bae775e521b85bbb66f3aebbf5274670ae3bf1d3bdc83c? s=60&d=retro&r=g) ### 󠀁[Still works great! Also, SOLUTION for critical errors](https://wordpress.org/support/topic/still-works-great-also-solution-for-critical-errors/)󠁿 [Bulk Ranker](https://profiles.wordpress.org/curranvw/) 2021年1月21日 This is such a handy tool if you're wanting to do complex calculations in google sheets and display single cell values on the frontend of your WordPress site. Also I figured I'd post this here because I just was dealing with this issue for a couple of days and finally figured out how to fix it. If you are getting a critical error on your WP site (and the error log shows the message below), here is the solution: ERROR: [21-Jan-2021 20:48:02 UTC] PHP Fatal error: Uncaught Error: Cannot use object of type WP_Error as array in /home/****/public_html/wp-content/plugins/dans-gsheets/ dans-gsheets.php:156 OR "There has been a critical error on this website." The reason it's probably happening is because your Gsheet takes time to load in data (or do calculations) and that loading time causes Wordpress to timeout and throws an error. One simple solution is to create a new google sheet file and use =IMPORTRANGE("< sheet URL or key>", "Sheet1!A1") to get values from your larger sheet. Then you can use Dan's tool to grab data from the new sheet because the new sheet is not constantly taking forever to load and it'll stop throwing errors to WordPress. Hopefully that helps someone because that took me forever to figure out! ![](https://secure.gravatar.com/avatar/55a480ae2bd00695bc2a429905bd30738ba006abb82c1730191648dfc529830f? s=60&d=retro&r=g) ### 󠀁[WUTTTTTTTT This is awesome](https://wordpress.org/support/topic/wutttttttt-this-is-awesome/)󠁿 [Jarod Thornton](https://profiles.wordpress.org/jarmerson/) 2020年6月30日 Sorry for the adolescent title! I am very impressed with how easy this has made giving my client the ability to update their restaurant menu!!! This is very cool! ![](https://secure.gravatar.com/avatar/c4c59d6f9a77f713484a04fe5a578ba80dd4e29b68599e650fac025761a569c6? s=60&d=retro&r=g) ### 󠀁[SO easy! Perfect for showing dynamic cells on site](https://wordpress.org/support/topic/so-easy-perfect-for-showing-dynamic-cells-on-site/)󠁿 [AMGill](https://profiles.wordpress.org/amgill/) 2020年4月22日 This is an awesome plugin! I have been trying all sorts of solutions to show ONE dynamic calculated cell from Google sheets on a clients website. I stumbled upon this plugin and it was so easy and quick to set up. THANK YOU! I have saved this as a favorite. ![](https://secure.gravatar.com/avatar/111cab8be20360b683205bc6448cbfdcb7f222e8d6b91a7a7e6e1bdd832b2f2a? s=60&d=retro&r=g) ### 󠀁[Excellent Plug-in](https://wordpress.org/support/topic/excellent-plug-in-252/)󠁿 [isadork](https://profiles.wordpress.org/isadork/) 2019年10月2日 This was exactly what I needed. After I fixed a dumb mistake on my part, this plug- in worked flawlessly. ![](https://secure.gravatar.com/avatar/12a5a1ed73cde8b7237fa969cf07545ccb5b67d6f96bb2f24ef0dcb771cbff6f? s=60&d=retro&r=g) ### 󠀁[Fantastic Plugin!!](https://wordpress.org/support/topic/fantastic-plugin-885/)󠁿 [Scott](https://profiles.wordpress.org/nagashade/) 2018年2月1日 After spending days trying to figure out a solution to a client's requested addition to his website, I found this program and it works flawlessly. I've setup another plugin to send contact form data to a Google Sheet, perform a calculation, and then this plugin sends the data back to the website for display. With a little CSS the data from the shortcode can quickly be displayed however desired. Like the author suggested, there are many uses. Love it. The only difficulty I had was in initial setup. To make this pull the data in from the Google sheet, I had to set the Sheet's share setting so that anybody with the link can view. Also the API instructions are a bit dated, but simply select the Google Sheets API in the library and in credentials create the API. Thanks for this fantastic plugin. [ 5件のレビューをすべて表示 ](https://wordpress.org/support/plugin/dans-gsheets/reviews/) ## 貢献者と開発者 Dan's GSheets Data Embedder はオープンソースソフトウェアです。以下の人々がこのプラグ インに貢献しています。 貢献者 * [ Dan D ](https://profiles.wordpress.org/duplaja/) [“Dan's GSheets Data Embedder” をあなたの言語に翻訳しましょう。](https://translate.wordpress.org/projects/wp-plugins/dans-gsheets) ### 開発に興味がありますか ? [コードを閲覧](https://plugins.trac.wordpress.org/browser/dans-gsheets/)するか、 [SVN リポジトリ](https://plugins.svn.wordpress.org/dans-gsheets/)をチェックするか、 [開発ログ](https://plugins.trac.wordpress.org/log/dans-gsheets/)を [RSS](https://plugins.trac.wordpress.org/log/dans-gsheets/?limit=100&mode=stop_on_copy&format=rss) で購読してみてください。 ## メタ * バージョン **1.2** * 最終更新日 **7年前** * 有効インストール数 **該当なし** * WordPress バージョン ** 4.0.1またはそれ以降 ** * 検証済み最新バージョン: **5.2.28** * 言語 * [English (US)](https://wordpress.org/plugins/dans-gsheets/) * [詳細を表示](https://ja.wordpress.org/plugins/dans-gsheets/advanced/)