Dan's GSheets is used to embed Google Sheets data from individual cells or ranges, in a manner that will update on page reload.
|Author:||Dan Dulaney (profile at wordpress.org)|
|WordPress version required:||4.0.1|
|WordPress version tested:||5.2.1|
|Added to WordPress repository:||21-11-2016|
|Total downloads:||2 450|
Click to start download
Single Cell and Range Examples with Shortcodes
Public Sheet the 2nd screenshot is drawing from
How do I create my API key?
To create API key, visit Google Developers Console. https://console.developers.google.com/
Then, follow bellow;
Create new project (or use project you created before).
Check “APIs & auth” -> “Credentials” on side menu.
Hit “Create new Key” button on “Public API access” section.
Choose “Browser key” and keep blank on referer limitation.
Set this key on the plugin’s setting page.
How do I find the ID for the folder I want to share?
Once you have set the folder as public, you can find the id with the following:
Visit https://sheets.google.com/, while logged in to your account.
Enter the sheets document that you have shared publically
Find the folder ID from the url, after the /folders/. Example: https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxx/edit , where xxxxxxxxxxxxxxx is the key.
My values aren’t updating when I change them in Google Sheets?
- You may have caching enabled. Either exclude the site from your caching plugin, or you will have to manually flush your caching plugin after you make a change to your Google Sheet.
- Updated supported version to 4.7.0 after testing
- Initial Plugin Release