{"id":275322,"date":"2026-03-13T22:07:19","date_gmt":"2026-03-13T22:07:19","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/gsheetconnector-for-wp-core-lite\/"},"modified":"2026-04-13T12:48:02","modified_gmt":"2026-04-13T12:48:02","slug":"gsheetconnector-for-core-lite","status":"publish","type":"plugin","link":"https:\/\/kal.wordpress.org\/plugins\/gsheetconnector-for-core-lite\/","author":12667560,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.4","stable_tag":"1.0.4","tested":"6.9.4","requires":"5.0","requires_php":"7.4","requires_plugins":null,"header_name":"GSheetConnector for Core Lite","header_author":"GSheetConnector","header_description":"Connect WordPress core data (Pages, Posts, Users and Comments) with Google Sheets easily.","assets_banners_color":"eaeef1","last_updated":"2026-04-13 12:48:02","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.paypal.me\/WesternDeal","header_plugin_uri":"https:\/\/www.gsheetconnector.com\/gsheetconnector-for-wp-core","header_author_uri":"https:\/\/www.gsheetconnector.com\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":303,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.3":{"tag":"1.0.3","author":"westerndeal","date":"2026-03-13 22:15:49"},"1.0.4":{"tag":"1.0.4","author":"fatemap","date":"2026-04-13 12:48:02"}},"upgrade_notice":[],"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3496640,"resolution":"128x128","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":3496640,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.3","1.0.4"],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"Google API Integration screen \u2013 Connect your Google account using the \"Sign In With Google\" button.","2":"Core Google Sheet Settings \u2013 Fetch and select your Google Spreadsheet from the dropdown.","3":"Feed Settings \u2013 Create and manage feeds for Posts, Pages, Users, or Comments.","4":"Create Feed \u2013 Add a new feed by selecting the feed type and providing a feed name.","5":"Posts Feed Headers \u2013 Select Post fields to create columns in Google Sheets.","6":"Pages Feed Headers \u2013 Configure Page-related fields for Google Sheets columns.","7":"Users Feed Headers \u2013 Choose User fields to send data to Google Sheets.","8":"Comments Feed Headers \u2013 Select Comment fields and create a dedicated sheet tab.","9":"Feed List View \u2013 Enable, disable, edit, or delete feeds from the feed management screen."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[107,25296,243,166,1917],"plugin_category":[44],"plugin_contributors":[85967],"plugin_business_model":[],"class_list":["post-275322","plugin","type-plugin","status-publish","hentry","plugin_tags-comments","plugin_tags-google-sheets","plugin_tags-pages","plugin_tags-posts","plugin_tags-users","plugin_category-discussion-and-community","plugin_contributors-westerndeal","plugin_committers-abdullah17","plugin_committers-fatemap","plugin_committers-westerndeal"],"banners":{"banner":"https:\/\/ps.w.org\/gsheetconnector-for-core-lite\/assets\/banner-772x250.png?rev=3496640","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/gsheetconnector-for-core-lite\/assets\/icon-128x128.png?rev=3496640","icon_2x":false,"generated":false},"screenshots":[],"raw_content":"\n

GSheetConnector for Core Lite is an addon plugin\u2014a bridge between your WordPress<\/a> core content (Pages, Posts, Users and Comments) and Google Sheets<\/a>.<\/p>\n\n

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.<\/p>\n\n

\ud83d\uddc2\ufe0f WordPress Core \u279c to \ud83d\udcca Google Sheets<\/h4>\n\n

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.<\/p>\n\n

\u26a1\ufe0f How to Use this Plugin<\/h4>\n\n

Option 1: All Data in One Spreadsheet (Tabs Based)<\/h4>\n\n
    \n

  • Step 1: In Google Sheets<\/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>\n

  • Step 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>\n

  • Step 3: Select Data Type (Tab Creation)<\/strong>\n\u279c Scroll to Google Sheets \/ Tab Name<\/strong> section.
    \n\u279c Enable the toggle for the tabs you want to create:<\/p>\n\n

      \n
    • Posts <\/li>\n
    • Pages <\/li>\n
    • Users <\/li>\n
    • Comments
      \n\u279c The plugin will create separate tabs inside the selected spreadsheet.<\/li>\n<\/ul><\/li>\n

    • Step 4: Configure Sheet Headers (Columns)<\/strong>\n\u279c Go to Google Sheet Headers (Column Name)<\/strong> section.
      \n\u279c Choose the header group:<\/p>\n\n

        \n
      • Post Headers <\/li>\n
      • Page Headers <\/li>\n
      • Comment Headers
        \n\u279c Enable the fields you want to include (e.g. Post Title, Post Date, Status, Author).
        \n\u279c Use Check All<\/strong> to include all available fields.
        \n\u279c Save the settings.<\/li>\n<\/ul><\/li>\n<\/ul>\n\n

        Option 2: Separate Sheet for Each Data Type (Feed Settings)<\/h4>\n\n
          \n

        • Step 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>\n\n

            \n
          • Posts <\/li>\n
          • Pages <\/li>\n
          • Users <\/li>\n
          • Comments
            \n\u279c Save the feed and click Edit<\/strong>.<\/li>\n<\/ul><\/li>\n

          • Step 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>\n\n

              \n
            • Posts Headers <\/li>\n
            • Pages Headers <\/li>\n
            • Users Headers <\/li>\n
            • Comments Headers
              \n\u279c Enable the fields you want to include as columns.
              \n\u279c Use Check All<\/strong> if required.<\/li>\n<\/ul><\/li>\n

            • Step 3: Create an Individual Sheet per 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 separate sheet for better data organization.<\/p><\/li>\n

            • Step 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\n

              External Services<\/h3>\n\n

              GSheetConnector for Core Lite relies on Google APIs to connect WordPress with Google Sheets.\nThese services are required for authentication and for creating, reading, and updating spreadsheets\nbased on WordPress core data (Posts, Pages, Users, and Comments).<\/p>\n\n

              This plugin does NOT send any data to the plugin author\u2019s servers.<\/p>\n\n\n\n

              1. Google Sheets API<\/h4>\n\n

              \u2022 Service: Google Sheets API (Google LLC)
              \n\u2022 Purpose:
              \n Used to create spreadsheets, create sheet tabs, write WordPress data into sheets,\n and read existing spreadsheet information.
              \n\u2022 Data Sent:
              \n Spreadsheet structure and content based on the administrator\u2019s selected WordPress data.
              \n\u2022 When Data Is Sent:
              \n Only when the site administrator explicitly performs an action such as submitting data\n or creating sheets.
              \n\u2022 API Scope Used:
              \n https:\/\/www.googleapis.com\/auth\/spreadsheets
              \n\u2022 Terms of Service:
              \n https:\/\/policies.google.com\/terms
              \n\u2022 Privacy Policy:
              \n https:\/\/policies.google.com\/privacy<\/p>\n\n\n\n

              2. Google Drive API<\/h4>\n\n

              \u2022 Service: Google Drive API (Google LLC)
              \n\u2022 Purpose:
              \n Used to list available Google Spreadsheets and access spreadsheet file metadata.
              \n\u2022 Data Sent:
              \n File metadata (such as spreadsheet ID and name).
              \n\u2022 When Data Is Sent:
              \n When the administrator fetches or selects Google Spreadsheets from the plugin settings.
              \n\u2022 API Scopes Used:
              \n https:\/\/www.googleapis.com\/auth\/drive.file
              \n https:\/\/www.googleapis.com\/auth\/drive.metadata.readonly
              \n\u2022 Terms of Service:
              \n https:\/\/policies.google.com\/terms
              \n\u2022 Privacy Policy:
              \n https:\/\/policies.google.com\/privacy<\/p>\n\n\n\n

              3. Google OAuth 2.0 Authentication<\/h4>\n\n

              \u2022 Service: Google OAuth 2.0 (Google LLC)\n\u2022 Purpose:
              \n Used to securely authenticate users and authorize access to Google Sheets and Google Drive.
              \n\u2022 Data Sent:
              \n OAuth authorization requests, access tokens, and refresh tokens.
              \n\u2022 When Data Is Sent:
              \n During the \u201cSign in with Google\u201d authorization process.
              \n\u2022 API Scope Used:
              \n https:\/\/www.googleapis.com\/auth\/userinfo.email
              \n\u2022 Certificate Endpoint Used:
              \n https:\/\/www.googleapis.com\/oauth2\/v3\/certs
              \n\u2022 Data Storage:
              \n OAuth access tokens are stored securely in the site\u2019s WordPress database.
              \n\u2022 Terms of Service:
              \n https:\/\/developers.google.com\/terms
              \n\u2022 Privacy Policy:
              \n https:\/\/policies.google.com\/privacy<\/p>\n\n

              Privacy Policy<\/h3>\n\n

              GSheetConnector for Core Lite uses Google APIs to allow users to connect their WordPress site with Google Sheets.<\/p>\n\n

              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.<\/p>\n\n

              Access tokens required for Google authentication are stored securely in the site\u2019s own WordPress database and are used only to perform actions requested by the site administrator.<\/p>\n\n

              The plugin only accesses Google Sheets and Google Drive data after explicit user consent during the Google authorization process.<\/p>\n\n

              No data is sold or shared with third parties, and no data is stored on the plugin author\u2019s servers.<\/p>\n\n\n

                \n
              1. Upload gsheetconnector-for-core-lite<\/code> to the \/wp-content\/plugins\/<\/code> directory, or install it via Plugins \u2192 Add New \u2192 Search<\/strong>.<\/li>\n
              2. Activate the plugin through the Plugins<\/strong> screen in WordPress.<\/li>\n
              3. Go to GSheetConnector<\/strong> from the WordPress admin menu.<\/li>\n
              4. Click Sign In With Google<\/strong> to authorize and connect your Google account.<\/li>\n
              5. Once connected, your Google Sheets will be available for selection.<\/li>\n<\/ol>\n\n\n
                \n

                Why is my data not appearing in Google Sheets?<\/h3><\/dt>\n

                Please check the following:<\/p>\n\n

                  \n
                1. Ensure your Google account is successfully connected.<\/li>\n
                2. Make sure the correct Google Spreadsheet is selected.<\/li>\n
                3. Verify that sheet tabs and column headers are created properly.<\/li>\n
                4. For Feed-based sheets, ensure you clicked Submit Data<\/strong> after selecting headers.<\/li>\n
                5. 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>\n

                  No.
                  \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>\n

                  Sheets 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>\n

                  How do I connect my Google account?<\/h3><\/dt>\n

                  Go 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>\n

                  Which WordPress data types are supported?<\/h3><\/dt>\n

                  The 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.4<\/h4>\n\n
                    \n
                  • Fixed: Authentication-related issue.<\/li>\n
                  • Added: Freemius integration.<\/li>\n<\/ul>\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":"Connect WordPress core data (Pages, Posts, Users and Comments) with Google Sheets easily.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/275322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=275322"}],"author":[{"embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/westerndeal"}],"wp:attachment":[{"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=275322"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=275322"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=275322"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=275322"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=275322"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/kal.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=275322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}