Contextsheet is a free and privacy friendly Google Sheets™ extension connecting spreadsheets to LLMs (Gemini, Claude, ChatGPT) and Google Drive™ for contextual answers, without ever leaving your Google environment (besides the LLM endpoints).
How it Works (4 Simple Steps)
- 🔗 1. Insert URL to Drive folder / file for context.
- ❓ 2. Select cells and ask a question about them.
- ⏳ 3. Wait.
- 🥳 4. Check responses and insert into your sheet.
Future Roadmap
- 🖖 Save tokens by combining queries using same documents as context
- 🔍 OCR Scanning for scanned PDFs (Google vision)
- 🔗 Better sourcing of context in snippets
- 🐢 Slower answers as a workaround quota limits
Have suggestions for new features or found a bug? Email me at albert.steenstrup@contextsheet.com
Feature Explanations
Main Interface
This shows the primary Contextsheet sidebar view. Here, you can select your preferred AI model (like Gemini, Claude, or ChatGPT) from the dropdown, manage the API keys for each service via the tabs, and set the core context source using a Google Drive file or folder URL. Buttons for accessing Options and Advanced Settings are also visible.
Loading Response
While processing your queries, the sidebar shows a loading state. It indicates how many non-empty cells were found in your selection and displays placeholders while preparing context and fetching answers from the AI model for each query.
Example Response
Here's how Contextsheet displays results after processing queries. Each card corresponds to a cell query (e.g., "Age of Alice"). It shows the relevant text snippet extracted from the context document (if enabled in options), along with the final answer generated by the AI. You can select results to insert back into your sheet.
Options
The Options panel allows basic configuration. You can set the required Google Drive URL for context, toggle whether to include the context snippet in the result display, and choose whether to list the context documents used when inserting answers back into the sheet. Access to Advanced Settings is also provided.
Advanced Options
Dive deeper into customization with Advanced Settings. Control the preference for recent files when ranking search results. Adjust the Search Focus slider to prioritize document titles versus their full content. Modify the Context Strategy slider to favour finding answers in smaller text snippets versus reflecting upon whole documents. An upcoming PDF OCR feature is also hinted;)
Settings Panel
The main Settings panel is the hub for core configuration. Select the AI model (LLM) you want to use from the dropdown menu. Use the tabs (Gemini, Claude, ChatGPT) to securely enter and manage your API keys for each respective service. Direct links to obtain keys and manage settings are provided here as well.
About Contextsheet
Hi! I'm Albert, I created Contextsheet.
I built Contextsheet because manually copying data into spreadsheets from AI chat interfaces, especially when needing context from Drive documents, felt inefficient.
This add-on aims to bridge that gap to connect Sheets, Drive, and various LLM APIs (Gemini, Claude via Anthropic/Bedrock, and OpenAI). It incorporates features like document ranking and context management to provide more relevant answers directly within the spreadsheet environment, kinda like RAGs.
Privacy has been priority number one, with all user data kept in your own Google environment / LLM endpoints. No data is shared with third parties, nor is any data stored on my servers. Besides Google libraries, no other libraries are used outside the call for the LLM APIs chosen by the user.
Some thoughts on the project as well:
The extension is no way near perfect, as both quota limits(if your on
free tier like me) and document finding is a bit inconsintent (hence
why i created all of the options). I'm also working on a PDF OCR
feature, so that you can use scanned PDFs as context as well. All of
this is coded without any libraries other than Google Apps Script,
which enables a lot of privacy, but decreases the amount of
opportunities for performance improvements (would have loved to
incorporate stuff like Langchain or even just a vector DB).
Get Started
Install Contextsheet and start automating your information retrieval workflows.
Get startedNote: Contextsheet requires API keys for the respective AI services (Gemini, Claude, OpenAI). API usage costs are billed directly by the AI providers.
Connect
Feel free to connect with me:
-
LinkedIn:
Albert Steenstrup
-
Email:
albert.steenstrup@contextsheet.com
Disclaimer
Contextsheet interacts with third-party AI services. You are responsible for managing your own API keys and any associated costs incurred from using these services (Google Gemini, Anthropic Claude, OpenAI ChatGPT). Please review the terms and pricing of each service provider.