Google API Setup

To use Google Sheets or Google Drive as an import source, you need Google API credentials. This page walks you through it.

What You Will Create

Most users only need the API Key. Create OAuth only if you want:

• Private Google Sheets
• Google Drive files
• Write-back to Google Sheets (export destination)

Part 1 — Create a Google Cloud Project

Step 1

Go to console.cloud.google.com.

Sign in with a Google account.

Step 2

Top-left, click the project dropdown (usually says "Select a project").

Click New Project.

Step 3

Fill in:

• Project name: WooCommerce Import Export (or any name)
• Organization: Leave default

Click Create.

Wait 30 seconds for the project to initialize.

Step 4

Top-left, click the project dropdown again. Pick the new project.

Part 2 — Enable APIs

Enable Sheets API

1. Left sidebar → APIs & Services → Library
2. Search for Google Sheets API
3. Click the result
4. Click Enable
5. Wait for confirmation

Enable Drive API (If Using Drive)

1. Back to APIs & Services → Library
2. Search for Google Drive API
3. Click → Enable

Part 3 — Create an API Key (Simple — For Public Sheets)

Use this if you only need to read public Google Sheets.

Step 1

Left sidebar → APIs & Services → Credentials.

Step 2

Click + Create Credentials → API Key.

Step 3

A popup appears with your new API key. Copy it.

Click Close.

Step 4 — Restrict the Key (Recommended)

1. Click the pencil icon next to the new key
2. Under API restrictions, select Restrict key
3. Pick Google Sheets API from the dropdown
4. Click Save

This prevents someone from stealing your key and using it for other services.

Step 5 — Paste in the Plugin

1. WordPress admin → Webkul WC Addons → Settings → Cloud Storage & API
2. Under Google APIs → paste the key into Google API Key
3. Click Save Changes

Done. Public sheets work now.

Part 4 — Create OAuth 2.0 Client (Advanced — For Private Data)

Use this if you need private Google Sheets or Google Drive.

Step 1 — Configure Consent Screen

1. Left sidebar → APIs & Services → OAuth consent screen
2. Pick External (unless you have a Google Workspace)
3. Click Create
4. Fill in:
   • App name: WooCommerce Import Export
   • User support email: Your email
   • Developer contact: Your email
5. Click Save and Continue
6. On the Scopes page, click Add or Remove Scopes
7. Add these scopes:
   • https://www.googleapis.com/auth/spreadsheets (read/write sheets)
   • https://www.googleapis.com/auth/drive.readonly (read drive)
8. Click Update then Save and Continue
9. On the Test users page, click + Add Users and add your own email
10. Click Save and Continue
11. Review and click Back to Dashboard

Step 2 — Create OAuth Credentials

1. Left sidebar → APIs & Services → Credentials
2. Click + Create Credentials → OAuth client ID
3. Application type: Web application
4. Name: WooCommerce Plugin
5. Under Authorized redirect URIs, click + Add URI
6. Paste: https://your-site.com/wp-admin/admin.php?page=wkaie-settings&oauth=callback
   • Replace your-site.com with your actual domain
7. Click Create

A popup appears with:

• Client ID — copy it
• Client Secret — copy it

Step 3 — Paste in the Plugin

1. WordPress admin → Webkul WC Addons → Settings → Cloud Storage & API
2. Under Google APIs:
   • Paste Client ID in the OAuth Client ID field
   • Paste Client Secret in the OAuth Client Secret field
3. Click Save Changes

Step 4 — Authorize

1. Click Authorize with Google (button appears after saving credentials)
2. Google asks you to sign in
3. It shows a warning "Google hasn't verified this app" — click Advanced → Go to [App name] (unsafe)
   • This is normal for unverified private apps
4. Click Continue and grant permissions
5. You are redirected back to WordPress
6. The plugin now has OAuth access

Publishing the App (Optional)

Your OAuth credentials work for your account only (as "test user") by default. For production:

1. APIs & Services → OAuth consent screen
2. Click Publish App
3. Google reviews apps that request sensitive scopes — the Sheets and Drive scopes are sensitive
4. For personal use, skip publishing — keep yourself as a test user

Checking It Works

For API Key

Google Sheets source — paste the sheet URL and the plugin uses your API key to fetch rows.

1. Wizard → Step 1 → Source: Google Sheets
2. Paste a sheet URL (make sure sharing is on)
3. Click Next
4. If columns load in Step 2, the API key works

For OAuth

Google Drive source — browse or paste a file ID once OAuth is authorized.

1. Settings → Test Google Connection (if button exists)
2. Or try importing a private sheet
3. If data loads, OAuth works

API Limits

Google APIs have usage quotas:

• Sheets API: 300 requests per minute per project (free)
• Drive API: 1,000 requests per 100 seconds per user

For most stores, this is plenty. For heavy use, request a quota increase in Cloud Console.

Troubleshooting

Security Notes

• Never share your Client Secret in public
• The plugin stores credentials encrypted with AES-256
• You can revoke access anytime from myaccount.google.com/permissions
• For compliance, rotate API keys every 6-12 months

Related Pages

• Import Sources → Google Sheets
• Import Sources → Google Drive
• Tutorial: Google Sheets Sync
• Settings → Cloud Storage & API