Skip to main content

Google Drive Memory

Google Drive Memory lets you connect a file from Drive so Hana can use it when you ask questions in chat.

What it does

When you add a Drive file as memory, Hana reads the file content, breaks it into searchable knowledge chunks, and stores it in your workspace memory.

After that, when you ask @Hana questions, Hana can use those chunks as context for better, grounded answers.

Who can add it

You need memory management permission in Hana Dashboard.

Supported file types

You can add:

  • Google Docs
  • Google Sheets
  • Google Slides
  • PDF
  • Text files (.txt)
  • CSV
  • JSON

Add a Google Drive memory

  1. Open Dashboard -> Memory.

  2. Open the Google Drive Memory tab.

  3. Click Add Google Drive Memory.

  4. Pick the file from Google Drive.

google drive memory in Hana

  1. If needed, Hana asks for Google Drive permission.

google drive memory in Hana

  1. Add Use case instructions (optional).
  2. Confirm to start ingestion.

Hana shows ingestion progress in the memory list.

End-to-end flow (what happens after you click Add)

  1. You choose a supported Drive file in the picker.

google drive memory in Hana

google drive memory in Hana

  1. Add the Use case instructions.

google drive memory in Hana

google drive memory in Hana 3. Hana starts ingestion in the background .

google drive memory in Hana

  1. Hana reads content based on file type:
    • Docs/Slides: reads text content.
    • Sheets: reads row data from selected sheet/tab setup.
    • PDF/Text/CSV/JSON: reads file text content.
  2. Hana converts the content into memory chunks.
  3. The batch appears in the list with status updates.

google drive memory in Hana

  1. Once status is Ingested, you can use it reliably in chat prompts.

google drive memory in Hana

Ingestion statuses you will see

  • In Progress: Hana is currently reading and indexing the file.

google drive memory in Hana

google drive memory in Hana

  • Ingested: File is ready to use in chat.

google drive memory in Hana

  • Partially Ingested: Some content was indexed; some failed.
  • Error: Ingestion failed.
  • Aborted: Ingestion was manually stopped.

If your file is a Google Sheet

Before ingestion, Hana shows Sheet options:

  • Sheet title: Ingest one sheet tab or all tabs.

google drive memory in Hana

  • Rows to ingest:

    • All rows
    • Top rows
    • Bottom rows

    google drive memory in Hana

  • Total row limit (optional):

    • Default if blank: 1000
    • Maximum allowed: 5000

    google drive memory in Hana

  • Sorting options (advanced): Sort by column, type, and order before ingestion.

    google drive memory in Hana

If your sheet is large, use Top rows or Bottom rows with a smaller row limit for more stable results.

Manage existing Google Drive memories

From each row's Actions menu, you can: google drive memory in Hana

google drive memory in Hana

  • View Chunks: See indexed memory chunks.

google drive memory in Hana

  • View Sheet Data: See row-level sheet data for sheet memories.

  • Visit: Open the source file in Google Drive.

  • Sync: Pull latest changes from the source file now.

  • Enable/Disable Auto Resync: Keep memory updated automatically on a schedule. google drive memory in Hana

  • Edit Sheet Options: Change sheet-specific ingestion setup.

  • Edit Instructions: Update guidance for how Hana should use this memory. google drive memory in Hana

  • Edit Tags: Update tags for filtering and organization.

  • Retry Ingestion: Restart failed or aborted ingestion.

  • Abort: Stop a currently running ingestion.

    google drive memory in Hana

  • Revoke Access / Grant Access: Temporarily stop/restore source access for this memory.

  • Delete: Remove this memory batch.

Use it in chat with Hana

After ingestion is complete, ask Hana normally in your chat space.

@Hana summarize the Q2 planning doc from our Google Drive memory.
@Hana check the sales sheet memory and list the top 5 accounts by revenue.
@Hana compare our policy slide deck memory with last month's SOP doc.

Troubleshooting

  • "File type not supported": Pick one of the supported types listed above.

  • Google permission prompt appears: Grant Drive access and try again.

  • Sheet ingestion fails on large data: Switch to Top rows or Bottom rows and lower row limit.

  • Memory is old: Run Sync or enable Auto Resync.

  • Make sure to grant all required OAuth scopes when prompted, especially the drive.file scope. Missing this permission can prevent proper access to files.

    google drive memory in Hana

  • You can also verify whether the Google Drive (drive.file) permission is granted by visiting our dashboard

    google drive memory in Hana

Best practices

  • Add clear Use case instructions so Hana uses the file correctly.
  • Split very large sheets into smaller, focused memories.
  • Keep old or irrelevant memories deleted so results stay clean.
  • Use Auto Resync for files that change often.

See also