外掛標籤
開發者團隊
② 後台搜尋「Pi SheetBridge for Woo order with Google Sheets」→ 直接安裝（推薦）
原文外掛簡介
Auto send WooCommerce order data to Google Sheets. You can select the sheet and columns to send the order data. You can select a different sheet for each product. You can also select the order status to trigger data export to Google Sheets.
External services
This plugin connects to Google Sheets API to automatically sync WooCommerce order and product data to Google Sheets. This connection is required for the plugin’s core functionality.
Service provider: Google LLC (Google Sheets API)
What data is sent:
When an order status changes (configurable in plugin settings), the plugin transmits:
– Order data: order number, order date, order status, order total, billing/shipping addresses, customer information
– Product data: product names, SKUs, quantities, unit prices, totals, and any custom product meta fields configured by the user
– Custom meta fields: any custom order or product meta fields you have registered via the “Custom Meta Fields” settings tab
When data is sent:
– Automatically when an order transitions to a status selected in the plugin settings
– Data is only transmitted if you have configured a Google Sheet and provided valid Google Service Account credentials
– No data is sent if the plugin is not yet configured or if no order statuses have been selected for triggering
Required setup:
You must manually:
– Create a Google Cloud Project
– Enable Google Sheets API
– Create a Service Account with a JSON key
– Share your Google Sheet(s) with the service account email
Service Terms & Privacy:
– Google API Terms of Service
– Google Privacy Policy
Setup Guide: Getting Google Service Account JSON
Step 1: Create a Google Cloud Project
Go to Google Cloud Console
Sign in with your Google account
Click the Project selector (top-left, next to “Google Cloud”)
Click New Project
Enter a project name (e.g., “WordPress Sheets Sync”)
Click Create
Wait for the project to be created (may take a minute)
Step 2: Enable the Google Sheets API
In the Google Cloud Console, go to APIs & Services > Library
Search for “Google Sheets API”
Click on Google Sheets API
Click Enable
Wait for it to finish enabling
Step 3: Create a Service Account
Go to APIs & Services > Credentials
Click Create Credentials (top button)
Select Service Account
Fill in:
Service account name: e.g., wordpress-sheets
Service account ID: (auto-fills, leave as-is)
Description: (optional) e.g., For WordPress Google Sheets sync
Click Create and Continue
On the next screen, click Continue (skip the optional steps)
Click Done
Step 4: Create a JSON Key
In APIs & Services > Credentials, find your newly created service account in the Service Accounts section
Click on the service account name
Go to the Keys tab
Click Add Key > Create new key
Select JSON format
Click Create
A .json file will download to your computer automatically
Step 5: Copy the JSON Content
Open the downloaded .json file with a text editor (Notepad, VS Code, etc.)
Select all the content (Ctrl+A or Cmd+A)
Copy it (Ctrl+C or Cmd+C)
In your WordPress plugin settings, paste it into the Google Service Account JSON textarea field
Step 6: Share Your Google Sheet with the Service Account
Look inside the JSON file for the "client_email" field (looks like [email protected])
Copy that email address
Open the Google Sheet you want to sync with
Click Share (top-right)
Paste the service account email
Give it Editor access
Click Share
