GSheets Connector

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

1. 01Visit Google Cloud
2. 02Create New Project
3. 03Enable Google Sheets API & Google Drive API from API & Services Library
4. 04Create Credentials for Service Account
5. 05Save JSON object Credentials under plugin settings page
6. 06Share Service accouts email on Google sheets with edit access
7. 07Create first Sheetlink Integration

Creating Integration

Available Filter Hooks

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

1. 08Add 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; });
2. 09Filter 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