​

Pre-Requisites

​

1. Create a Google Cloud Project

• Sign in to Google Cloud Console.
• Create a new Google Cloud Project (or select an existing one).
• Ensure the project is linked to your Google Workspace (required for Internal apps).

​

2. Enable Google Drive API

• Google Cloud Console, on left corner navigate to Menu → More products → Google Workspace → Product Library
• Locate Drive API and click Enable. This allows your project to access Google Drive resources.

​

3. Configure OAuth Consent Screen

• In Google Cloud Console, go to OAuth Consent Screen.

• Under App Information, provide an application name and support email. Click Next
• Under Audience, Select Internal (recommended for Workspace-only usage). Click Next.
• Under Contact Information, Enter an email address for Google notifications. Click Next.
• Review the Google API Services User Data Policy, click Continue and then Create. OAuth consent screen is now configured.

​

4. Create OAuth 2.0 Client Credentials

• Go to: Google Auth Platform → Clients

• Click Create Client and Choose Application type → Web application. Provide a unique name for your application.
• Under Redirect URI/Callback URI, add: https://oauth.peliqan.io and click Create.
• Save the generated client_id and client_secret

​

Connect Google Drive

​

Google Drive data sync to a data warehouse

​

Python functions in Data Apps

​

Get file details

googledrive_api = pq.connect('Google Drive')
file_id = "190yWcjVhyg2CfiSq0GIeoRJg84AhgVjQ"
result = googledrive_api.get('file_details', file_id = file_id)
st.json(result)

​

Get file download URL

googledrive_api = pq.connect('Google Drive')
file_id = "190yWcjVhyg2CfiSq0GIeoRJg84AhgVjQ"
result = googledrive_api.get('file_download_url', file_id = file_id)
st.json(result)

​

Get file Content

googledrive_api = pq.connect('Google Drive')
download_uri = "https://docs.google.com/fee/vhie4&exportFormat=docx"
result = googledrive_api.get('file_content', download_uri = download_uri)
st.json(result)