Service Account Setting PRO Version

GSheetConnector for WP Core Pro — Service Account Setup
This guide explains how to properly configure a Google Service Account and connect it with GSheetConnector for WP Core, ensuring your WordPress posts, pages, users, and other data sync securely and automatically to Google Sheets.

If you are using personal gmail accounts with @gmail.com emails, then prefer to use the Service Account Integration to avoid Google App Verification process

Follow each step and the screenshots to complete the connection successfully.

This guide explains how to create a Google Service Account and connect it with GSheetConnector for WP Core Plugin, enabling your WordPress posts, pages, users, and comments to sync securely and automatically to Google Sheets.

Step 1: Open Google Cloud Console

Visit: https://console.cloud.google.com
From the top project dropdown, select your project (e.g., Demo GSheetConnector).

Step 2: Go to IAM & Admin → Service Accounts

From the left sidebar, click IAM & Admin, then select Service Accounts from the dropdown.

Step 3: Create a New Service Account

1. Click the + CREATE SERVICE ACCOUNT button.

2. Fill in the details:

   • Service account name: e.g., GSheetConnector-wp-core-sync

   • Description (optional)

3. Click Create and Continue.

Step 4: Grant Permissions to the Service Account

1. Under Grant this service account access to the project, select:

   • Role: Editor
     (Alternatively, for limited access: Sheets API Editor + Drive API User)

2. Click Continue, then Done.

Step 5: Generate a JSON Key

1. From the list of service accounts, select the one you just created.

2. Go to the Keys tab → Add Key → Create New Key.

3. Select JSON and click Create.

4. A .json file will download to your computer. 🔒 Keep it safe—you’ll need it in the plugin.

Step 6: Enable Required Google APIs

1. Go to APIs & Services → Library in Google Cloud.

2. Search and enable the following APIs:

   • Google Drive API → Click Enable

   • Google Sheets API → Click Enable

These APIs allow your service account to access, update, and manage Google Sheets for real-time sync.

Step 7: Connect the Service Account in GSheetConnector for WP Core

1. In WordPress admin, navigate to:
   GSheetConnector for WP Core → Settings

2. Under Authentication Method, select: 🔘 Service Account

3. Upload the downloaded .json key file and click Save Changes.

4. Your service account will be authenticated successfully.

Step 8: Configure Google Sheet Connection

Auto Sheet Settings

1. Create a new Google Sheet in your Google Drive.

2. Share the sheet with your Service Account email (e.g., your-service-account@project-id.iam.gserviceaccount.com) with at least Editor access.

3. In the plugin, all sheets accessible to the service account will be fetched automatically in the dropdown.

4. Select your target sheet and save the feed settings to map fields.

Manual Sheet Settings

1. Enable the Manual Sheet toggle in feed settings.

2. Enter:

   • Sheet Name

   • Sheet ID

   • Tab Name

   • Tab ID

3. Map your WordPress post, page, user, or comment fields to the corresponding Google Sheet columns.

4. Click Save Feed.

Important: Your Google Sheet must be shared with the Service Account email. If shared correctly, the email will appear green in the plugin; otherwise, it will appear red.

Step 9: Testing & Verification

1. Submit a new WordPress post, page, comment, or user entry (depending on your feed).

2. Verify the data appears in the connected Google Sheet.

Troubleshooting

• Ensure the sheet is shared with the Service Account email with Editor rights.

• Re-upload the .json file in plugin settings if authentication fails.

• Verify that the Google Cloud project has Sheets API and Drive API enabled.

• Contact support with plugin version and error messages if issues persist.