Setting Up Google API Credentials

Before you can sync data with Google Sheets, you need to create a Google Cloud project and set up OAuth 2.0 credentials. This is a one-time setup process.

Step 1: Create a Google Cloud Project

1. Go to the Google Cloud Console.
2. Click Select a project at the top, then click New Project.
3. Enter a project name (e.g., “SyncSheets”) and click Create.

Step 2: Enable Required APIs

SyncSheets requires two Google APIs to function:

• Google Sheets API — For reading and writing spreadsheet data.
• Google Drive API — For listing your spreadsheets (read-only metadata access).

To enable them:

1. In Google Cloud Console, go to APIs & Services → Library.
2. Search for Google Sheets API, click it, then click Enable.
3. Search for Google Drive API, click it, then click Enable.

Step 3: Configure OAuth Consent Screen

1. Go to APIs & Services → OAuth consent screen.
2. Select External user type (or Internal if using Google Workspace).
3. Fill in the required fields: App name, User support email, and Developer contact email.
4. On the Scopes step, add these two scopes:
   • https://www.googleapis.com/auth/spreadsheets
   • https://www.googleapis.com/auth/drive.metadata.readonly
5. Save and continue through the remaining steps.

Step 4: Create OAuth 2.0 Client ID

1. Go to APIs & Services → Credentials.
2. Click Create Credentials → OAuth client ID.
3. Set Application type to Web application.
4. Under Authorized redirect URIs, add the redirect URI shown in SyncSheets → Settings in your WordPress admin.
5. Click Create.
6. Copy the Client ID and Client Secret.

Step 5: Connect in WordPress

1. Go to SyncSheets → Settings in your WordPress admin.
2. Paste your Client ID and Client Secret.
3. Click Connect Google Account.
4. You will be redirected to Google to authorize access. Grant the requested permissions.
5. Once connected, you will see your Google account email displayed on the Settings page.

Your Google account is now connected and you are ready to create sync jobs!