=== GSheets Connector ===
Contributors: raoinfotech
Tags: Sheets,Sync Posts & Custom Post Types, Automation,Google Sheets,Google Spreadsheets
Requires at least: 5.5.0
Tested up to: 6.6.1
Requires PHP: 8.0
Stable tag: 1.0.0
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Sync your Wordpress Posts, Custom Post Type, Woocommerce Orders Data with Google Spreadsheets. 

== Description ==
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
5. Share Service accouts email on Google sheets with edit access
6. Create first Sheetlink Integration

== Creating Integration ==
[youtube https://youtu.be/qbxnyyoab48]

== 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/)