GSheetConnector – WordPress Core Google Sheets Connector – Export Posts, Pages, Users & Comments to Google Sheets in Real Time
GSheetConnector for Core Lite is an addon plugin—a bridge between your WordPress core content (Pages, Posts, Users and Comments) and Google Sheets . 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 ce
About this tool.
GSheetConnector for Core Lite is an addon plugin—a bridge between your WordPress core content (Pages, Posts, Users and Comments) and Google Sheets .
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.
🗂️ WordPress Core ➜ to 📊 Google Sheets
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.
⚡️ How to Use this Plugin
Option 1: All Data in One Spreadsheet (Tabs Based)
- Step 1: In Google Sheets ➜ 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 Type (Tab Creation) ➜ Scroll to Google Sheets / Tab Name section. ➜ Enable the toggle for the tabs you want to create:
- Posts
- Pages
- Users
- Comments ➜ The plugin will 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 (e.g. Post Title, Post Date, Status, Author). ➜ Use Check All to include all available fields. ➜ Save the settings.
Option 2: Separate Sheet for Each Data Type (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