Ir al contenido
Documentación

Google Drive Integration

Esta página aún no está disponible en español. Se muestra la versión en inglés.

Connect Google Drive and pick the files you want in Querri. Querri can only open the files you pick.

How Google Drive access works

Section titled “How Google Drive access works”

Querri asks Google for the drive.file permission. With it, Querri can use only the files you select in Google’s file picker. It can’t browse your Drive, list your folders, or open any other file.

  1. You sign in with Google and approve the drive.file permission.
  2. You pick files in Google’s file picker.
  3. Querri syncs those files into its own storage, where they become sources in your Library.
  4. You add more files later the same way, whenever you need them.

Until you pick files, a Google Drive connector has nothing to load.

Connecting Google Drive

Section titled “Connecting Google Drive”
  1. Click Connect in the app rail to open Add data, and pick Google Drive. Admins can also click Connect on it in Settings → Connectors.
  2. Google’s sign-in window opens. Sign in and approve the permission.
  3. Google’s file picker opens. Select the files you want Querri to use. You can select several at once, search by name, and open folders to find files.
  4. Confirm your selection.
  5. Check that the files loaded. Click the connector under Connectors in the Library’s browse panel. If it says the connector “is connected, but no data has loaded yet”, click Load data now to run a full sync. Only the connector’s owner can start a load.

The connector lands in the workspace you’re in if you’re a member of it, or in your private workspace otherwise.

Supported files

Section titled “Supported files”
FileWhat happens
Google SheetsImported as an Excel workbook, with every sheet
ExcelImported
CSV and text filesImported
JSON and ParquetImported
Google Docs, Google Slides, PDFs and anything elseRefused as an unsupported file type

Querri loads data files only. To use a table from a Google Doc, copy it into a Google Sheet first.

Adding more files later

Section titled “Adding more files later”

Only the connector’s owner can add files.

  1. Open the connector’s Files tab. Admins can click Open on the Google Drive card in Settings → Connectors, which opens the dialog on that tab.
  2. Click Add Files. Google’s picker opens, titled “Select data files from Google Drive”.
  3. Select the files and confirm.

The Configuration tab has no settings for Google Drive, and no save button. It says: “Use the Files tab to add, view, or remove files from this Google Drive connection.”

In the Library, right-click the connector in the Connectors section and choose Configure…. Its side panel has a Files section for Google Drive.

Working with Drive files

Section titled “Working with Drive files”

Each file you picked becomes a source in your Library, ready to ask about. Querri works from the synced copy, not the live file in Drive.

To pick up changes made in Drive, give the connector a Full Refresh schedule on its Schedule tab. Only the owner can set one up. Scheduled syncs use credits when they run; syncs you start by hand don’t. See Sync Scheduling.

What Querri can’t access

Section titled “What Querri can’t access”

Because of the drive.file permission, Querri can’t:

  • see your Drive’s file list or folder structure
  • open files you haven’t picked, including files shared with you and files in shared drives

Disconnecting Google Drive

Section titled “Disconnecting Google Drive”

In Querri:

  1. Open the connector and click Disconnect, followed by its name.
  2. Confirm. Querri deletes the connector, the files it synced, and everyone’s access to them.

In Google:

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

Troubleshooting

Section titled “Troubleshooting”

The sign-in window or picker doesn’t open

Section titled “The sign-in window or picker doesn’t open”
  • Allow pop-ups for Querri in your browser.
  • Turn off pop-up blocking extensions, or try another browser.
  • Work Google accounts can block third-party apps. Ask your Google Workspace admin.

No files in the Library after connecting

Section titled “No files in the Library after connecting”

A Google Drive connector loads only the files you pick. Open its Files tab. If it says No files yet, click Add Files and pick some. If you’ve picked files but the connector’s Library view says no data has loaded yet, click Load data now.

A file was refused

Section titled “A file was refused”

Only data files load (see Supported files). Save the data as a Google Sheet, Excel or CSV file and pick that instead.

A file stopped updating

Section titled “A file stopped updating”

It may have been deleted or moved in Drive, or its sharing may have changed. Check it still exists in Drive, then pick it again with Add Files.

”Your authentication has expired”

Section titled “”Your authentication has expired””

Open the connector and click Reauthenticate. Don’t disconnect it: disconnecting deletes the files it synced.

Security

Section titled “Security”
  • Querri sees only what you pick. The drive.file permission limits Querri to the files you select.
  • Sign-in tokens stay out of sight. They’re kept out of logs and out of the browser.
  • Querri keeps a copy. Synced files are stored in Querri. Disconnecting deletes them.

Next Steps

Section titled “Next Steps”

Additional Resources

Section titled “Additional Resources”