Title: GSheets Connector
Author: raoinfotech
Published: <strong>2024 年 9 月 9 日</strong>
Last modified: 2026 年 6 月 11 日

---

搜尋外掛

![](https://ps.w.org/sheetlink/assets/banner-772x250.png?rev=3148393)

![](https://ps.w.org/sheetlink/assets/icon-128x128.gif?rev=3148348)

# GSheets Connector

 由 [raoinfotech](https://profiles.wordpress.org/raoinfotech/) 開發

[下載](https://downloads.wordpress.org/plugin/sheetlink.1.1.2.zip)

 * [詳細資料](https://tw.wordpress.org/plugins/sheetlink/#description)
 * [使用者評論](https://tw.wordpress.org/plugins/sheetlink/#reviews)
 * [開發資訊](https://tw.wordpress.org/plugins/sheetlink/#developers)

 [技術支援](https://wordpress.org/support/plugin/sheetlink/)

## 外掛說明

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](https://sheets.googleapis.com/v4/spreadsheets/)
and [Google Drive API](https://www.googleapis.com/drive/v3/files) to sync
 wordpress
data with google sheets. [Google Oauth](https://oauth2.googleapis.com/token) for
generating the token for authorizing Google API’s.

### Configuration

 1. Visit [Google Cloud](https://console.cloud.google.com/)
 2. Create New Project
 3. Enable Google Sheets API & Google Drive API from API & Services Library
 4. Create Credentials for Service Account
 5. Save JSON object Credentials under plugin settings page
 6. Share Service accouts email on Google sheets with edit access
 7. Create first Sheetlink Integration

### Creating Integration

### Available Filter Hooks

GSheets Connector is developer friendly and has some filters available to add the
custom fields

 1. Add additional data options while creating integrations
 2.     ```
        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;
        });
        ```
    
 3. Filter Output data before being sent to sheet
 4.     ```
        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](https://www.googleapis.com/oauth2/v1/tokeninfo)
endpoint 5. A short lived access token is retrieved using endpoint [Googleapis Oauth2](https://oauth2.googleapis.com/token)
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](https://www.googleapis.com/drive/v3/files)
and [Google Spreadsheets API](https://sheets.googleapis.com/v4/spreadsheets/) that
has been shared with client email [Google Drive](https://www.googleapis.com/drive/v3/files)
and update spreadsheet data with the help of [Spreadsheers API](https://sheets.googleapis.com/v4/spreadsheets/)

**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](https://raoinformationtechnology.com/privacy-policy/)

### Privacy Policy

GSheets Connector uses [Appsero](https://appsero.com) 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](https://appsero.com/privacy-policy/).

### v1.1.2

= Sync users created from wp-admin and REST API to Google Sheets

#### Tested against WordPress 7.0

### 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

## 使用者評論

這個外掛目前沒有任何使用者評論。

## 參與者及開發者

以下人員參與了開源軟體〈GSheets Connector〉的開發相關工作。

參與者

 *   [ raoinfotech ](https://profiles.wordpress.org/raoinfotech/)

[將〈GSheets Connector〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/sheetlink)

### 對開發相關資訊感興趣？

任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/sheetlink/)、查看
[SVN 存放庫](https://plugins.svn.wordpress.org/sheetlink/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/sheetlink/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/sheetlink/)。

## 中繼資料

 *  版本 **1.1.2**
 *  最後更新 **4 週前**
 *  啟用安裝數 **100+**
 *  WordPress 版本需求 ** 5.2 或更新版本 **
 *  已測試相容的 WordPress 版本 **7.0**
 *  PHP 版本需求 ** 7.2 或更新版本 **
 *  語言
 * [English (US)](https://wordpress.org/plugins/sheetlink/)
 * 標籤:
 * [automation](https://tw.wordpress.org/plugins/tags/automation/)[Google Sheets](https://tw.wordpress.org/plugins/tags/google-sheets/)
   [google spreadsheets](https://tw.wordpress.org/plugins/tags/google-spreadsheets/)
   [sheets](https://tw.wordpress.org/plugins/tags/sheets/)
 *  [進階檢視](https://tw.wordpress.org/plugins/sheetlink/advanced/)

## 評分

這個項目尚無任何評論記錄。

[Your review](https://wordpress.org/support/plugin/sheetlink/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/sheetlink/reviews/)

## 參與者

 *   [ raoinfotech ](https://profiles.wordpress.org/raoinfotech/)

## 技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

 [檢視技術支援論壇](https://wordpress.org/support/plugin/sheetlink/)