📌 Select a cell with ALGOSHEET data to inspect
(Works with formulas or pasted values)
Use Cases
💡 Simple Question
=ALGOSHEET("What is the capital of France?")🔢 Get a Number
=ALGOSHEET("Revenue of Microsoft 2023", "structured", "number")🌐 Web Search
=ALGOSHEET("Latest AI news", "free", "", "web=true")📊 M&A Analysis
=ALGOSHEET("P/E ratio of Tesla", "structured", "number", "web=true")💰 Company Valuation
=ALGOSHEET("Market cap of " & A1, "structured", "number", "web=true")Get real-time company valuation
📈 Financial Ratios
=ALGOSHEET("P/E ratio of " & A1, "structured", "number", "web=true")Extract key financial metrics
🎯 Sector Analysis
=ALGOSHEET("Industry sector of " & A1, "structured", "enum(Tech,Finance,Healthcare,Other)")Classify companies by sector
⚠️ Risk Assessment
=ALGOSHEET("List 3 risks of acquiring " & A1, "free", "", "web=true")Due diligence insights
🔍 Extract Answer
=ALGOSHEET_PARSE(B1, "value")Get clean value from JSON
🌐 Get Sources
=ALGOSHEET_PARSE(B1, "sources_urls")Extract source URLs
Reference
ALGOSHEET Function
=ALGOSHEET(prompt, [mode], [schema], [options])| Parameter | Required | Values |
|---|---|---|
prompt | ✅ Yes | Any text question |
mode | ❌ No | "free" (default), "structured" |
schema | ❌ No | "number", "boolean", "date", "enum(...)" or JSON schema |
options | ❌ No | JSON options e.g. {"web_search": true} |
🚀 Advanced Features
🌐 Force Web Search
Get real-time data from the web.
=ALGOSHEET("Latest stock price of MSFT", "free", "", "{""web_search"": true}")📋 Structured Data
Force the output to follow a specific format.
=ALGOSHEET("Extract info", "structured", "{""type"": ""object"", ""properties"": {""name"": {""type"": ""string""}}}")🧩 Multi-Field Extraction
Extract multiple fields at once.
=ALGOSHEET("Tesla info", "structured", "multi(revenue,ceo,sector)")🧠 Reasoning & Debugging
Open the Inspector tab to see the AI's reasoning and sources. Use the Debug tab to monitor API calls.
ALGOSHEET_PARSE Function
=ALGOSHEET_PARSE(jsonText, field)Extract specific fields from ALGOSHEET results
Available Fields
value- Main answerconfidence- Confidence (0-1)sources_urls- URLs (separated by ;)sources_titles- Titles (separated by ;)sources_snippets- Snippets (separated by |)raw- Full JSON
Options
web=true- Enable web search with sourceslang=French- Response in French (or any language)
📄 Full Documentation
See: data/AlgoSheet_User_Guide.md