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
- Text files (
.txt) - CSV
- JSON
Add a Google Drive memory
-
Open Dashboard -> Memory.
-
Open the Google Drive Memory tab.
-
Click Add Google Drive Memory.
-
Pick the file from Google Drive.
-acd6e9a78b553e152a086cedff137d74.png)
- If needed, Hana asks for Google Drive permission.
-e558ce6ab0f1a520c2a3407e26ce9b44.png)
- Add Use case instructions (optional).
- Confirm to start ingestion.
Hana shows ingestion progress in the memory list.
End-to-end flow (what happens after you click Add)
- You choose a supported Drive file in the picker.
-035b4c833f4b409a00ed4f98d2eccb63.png)
-8fa2fbd2d2d0063909bb1805da40c3cd.png)
- Add the Use case instructions.
-b6a45cf7a26d8292659ff3d9b8e2057c.png)
3. Hana starts ingestion in the background .
-a639b8095c7b37c7a41eeeff1209acdd.png)
- 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.
- Hana converts the content into memory chunks.
- The batch appears in the list with status updates.
-4f9d49b8dd31f8df8edf1fd7e1cbb6ad.png)
- Once status is Ingested, you can use it reliably in chat prompts.
-f2d1f729e81cdc67f5078edd5add7f83.png)
Ingestion statuses you will see
- In Progress: Hana is currently reading and indexing the file.
-4f9d49b8dd31f8df8edf1fd7e1cbb6ad.png)
-d1a3fc0fb209725915e41ae806220959.png)
- Ingested: File is ready to use in chat.
-f2d1f729e81cdc67f5078edd5add7f83.png)
- 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.
-ffa61408a3154c90bc9eda1204b1dd6f.png)
-
Rows to ingest:
- All rows
- Top rows
- Bottom rows
-a3db8a35b4739ab7045af9134458f6bd.png)
-
Total row limit (optional):
- Default if blank:
1000 - Maximum allowed:
5000
-086007f195d5bbc94eac60a179fac651.png)
- Default if blank:
-
Sorting options (advanced): Sort by column, type, and order before ingestion.
-8540c88993e8082dd2b06ebe26baacd8.png)
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:
-c25b61808aaf682151509504de6c088f.png)
-86b94b3008ac9d27553b381fabfc5475.png)
- View Chunks: See indexed memory chunks.
-322867b313915a032f9614b7212db8ad.png)
-
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.
-b12e5c3bc230cfb743ebfad98ee1da37.png)
-
Edit Sheet Options: Change sheet-specific ingestion setup.
-
Edit Instructions: Update guidance for how Hana should use this memory.
-9442b28e4480ddd7c85bd2e3d5d45bf5.png)
-
Edit Tags: Update tags for filtering and organization.
-
Retry Ingestion: Restart failed or aborted ingestion.
-
Abort: Stop a currently running ingestion.
-e98d49db4ac495e3e1c7e67b4078fc04.png)
-
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.
-02328dceb7d217dad149ee55851f429b.png)
-
You can also verify whether the Google Drive (drive.file) permission is granted by visiting our dashboard
-35f92599827507f1cc2a4701eb1a6c2b.png)
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.