Posts

Showing posts from April, 2025

Build Memory-based AI Doctor using OpenAI Responses API in Google Sheets

Image
Medical Chatbot in Google Sheets: A Beginner's Guide Who is this guide for? This guide is for beginners who are new to Google Apps Script and might not have much experience with coding or APIs like OpenAI's. We'll go step-by-step. What does this script do? At its core, this script turns your Google Sheet into an interface for chatting with an AI assistant configured as a medical consultant. It can: Chat: Allow a user (patient) to converse with the AI in the AI Chat sheet. Remember: Save important information from the chat into a Patient History sheet using AI function calls. Learn: Update the AI's knowledge base (an OpenAI Vector Store) with information from the Patient History and Checkup History sheets. HERE'S THE FEATURE VIDEO OF THE AI DOCTOR TOOL Table of Contents 1. Getting Start...