Skip to content
FlowHubFluxonLab
RAG & Knowledge Basesfree

AI Chat Response Generation with Google Sheets Context and Pinecone RAG Memory

by Rahul JoshiUpdated Aug 2026
RequiresOpenAIGoogle DriveGoogle DriveGoogle SheetsGoogle SheetsGmailGmail
Share Post Share
MBShort-Term MemoryShort-Term Memo…AgAI Agent (Chat Composer)AI Agent (Chat …OPOutput Parser (JSON Enforcement)Output Parser (…OpenAI Chat ModelOpenAI Chat Mod…ChWhen chat message receivedWhen chat messa…GDGoogle Drive TriggerGoogle Drive Tr…Download fileDDDefault Data LoaderDefault Data Lo…TSRecursive Character Text SplitterRecursive Chara…Embeddings OpenAIEmbeddings Open…ScSchedule TriggerAgAggregateGet Previous Content from SheetGet Previous Co…Conversation LoggingConversation Lo…VSPinecone Vector Store InsertPinecone Vector…VSPinecone Vector Store Query for Knowledge BasePinecone Vector…Embeddings OpenAI Query for Chat modalEmbeddings Open…Get Data from Sheet.Get Data from S…CTConvert Data to fileConvert Data t…IfCheck File ExistSend Chat History with attachmentSend Chat Histo…SeFormat Data For AI AgentFormat Data For…123456789
1/5
FLOWS
STEPS · 9
Starts from a chat message

On a chat message, retrieves Pinecone and Google Sheets context to generate OpenAI replies, indexing Google Drive documents into vectors.

Tags

webhookcomplexOpenAIGoogle DriveSupport ChatbotAI RAGdiscoveredpending-review
Connects
OpenAIgoogledriveGoogle DrivesheetsGoogle SheetsgmailGmail
CategoryRAG & Knowledge Bases
Triggerwebhook
Complexitycomplex
Nodes22
AddedJun 27, 2026