WesternDeal

GSheetConnector for Core Lite is an addon plugin—a bridge between your <a href="https://wordpress.org/" rel="ugc">WordPress</a> core content (Pages, Posts, Users and Comments) and <a href="https://www.google.com/sheets/about/" rel="nofollow ugc">Google Sheets</a>.
It allows you to send and manage your WordPress data in Google Sheets, helping you keep everything organized, accessible, and easy to track from one central place.
<h4>🗂️ WordPress Core ➜ to 📊 Google Sheets</h4>
Easily connect your WordPress Pages, Posts, Users, and Comments to Google Sheets without writing any code. This plugin helps you organize your WordPress data into structured spreadsheets for easy tracking and management.
<h4>⚡️ How to Use this Plugin</h4>
<h4>Option 1: All Data in One Spreadsheet (Tabs Based)</h4>
<ul>
<li>
Step 1: In Google Sheets 
➜ Log into your Google account and open Google Sheets. 
➜ Create a new spreadsheet or open an existing one.
</li>
<li>
Step 2: Connect Google Sheets in WordPress 
➜ Log into your WordPress Admin Dashboard. 
➜ Navigate to GSheetConnector → Settings. 
➜ Click Fetch Sheets to load your Google Spreadsheets. 
➜ Select your Google Spreadsheet Name from the dropdown.
</li>
<li>
Step 3: Select Data Type (Tab Creation) 
➜ Scroll to Google Sheets / Tab Name section. 
➜ Enable the toggle for the tabs you want to create:
<ul>
<li>Posts </li>
<li>Pages </li>
<li>Users </li>
<li>Comments 
➜ The plugin will create separate tabs inside the selected spreadsheet.</li>
</ul>
</li>
<li>
Step 4: Configure Sheet Headers (Columns) 
➜ Go to Google Sheet Headers (Column Name) section. 
➜ Choose the header group:
<ul>
<li>Post Headers </li>
<li>Page Headers </li>
<li>Comment Headers 
➜ Enable the fields you want to include (e.g. Post Title, Post Date, Status, Author). 
➜ Use Check All to include all available fields. 
➜ Save the settings.</li>
</ul>
</li>
</ul>
<h4>Option 2: Separate Sheet for Each Data Type (Feed Settings)</h4>
<ul>
<li>
Step 1: Create a Feed 
➜ Navigate to GSheetConnector → Settings → Feed Settings. 
➜ Click Add Feeds. 
➜ Enter a Feed Name. 
➜ Select a Feed Type:
<ul>
<li>Posts </li>
<li>Pages </li>
<li>Users </li>
<li>Comments 
➜ Save the feed and click Edit.</li>
</ul>
</li>
<li>
Step 2: Configure Feed Headers 
➜ Open the created feed from the feed list. 
➜ Select the Google Spreadsheet Name for this feed. 
➜ Based on the feed type, configure headers:
<ul>
<li>Posts Headers </li>
<li>Pages Headers </li>
<li>Users Headers </li>
<li>Comments Headers 
➜ Enable the fields you want to include as columns. 
➜ Use Check All if required.</li>
</ul>
</li>
<li>
Step 3: Create an Individual Sheet per Feed 
➜ Click Submit Data after selecting headers. 
➜ The plugin will create an individual sheet (tab) inside the selected spreadsheet. 
➜ Each feed maintains its own separate sheet for better data organization.
</li>
<li>
Step 4: Manage Feeds 
➜ View all feeds under Feed Settings. 
➜ Enable or disable feeds using the status toggle. 
➜ Edit or delete feeds anytime as needed.
</li>
</ul>
<h3>External Services</h3>
GSheetConnector for Core Lite relies on Google APIs to connect WordPress with Google Sheets. 
These services are required for authentication and for creating, reading, and updating spreadsheets 
based on WordPress core data (Posts, Pages, Users, and Comments).
This plugin does NOT send any data to the plugin author’s servers.
<h4>1. Google Sheets API</h4>
• Service: Google Sheets API (Google LLC) 
• Purpose: 
 Used to create spreadsheets, create sheet tabs, write WordPress data into sheets, 
 and read existing spreadsheet information. 
• Data Sent: 
 Spreadsheet structure and content based on the administrator’s selected WordPress data. 
• When Data Is Sent: 
 Only when the site administrator explicitly performs an action such as submitting data 
 or creating sheets. 
• API Scope Used: 
 https://www.googleapis.com/auth/spreadsheets 
• Terms of Service: 
 https://policies.google.com/terms 
• Privacy Policy: 
 https://policies.google.com/privacy
<h4>2. Google Drive API</h4>
• Service: Google Drive API (Google LLC) 
• Purpose: 
 Used to list available Google Spreadsheets and access spreadsheet file metadata. 
• Data Sent: 
 File metadata (such as spreadsheet ID and name). 
• When Data Is Sent: 
 When the administrator fetches or selects Google Spreadsheets from the plugin settings. 
• API Scopes Used: 
 https://www.googleapis.com/auth/drive.file 
 https://www.googleapis.com/auth/drive.metadata.readonly 
• Terms of Service: 
 https://policies.google.com/terms 
• Privacy Policy: 
 https://policies.google.com/privacy
<h4>3. Google OAuth 2.0 Authentication</h4>
• Service: Google OAuth 2.0 (Google LLC) 
• Purpose: 
 Used to securely authenticate users and authorize access to Google Sheets and Google Drive. 
• Data Sent: 
 OAuth authorization requests, access tokens, and refresh tokens. 
• When Data Is Sent: 
 During the “Sign in with Google” authorization process. 
• API Scope Used: 
 https://www.googleapis.com/auth/userinfo.email 
• Certificate Endpoint Used: 
 https://www.googleapis.com/oauth2/v3/certs 
• Data Storage: 
 OAuth access tokens are stored securely in the site’s WordPress database. 
• Terms of Service: 
 https://developers.google.com/terms 
• Privacy Policy: 
 https://policies.google.com/privacy
<h3>Privacy Policy</h3>
GSheetConnector for Core Lite uses Google APIs to allow users to connect their WordPress site with Google Sheets.
This plugin does not collect or transmit personal data to the plugin author or any external servers. Google account authentication and access to Google Sheets are handled securely using Google OAuth.
Access tokens required for Google authentication are stored securely in the site’s own WordPress database and are used only to perform actions requested by the site administrator.
The plugin only accesses Google Sheets and Google Drive data after explicit user consent during the Google authorization process.
No data is sold or shared with third parties, and no data is stored on the plugin author’s servers.

GSheetConnector for Core Lite

Connect WordPress core data (Pages, Posts, Users and Comments) with Google Sheets easily.

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 – <code>[sheetdb url=&#34;https://sheetdb.io/api/v1/YOUR_API_ID&#34;][/sheetdb]</code>. 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: <code>{{column_name}}</code>
Example spreadsheet: <a href="https://docs.google.com/spreadsheets/u/3/d/1YiMOrIFnMaksK032-zv6Sch2tTVTRhEpsFom_5qSLXM/edit" rel="nofollow ugc">Example spreadsheet document</a>
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 <code>asc</code> or <code>desc</code> 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 <code>{{name}}</code> renders plain text only. Any HTML is escaped and will not be executed or rendered. 
* Using <code>{{html:name}}</code> allows most safe HTML tags to render (e.g. <code>a</code>, <code>p</code>, <code>ul</code>, <code>li</code>, <code>strong</code>, <code>em</code>, <code>img</code> with safe attributes). Potentially dangerous tags and attributes (e.g. <code><script></code>, <code><iframe></code>, <code><object></code>, <code><embed></code>, inline <code>on*</code> event handlers, and <code>javascript:</code> 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 <code>GET</code> and disable <code>POST</code>, <code>PATCH</code>, and <code>DELETE</code>. 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 <a href="https://sheetdb.io" rel="nofollow ugc">SheetDB.io</a> or at <a href="https://sheetdb.io/privacy-policy" rel="nofollow ugc">privacy policy</a>
<h3>Re-use</h3>
If you want to re-use your data, you can use the <code>save</code> 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.

SheetDB – get your Google Spreadsheet data

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!

Thank Goodness!

The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site.

GSheetConnector for Core Lite vs SheetDB – get your Google Spreadsheet data