內容簡介
總結：這款外掛使用 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
