Google Drive Integration

Google Drive Integration

Connect your Google Drive to Querri and work with spreadsheets, documents, and datasets directly in your projects. With Querri’s secure file selection system, you have complete control over which files Querri can access.

How Google Drive Security Works

Querri uses Google’s most secure permission model for Drive access:

The drive.file Scope: Maximum Security

Unlike many integrations that request access to your entire Drive, Querri uses the drive.file scope, which means:

✅ Querri can ONLY access files you explicitly select ✅ Querri cannot see, list, or browse any other files in your Drive ✅ You maintain complete control over what Querri accesses ✅ No access to folders, file structure, or other Drive contents

This is the most restrictive and secure Drive permission available.

How It Works

1. You authenticate - Grant Querri the drive.file permission through Google OAuth
2. You select files - Use Google’s Picker to choose which specific files Querri can access
3. Querri accesses only those files - Only the files you selected are accessible
4. You can add more files anytime - Return to the picker to grant access to additional files

Important: Even after connecting, Querri cannot access ANY files until you explicitly select them using Google’s file picker.

Connecting Google Drive

Step 1: OAuth Authentication

1. Go to Settings → Connectors (/settings/connectors)
2. Find Google Drive in the Storage category
3. Click Connect
4. A popup opens to Google’s authorization page
5. Sign in to your Google account (if not already signed in)
6. Review the permissions Querri is requesting:
   • Permission: drive.file scope - Access only to files you explicitly select
7. Click Allow to grant access
8. The popup closes automatically

At this point, Querri still cannot access any of your files. You must select them in Step 2.

Step 2: Select Files with Google Picker

After OAuth authentication completes:

1. Google Picker automatically opens in the same popup
2. You’ll see your Google Drive files in the picker interface
3. Select the files you want to make available to Querri:
   • Click individual files to select them
   • You can select multiple files at once
   • Navigate folders to find your files
   • Search for files by name
4. Click Select or Choose to confirm
5. The picker closes and returns you to Querri

Only the files you selected are now accessible to Querri. No other files in your Drive can be seen or accessed.

Step 3: Files Appear in Your Library

After selecting files:

1. Navigate to your Library in Querri
2. You’ll see the Google Drive files you selected
3. Each file appears as a data source you can work with
4. Click any file to Create Project and start analyzing

Adding More Files Later

You can select additional files from Google Drive at any time:

1. Go to Settings → Connectors
2. Find your Google Drive connector
3. Click the Configure or Manage Files button
4. The Google Picker opens again
5. Select additional files you want to add
6. Click Select to confirm
7. New files immediately appear in your Library

This is the only way to grant Querri access to additional files. Querri cannot access any files you haven’t explicitly selected through the Picker.

Working with Google Drive Files

Supported File Types

Querri can import and analyze:

Google Workspace files:

• Google Sheets (exported as CSV automatically)
• Google Docs (exported as text)
• Google Slides (exported as PDF)

Standard files:

• CSV files
• Excel files (.xlsx, .xls)
• JSON files
• Parquet files
• Text files

Creating Projects from Drive Files

To analyze a Google Drive file:

1. Go to your Library
2. Find the Drive file you want to analyze
3. Click to Create Project from that file
4. The file data is imported into a QuerriDataFrame
5. Start asking questions in natural language

Examples:

• “Show me the top 10 rows”
• “What’s the average sales by region?”
• “Compare this month’s data to last month”
• “Find all records where status is ‘active‘“

Google Sheets Handling

Google Sheets are automatically converted to CSV format when imported:

• All sheets/tabs are processed
• Formulas are evaluated to their values
• Formatting is preserved where possible
• Date and number formats are detected automatically

What Querri Cannot Access

Because of the drive.file scope restrictions:

❌ Cannot browse your Drive or see your file list ❌ Cannot access any files you haven’t selected via Picker ❌ Cannot see your folder structure ❌ Cannot list files in any folder ❌ Cannot access shared files unless you explicitly select them ❌ Cannot access files in Shared Drives unless you select them

This means maximum privacy and security for your Google Drive.

Removing File Access

Remove Individual Files

To remove Querri’s access to specific files:

1. Go to Settings → Connectors
2. Find your Google Drive connector
3. Click Manage Files
4. Deselect or remove files you want to revoke access to
5. Those files are immediately inaccessible to Querri

Disconnect Google Drive Entirely

To completely disconnect Google Drive:

In Querri:

1. Go to Settings → Connectors
2. Find your Google Drive connection
3. Click Disconnect
4. Confirm disconnection

In Google:

1. Go to myaccount.google.com/permissions
2. Find Querri in your connected apps
3. Click Remove Access

This immediately revokes all access and removes all selected files from Querri.

File Metadata and Privacy

When you select a file via Google Picker, Querri stores:

• File ID (needed to access the file)
• File name
• MIME type
• File size
• Last modified date
• Icon link (for display)
• Web view link (to open in Google Drive)

Querri does NOT store:

• File contents permanently
• File list from your Drive
• Folder structure
• Other metadata beyond what’s listed above

File contents are only fetched when you create a project from a file, and only the data you import into a QuerriDataFrame is stored.

Troubleshooting

Popup Blocked

Problem: OAuth or Picker popup doesn’t open.

Solution:

• Check browser popup blocker settings
• Allow popups for Querri’s domain
• Try a different browser
• Disable popup-blocking extensions

Cannot See Files After Connecting

Problem: Connected Google Drive but see no files in Library.

Solution:

• You need to select files via the Picker
• Go to Settings → Connectors → Google Drive → Manage Files
• Use Google Picker to select files
• Files will appear in Library after selection

”File Not Accessible” Error

Problem: Previously accessible file now shows error.

Solution:

• File may have been deleted or moved in Google Drive
• Permissions on the file may have changed
• Reselect the file via Picker to regrant access
• Check if the file still exists in your Google Drive

Connection Shows “Expired”

Problem: Connector status shows “Token expired” or “Reconnect required.”

Solution:

• Click Reconnect in connector settings
• Complete OAuth authorization again
• File selections are preserved
• No need to reselect files

Picker Shows “Access Denied”

Problem: Google Picker fails to load or shows access error.

Solution:

• Ensure you granted the drive.file permission
• Try disconnecting and reconnecting Google Drive
• Clear browser cookies for Google
• Check if your Google account has restrictions (corporate accounts)

Best Practices

File Organization

• Select related files together: Pick all files for a project at once
• Use clear file names: Easier to find files in Library
• Organize in Drive: Well-organized Drive makes Picker navigation easier
• Regular cleanup: Remove old files from Querri when no longer needed

Security

• Only select necessary files: Don’t grant access to files you won’t use
• Review periodically: Check which files Querri has access to
• Revoke when done: Remove file access when projects are complete
• Monitor activity: Check Google account activity for API access

Performance

• File size: Very large files (>100MB) may take longer to import
• Google Sheets: Large sheets are automatically converted to CSV efficiently
• Multiple files: Select multiple files at once rather than one at a time
• Refresh when needed: Files are imported once; refresh projects to get updates

Technical Details

How drive.file Scope Works

The drive.file scope is part of Google’s OAuth 2.0 framework:

1. Initial grant: You authorize Querri with drive.file scope
2. File selection: You use Google Picker to select files
3. Permission establishment: Querri makes an API call to each selected file
4. Ongoing access: Querri can only access those specific files
5. No discovery: Querri cannot list or discover other files

Google Picker API

Google Picker is Google’s official UI for file selection:

• Hosted by Google (not Querri)
• Uses your Google authentication
• Shows only files you have access to
• Provides metadata directly to the app
• Integrated with drive.file scope for security

Token Management

OAuth tokens are managed automatically:

• Access tokens expire after 1 hour
• Refresh tokens are used to get new access tokens
• Tokens are encrypted at rest in Querri
• Token refresh is automatic and transparent
• File selections persist across token refreshes

Next Steps

• File Uploads - Upload files directly to Querri’s library
• Managing Connections - Edit and manage connectors
• Data Cleaning - Clean imported Google Drive data

Additional Resources

• Google Drive API documentation: developers.google.com/drive
• OAuth 2.0 scopes: developers.google.com/identity/protocols/oauth2/scopes
• Google Picker API: developers.google.com/picker