GSheetConnector – WordPress Google Sheets Integration for Posts, Pages, Users & Comments

GSheetConnector for Core Lite is a WordPress Google Sheets integration plugin that connects WordPress core data with Google Sheets and helps automate WordPress data management.

This WordPress Google Sheets integration allows you to export WordPress Posts, Pages, Users, and Comments and send them directly to Google Sheets. It helps website administrators organize WordPress data into structured spreadsheets for reporting, tracking, and automation.

With simple Google authentication and easy configuration, you can quickly sync WordPress data to Google Sheets without writing any code.

This plugin is ideal for exporting WordPress data to Google Sheets for reporting, automation, and content management.

🗂️ WordPress Core ➜ Google Sheets

Easily connect your WordPress Pages, Posts, Users, and Comments to Google Sheets without writing any code. This plugin helps organize WordPress data into structured spreadsheets for easy tracking and management.

Key Features

✓ WordPress Google Sheets integration for Posts, Pages, Users and Comments
✓ Automatically create Google Sheets tabs for different WordPress data types
✓ Export WordPress content to Google Sheets for reporting and analysis
✓ Manage WordPress data in Google Sheets for better tracking and analysis
✓ Feed-based configuration for flexible data organization
✓ Select specific fields and columns for Google Sheets export
✓ Simple Google OAuth authentication – no API keys required
✓ Easy setup with a user-friendly admin interface
✓ Compatible with the latest WordPress versions

Upgrade to Pro – Advanced WordPress Google Sheets Integration

Upgrade to the Pro version to unlock advanced automation features, additional integrations, and enhanced data management options.

Learn more about the Pro version:
WordPress Google Sheets Connector Pro

Use Cases

GSheetConnector for Core Lite can be used for many WordPress automation and reporting tasks, including:

• Export WordPress posts to Google Sheets for editorial planning
• Sync WordPress users to Google Sheets for CRM or reporting
• Store WordPress comments in Google Sheets for moderation tracking
• Create automated WordPress data backups in spreadsheets
• Generate reports for posts, pages, users, and comments
• Manage WordPress content data in a centralized spreadsheet

How to Use This Plugin

GSheetConnector for Core Lite allows you to send WordPress core data (Posts, Pages, Users, and Comments) to Google Sheets. You can configure it in two ways depending on how you want your data organized.

Option 1: Store All Data in One Spreadsheet (Tabs Based)

• Step 1: Create or Open a Google Spreadsheet
  ➜ Log into your Google account and open Google Sheets.
  ➜ Create a new spreadsheet or open an existing one.

• 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.

• Step 3: Select Data Types (Tab Creation)
  ➜ Scroll to the Google Sheets / Tab Name section.
  ➜ Enable the toggle for the tabs you want to create:

• Posts

• Pages
• Users
• Comments

➜ The plugin will automatically create separate tabs inside the selected spreadsheet.

• Step 4: Configure Sheet Headers (Columns)
  ➜ Go to Google Sheet Headers (Column Name) section.
  ➜ Choose the header group:

• Post Headers

• Page Headers
• Comment Headers

➜ Enable the fields you want to include (for example: Post Title, Post Date, Status, Author).
➜ Use Check All to include all available fields.
➜ Save the settings.

Option 2: Create Separate Sheets Using Feed Settings

• Step 1: Create a Feed
  ➜ Navigate to GSheetConnector → Settings → Feed Settings.
  ➜ Click Add Feeds.
  ➜ Enter a Feed Name.
  ➜ Select a Feed Type:

• Posts

• Pages
• Users
• Comments

➜ Save the feed and click Edit.

• 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:

• Posts Headers

• Pages Headers
• Users Headers
• Comments Headers

➜ Enable the fields you want to include as columns.
➜ Use Check All if required.

• Step 3: Create an Individual Sheet for the Feed
  ➜ Click Submit Data after selecting headers.
  ➜ The plugin will create an individual sheet (tab) inside the selected spreadsheet.
  ➜ Each feed maintains its own sheet for better data organization.

• 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.

External Services

GSheetConnector for Core Lite uses 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).

Google services are used only after the site administrator explicitly connects their Google account using the “Sign in with Google” button.

This plugin does NOT send any data to the plugin author’s servers.

Google Sheets API

Service: Google Sheets API (Google LLC)
Purpose: Create spreadsheets, create sheet tabs, and write WordPress data to Google Sheets.
Data Sent: Spreadsheet structure and WordPress data selected by the administrator.
When Data Is Sent: When the administrator performs actions such as submitting data or creating sheets.
API Scope Used: https://www.googleapis.com/auth/spreadsheets
Terms: https://policies.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Google Drive API

Service: Google Drive API (Google LLC)
Purpose: Retrieve available Google Spreadsheets and access spreadsheet metadata.
Data Sent: Spreadsheet metadata such as spreadsheet name and ID.
When Data Is Sent: When the administrator fetches or selects Google Sheets from plugin settings.
API Scopes Used:
https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/drive.metadata.readonly
Terms: https://policies.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Google OAuth 2.0

Service: Google OAuth 2.0 (Google LLC)
Purpose: Secure authentication and authorization for accessing 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.
Scope Used: https://www.googleapis.com/auth/userinfo.email
Endpoint: https://www.googleapis.com/oauth2/v3/certs
Terms: https://developers.google.com/terms
Privacy Policy: https://policies.google.com/privacy

Privacy Policy

GSheetConnector for Core Lite uses Google APIs to allow administrators to connect their WordPress site with Google Sheets.

The plugin does not collect, store, or transmit personal data to the plugin author or any external servers controlled by the plugin author.

Google authentication and access to Google Sheets are handled securely using Google OAuth 2.0. Google services are used only after the site administrator explicitly authorizes the connection by clicking the “Sign in with Google” button.

OAuth access tokens required for authentication are stored securely in the site’s WordPress database and are used only to access the Google Sheets and Google Drive APIs authorized by the administrator.

The plugin accesses Google Sheets and Google Drive data only after the administrator grants permission during the Google authorization process. Data is transmitted directly between the WordPress site and Google’s APIs.

No data is sold, shared with third parties, or stored on the plugin author’s servers.

1. Upload the gsheetconnector-for-core-lite folder to the /wp-content/plugins/ directory, or install the plugin through the WordPress Plugins screen directly.
2. Activate the plugin through the Plugins screen in WordPress.
3. Go to GSheetConnector from the WordPress admin menu.
4. Click Sign in with Google to authorize and connect your Google account.
5. Once connected, your Google Sheets will be available for selection in the plugin settings.

Can I export WordPress data to Google Sheets automatically?

Yes. GSheetConnector allows you to export WordPress Posts, Pages, Users, and Comments to Google Sheets using configurable feeds and spreadsheet tabs.

Why is my data not appearing in Google Sheets?

Please check the following:

1. Ensure your Google account is successfully connected.
2. Make sure the correct Google Spreadsheet is selected.
3. Verify that sheet tabs and column headers are created properly.
4. For Feed-based sheets, ensure you clicked Submit Data after selecting headers.
5. Confirm that the connected Google account has edit access to the spreadsheet.

Do I need to enter Spreadsheet ID or Sheet Name manually?

No.
The plugin automatically fetches your Google Spreadsheets and displays them in a dropdown.
You only need to select the desired spreadsheet.

How are sheets (tabs) created in Google Sheets?

Sheets can be created in two ways:

• From Settings, by enabling data type toggles (Posts, Pages, Users, Comments).
• From Feed Settings, where each feed creates its own individual sheet tab.

How do I connect my Google account?

Go to GSheetConnector from the WordPress admin menu and click Sign In With Google.
After granting permissions, the access code is generated automatically.
Click Save to complete the connection.

Which WordPress data types are supported?

The plugin supports the following WordPress core data types:

• Posts
• Pages
• Users
• Comments

1.0.3

• Changed: Renamed plugin folder to match WordPress.org plugin slug.
• Updated: Changes made to comply with WordPress.org plugin guidelines.

1.0.2

• Updated: Library updated to the latest version.
• Fixed: Nonce verification issue.

1.0.1

• Fixed: Warnings and errors reported by Plugin Check.

1.0.0

• Initial release