內容簡介
此外掛可自動將 WooCommerce 訂單資料傳送至 Google Sheets，使用者可選擇特定的工作表和欄位來接收訂單資訊，並可針對每個產品選擇不同的工作表，提升訂單管理效率。
【主要功能】
• 自動將訂單資料傳送至 Google Sheets
• 可選擇不同工作表與欄位
• 支援根據訂單狀態觸發資料傳送
• 傳送訂單與產品的詳細資訊
• 需配置 Google Service Account 認證
外掛標籤
開發者團隊
② 後台搜尋「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
Here is a example video showing how to create a Google Service Account and get the JSON file: YouTube Video.
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
