Run Ollama in Google Sheets скачать в хорошем качестве

Run Ollama in Google Sheets

This tutorial demonstrates how to connect a local Ollama LLM installation directly to Google Sheets using Cloudflare Tunnel. (Don't worry, it's not as complicated as it sounds). The video provides step-by-step instructions for both Mac and Windows machines, including installing Ollama, downloading open source AI models, configuring a Cloudflare Tunnel to securely expose your local Ollama instance, and setting up a simple Google Apps Script to integrate custom AI functions into your spreadsheet. The advantage of using this sort of setup is that it enables unrestricted, automated AI queries directly in Google Sheets, leveraging any locally-hosted open-source LLM such as DeepSeek-R1, Llama 4, Phi-4, and others. Unlike Google's native Gemini AI function, this approach doesn't impose context limits, supports automatic refreshes, and allows users to maintain full control over their AI model and data privacy. ****Beta Test Preview**** Want to run backtests directly in Google Sheets without any code? Check out the FREE Stock Backtester Google Sheets Add On: https://stockbacktester.com/ If you find this helpful : *Like (👍)* Comment *Subscribe* *Subscribe for FREE to the Deep Charts Newsletter* -- https://deepcharts.substack.com/ *Full Code* https://deepcharts.substack.com/p/run... *Resources* Install Homebrew: https://brew.sh/ Ollama Install: https://ollama.com/ Ollama Models: https://ollama.com/search Cloudflare Tunnels: https://try.cloudflare.com/ *Chapters* 0:00 Introduction and why a custom Ollama function in Sheets has advantages over the native Gemini AI function 0:47 Downloading Ollama and Installing an Open-Source Model (like DeepSeek-R1) 1:39 Creating a cloudflare tunnel URL for connecting your local Ollama instance to Google Sheets 3:18 Setting up the connection in Google Sheets with Apps Script code 4:17 Test out querying the Ollama model + additional tips and tricks