前言介紹
- 這款 WordPress 外掛「GSheets Connector」是 2024-09-08 上架。
- 目前有 60 個安裝啟用數。
- 上一次更新是 2025-02-28，距離現在已有 64 天。
- 外掛最低要求 WordPress 5.2 以上版本才可以安裝。
- 外掛要求網站主機運作至少需要 PHP 版本 7.2 以上。
- 尚未有人給過這款外掛評分。
- 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。
外掛協作開發者
外掛標籤
sheets | automation | Google Sheets | google spreadsheets | Sync Posts & Custom Post Types |
內容簡介
總結：這款外掛使用 Google Sheets API 和 Google Drive API 同步 WordPress 資料到 Google Sheets 上，讓你可以即時將 POST、CPT、Woocommerce 訂單以及元數據映射到試算表中。透過 Google Oauth 生成授權令牌來授權 Google API 的使用。
問題與答案：
1. 這款外掛可以同步哪些類型的資料到 Google Sheets？
- POST、CPT、Woocommerce 訂單以及元數據。
2. 這款外掛使用什麼 API 來實現 WordPress 資料與 Google Sheets 的同步？
- 使用 Google Sheets API 和 Google Drive API。
3. 如何取得授權令牌來授權 Google API 的使用？
- 使用 Google Oauth 生成令牌。
4. 在配置外掛時，需要進行哪些步驟？
- 參訪 Google Cloud、建立新專案、啟用 Google Sheets API 和 Google Drive API、創建服務帳戶憑證、保存 JSON 對象憑證、在外掛設置頁面分享服務帳戶電子郵件等。
5. 當使用者與 Google Drive 帳戶連結應用程式進行驗證時，應用程式獲取哪些資訊？
- WordPress 網站地址、OAuth 流程生成的短期存取令牌等。
原文外掛簡介
Get real time POST, CPT, Woocommerce Order along with meta fields mapping on sheets, easy mapping and configuration with each column and Post Column.
This plugin uses Google Sheets API and Google Drive API to sync
wordpress data with google sheets.
Google Oauth for generating the token for authorizing Google API’s.
Configuration
Visit Google Cloud
Create New Project
Enable Google Sheets API & Google Drive API from API & Services Library
Create Credentials for Service Account
Save JSON object Credentials under plugin settings page
Share Service accouts email on Google sheets with edit access
Create first Sheetlink Integration
Creating Integration
Available Filter Hooks
GSheets Connector is developer friendly and has some filters available to add the custom fields
Add additional data options while creating integrations
apply_filters( 'rgsi_data_options', $data );
add_filter( 'rgsi_data_options', function($data) {
//Need to add prefix _custom_ in order to feed the custom data in rgsi_mapped_data hook
$data['_custom_company_id'] = "Company ID"
return $data;
});
Filter Output data before being sent to sheet
apply_filters( 'rgsi_mapped_data',$parsed_data, $post,$custom_keys );
add_filter( 'rgsi_mapped_data', function( $parsed_data, $post, $custom_keys ){
return $parsed_data;
});
Data Privacy
The Application obtains the following information when you use the built-in app for authentication and link the Application with your Google Drive Account:
1. Your WordPress website address.
2. A short-lived access token gets generated by the OAuth flow.
3. Service account Credentials in JSON format are encrypted and saved into the database. This credential is used for fetching and validating the access token.
4. Access token is validated using GoogleApis Token Info endpoint
5. A short lived access token is retrieved using endpoint Googleapis Oauth2 by sending JWT encoded Private key and client_email
6. Retrieved access token is used to accesss list of spreadsheets with the help of Google Drive API and Google Spreadsheets API that has been shared with client email Google Drive and update spreadsheet data with the help of Spreadsheers API
IMPORTANT: When you use the Application, all other communications are strictly between your server and the cloud storage service servers. The communication is encrypted and the communication will not go through our servers. We do not collect and do not have access to your files.
Read more : RaoInformation Technology Privacy Policy
Privacy Policy
GSheets Connector uses Appsero SDK to collect some telemetry data upon user’s confirmation. This helps us to troubleshoot problems faster & make product improvements.
Appsero SDK does not gather any data by default. The SDK only starts gathering basic telemetry data when a user allows it via the admin notice. We collect the data to ensure a great user experience for all our users.
Integrating Appsero SDK DOES NOT IMMEDIATELY start gathering data, without confirmation from users in any case.
Learn more about how Appsero collects and uses this data.
v1.0.0
= Initial Version
v1.1.0
= Fix Create Type Integration adding multiple times
Added registeration date support for user type
Add custom filter hooks to support custom fields
v1.1.0
= Fix Feedbackform Url
= Integrate AppSero Analytics
各版本下載點
- 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
- 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「GSheets Connector」來進行安裝。
（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。
1.0.0 | 1.1.0 | 1.1.1 | trunk |
延伸相關外掛（你可能也想知道）
暫無相關外掛推薦。