This Privacy Policy explains how pg-gsheets manages data privacy and security when interacting with Google Sheets through your PostgreSQL environment.

​
1. No Data Collection

pg-gsheets does not collect, store, or share personal information with any external parties. All data-related operations, including querying and modifying Google Sheets, take place strictly within your local PostgreSQL environment. At no point is data transmitted to external servers managed by us.

​
2. Data Handling and Storage

Data accessed via pg-gsheets is handled entirely on your local system. Storage only occurs if you explicitly choose to save data within your PostgreSQL instance or export data files. In the absence of such explicit instructions, no data is retained once your PostgreSQL session concludes.

​
3. User Control Over Data

You have complete control over any data processed through pg-gsheets. You can manage, modify, and delete local data as needed within your PostgreSQL setup. Any files created or tables populated are entirely under your control.

​
4. Security Measures

The application follows industry-standard security measures, incorporating the OAuth flow with PKCE (Proof Key for Code Exchange) to ensure secure authentication. All data processing occurs locally, and no information is transmitted externally unless the user initiates an action.

​
5. OAuth Authentication and Access Scopes

For accessing Google Sheets, pg-gsheets uses OAuth authentication with the following scope:

https://www.googleapis.com/auth/spreadsheets

This scope grants permissions to read and modify your Google Sheets content. The authentication process is carried out directly between your local PostgreSQL environment and Google’s secure OAuth service.

​
6. OAuth Token Management

OAuth tokens required for accessing Google Sheets are stored locally within your PostgreSQL environment. These tokens are never shared with us or any third-party services.

​
7. Limited Third-Party Interaction

The only third-party service pg-gsheets interacts with is the Google Sheets API, which is used solely for managing your spreadsheets. There are no analytics, tracking, or data collection services included in pg-gsheets.

​
8. Privacy Policy Updates

This policy may be updated periodically to reflect changes in functionality or regulatory requirements. Any modifications will be marked by a new effective date. Continued use of pg-gsheets after changes implies acceptance of the updated terms.

​
9. Contact Information

For any questions or concerns about this Privacy Policy, you can reach out at m.taha.naveed27@gmail.com.

Usage