Step 1: Create or Open a Google Spreadsheet<\/strong>\n\u279c Log into your Google account and open Google Sheets.
\n\u279c Create a new spreadsheet or open an existing one.<\/p><\/li>\nStep 2: Connect Google Sheets in WordPress<\/strong>\n\u279c Log into your WordPress Admin Dashboard.
\n\u279c Navigate to GSheetConnector \u2192 Settings<\/strong>.
\n\u279c Click Fetch Sheets<\/strong> to load your Google Spreadsheets.
\n\u279c Select your Google Spreadsheet Name<\/strong> from the dropdown.<\/p><\/li>\nStep 3: Select Data Types (Tab Creation)<\/strong>\n\u279c Scroll to the Google Sheets \/ Tab Name<\/strong> section.
\n\u279c Enable the toggle for the tabs you want to create:<\/p><\/li>\nPosts<\/p><\/li>\n
Pages <\/li>\nUsers <\/li>\nComments <\/li>\n<\/ul>\n\n\u279c The plugin will automatically create separate tabs inside the selected spreadsheet.<\/p>\n\n
\nStep 4: Configure Sheet Headers (Columns)<\/strong>\n\u279c Go to Google Sheet Headers (Column Name)<\/strong> section.
\n\u279c Choose the header group:<\/p><\/li>\nPost Headers<\/p><\/li>\n
- Page Headers <\/li>\n
- Comment Headers <\/li>\n<\/ul>\n\n
\u279c Enable the fields you want to include (for example: Post Title, Post Date, Status, Author).
\n\u279c Use Check All<\/strong> to include all available fields.
\n\u279c Save the settings.<\/p>\n\n\n\nOption 2: Create Separate Sheets Using Feed Settings<\/h4>\n\n\nStep 1: Create a Feed<\/strong>\n\u279c Navigate to GSheetConnector \u2192 Settings \u2192 Feed Settings<\/strong>.
\n\u279c Click Add Feeds<\/strong>.
\n\u279c Enter a Feed Name<\/strong>.
\n\u279c Select a Feed Type<\/strong>:<\/p><\/li>\nPosts<\/p><\/li>\n
- Pages <\/li>\n
- Users <\/li>\n
- Comments <\/li>\n<\/ul>\n\n
\u279c Save the feed and click Edit<\/strong>.<\/p>\n\n\nStep 2: Configure Feed Headers<\/strong>\n\u279c Open the created feed from the feed list.
\n\u279c Select the Google Spreadsheet Name<\/strong> for this feed.
\n\u279c Based on the feed type, configure headers:<\/p><\/li>\nPosts Headers<\/p><\/li>\n
- Pages Headers <\/li>\n
- Users Headers <\/li>\n
- Comments Headers <\/li>\n<\/ul>\n\n
\u279c Enable the fields you want to include as columns.
\n\u279c Use Check All<\/strong> if required.<\/p>\n\n\nStep 3: Create an Individual Sheet for the Feed<\/strong>\n\u279c Click Submit Data<\/strong> after selecting headers.
\n\u279c The plugin will create an individual sheet (tab)<\/strong> inside the selected spreadsheet.
\n\u279c Each feed maintains its own sheet for better data organization.<\/p><\/li>\nStep 4: Manage Feeds<\/strong>\n\u279c View all feeds under Feed Settings<\/strong>.
\n\u279c Enable or disable feeds using the status toggle.
\n\u279c Edit or delete feeds anytime as needed.<\/p><\/li>\n<\/ul>\n\nExternal Services<\/h3>\n\n
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).<\/p>\n\n
Google services are used only after the site administrator explicitly connects their Google account using the \"Sign in with Google\" button.<\/p>\n\n
This plugin does NOT send any data to the plugin author's servers.<\/p>\n\n
Google Sheets API<\/h4>\n\n
Service: Google Sheets API (Google LLC)
\nPurpose: Create spreadsheets, create sheet tabs, and write WordPress data to Google Sheets.
\nData Sent: Spreadsheet structure and WordPress data selected by the administrator.
\nWhen Data Is Sent: When the administrator performs actions such as submitting data or creating sheets.
\nAPI Scope Used: https:\/\/www.googleapis.com\/auth\/spreadsheets
\nTerms: https:\/\/policies.google.com\/terms
\nPrivacy Policy: https:\/\/policies.google.com\/privacy<\/p>\n\n
Google Drive API<\/h4>\n\n
Service: Google Drive API (Google LLC)
\nPurpose: Retrieve available Google Spreadsheets and access spreadsheet metadata.
\nData Sent: Spreadsheet metadata such as spreadsheet name and ID.
\nWhen Data Is Sent: When the administrator fetches or selects Google Sheets from plugin settings.
\nAPI Scopes Used:\nhttps:\/\/www.googleapis.com\/auth\/drive.file
\nhttps:\/\/www.googleapis.com\/auth\/drive.metadata.readonly
\nTerms: https:\/\/policies.google.com\/terms
\nPrivacy Policy: https:\/\/policies.google.com\/privacy<\/p>\n\n
Google OAuth 2.0<\/h4>\n\n
Service: Google OAuth 2.0 (Google LLC)
\nPurpose: Secure authentication and authorization for accessing Google Sheets and Google Drive.
\nData Sent: OAuth authorization requests, access tokens, and refresh tokens.
\nWhen Data Is Sent: During the \u201cSign in with Google\u201d authorization process.
\nScope Used: https:\/\/www.googleapis.com\/auth\/userinfo.email
\nEndpoint: https:\/\/www.googleapis.com\/oauth2\/v3\/certs
\nTerms: https:\/\/developers.google.com\/terms
\nPrivacy Policy: https:\/\/policies.google.com\/privacy<\/p>\n\n
Privacy Policy<\/h3>\n\n
GSheetConnector for Core Lite uses Google APIs to allow administrators to connect their WordPress site with Google Sheets.<\/p>\n\n
The plugin does not collect, store, or transmit personal data to the plugin author or any external servers controlled by the plugin author.<\/p>\n\n
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 \u201cSign in with Google\u201d button.<\/p>\n\n
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.<\/p>\n\n
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.<\/p>\n\n
No data is sold, shared with third parties, or stored on the plugin author's servers.<\/p>\n\n\n
\n- Upload the
gsheetconnector-for-core-lite<\/code> folder to the \/wp-content\/plugins\/<\/code> directory, or install the plugin through the WordPress Plugins screen directly.<\/li>\n- Activate the plugin through the Plugins<\/strong> screen in WordPress.<\/li>\n
- Go to GSheetConnector<\/strong> from the WordPress admin menu.<\/li>\n
- Click Sign in with Google<\/strong> to authorize and connect your Google account.<\/li>\n
- Once connected, your Google Sheets will be available for selection in the plugin settings.<\/li>\n<\/ol>\n\n\n
\nCan I export WordPress data to Google Sheets automatically?<\/h3><\/dt>\nYes. GSheetConnector allows you to export WordPress Posts, Pages, Users, and Comments to Google Sheets using configurable feeds and spreadsheet tabs.<\/p><\/dd>\n
Why is my data not appearing in Google Sheets?<\/h3><\/dt>\nPlease check the following:<\/p>\n\n
\n- Ensure your Google account is successfully connected.<\/li>\n
- Make sure the correct Google Spreadsheet is selected.<\/li>\n
- Verify that sheet tabs and column headers are created properly.<\/li>\n
- For Feed-based sheets, ensure you clicked Submit Data<\/strong> after selecting headers.<\/li>\n
- Confirm that the connected Google account has edit access to the spreadsheet.<\/li>\n<\/ol><\/dd>\n
Do I need to enter Spreadsheet ID or Sheet Name manually?<\/h3><\/dt>\nNo.
\nThe plugin automatically fetches your Google Spreadsheets and displays them in a dropdown.
\nYou only need to select the desired spreadsheet.<\/p><\/dd>\n
How are sheets (tabs) created in Google Sheets?<\/h3><\/dt>\nSheets can be created in two ways:<\/p>\n\n
\u2022 From Settings<\/strong>, by enabling data type toggles (Posts, Pages, Users, Comments).
\n\u2022 From Feed Settings<\/strong>, where each feed creates its own individual sheet tab.<\/p><\/dd>\nHow do I connect my Google account?<\/h3><\/dt>\nGo to GSheetConnector<\/strong> from the WordPress admin menu and click Sign In With Google<\/strong>.
\nAfter granting permissions, the access code is generated automatically.
\nClick Save<\/strong> to complete the connection.<\/p><\/dd>\nWhich WordPress data types are supported?<\/h3><\/dt>\nThe plugin supports the following WordPress core data types:<\/p>\n\n
\u2022 Posts
\n\u2022 Pages
\n\u2022 Users
\n\u2022 Comments<\/p><\/dd>\n\n<\/dl>\n\n\n
1.0.3<\/h4>\n\n\n- Changed: Renamed plugin folder to match WordPress.org plugin slug.<\/li>\n
- Updated: Changes made to comply with WordPress.org plugin guidelines.<\/li>\n<\/ul>\n\n
1.0.2<\/h4>\n\n\n- Updated: Library updated to the latest version.<\/li>\n
- Fixed: Nonce verification issue.<\/li>\n<\/ul>\n\n
1.0.1<\/h4>\n\n\n- Fixed: Warnings and errors reported by Plugin Check.<\/li>\n<\/ul>\n\n
1.0.0<\/h4>\n\n\n- Initial release<\/li>\n<\/ul>","raw_excerpt":"Send WordPress Posts, Pages, Users and Comments to Google Sheets. A simple and powerful WordPress Google Sheets integration plugin for exporting data.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/275322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=275322"}],"author":[{"embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/westerndeal"}],"wp:attachment":[{"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=275322"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=275322"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=275322"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=275322"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=275322"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/bal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=275322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}