{"product_id":"n8n-telegram-yes-no-oracle-openai-google-sheets","title":"n8n Telegram Yes\/No Oracle: OpenAI + Google Sheets","description":"\u003ch3\u003en8n Telegram Yes\/No Oracle that answers in audio, with Google Sheets logging and a light flash\u003c\/h3\u003e\n\u003cp\u003eSend a message to your Telegram bot and this n8n workflow will generate an “oracle” yes\/no verdict—processing text directly or transcribing voice notes with OpenAI—then replies back in Telegram with an OpenAI TTS audio message, an HTML certificate, and a logged record in Google Sheets. It also triggers an HTTP request to flash a Tapo light.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram trigger:\u003c\/strong\u003e Starts when a new Telegram message is received by your bot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessage type handling:\u003c\/strong\u003e Detects whether the incoming message is text or a voice note and rejects unsupported message types.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVoice-to-text:\u003c\/strong\u003e If it’s a voice note, downloads the audio from Telegram and transcribes it with \u003cstrong\u003eOpenAI\u003c\/strong\u003e; otherwise uses the text as-is.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuestion validation + acknowledgement:\u003c\/strong\u003e Normalizes\/validates the question, sends an acknowledgement back to Telegram, then waits briefly before processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEntropy-based yes\/no logic:\u003c\/strong\u003e Calls two sub-workflows—one to analyze “spiritual weight” and another to gather multiple external entropy signals—then combines them into a final entropy score and decision index.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerdict formatting + parallel outputs:\u003c\/strong\u003e Uses a formatting sub-workflow to produce the final oracle verdict and a TTS script, then distributes outputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram responses:\u003c\/strong\u003e Generates \u003cstrong\u003eOpenAI TTS\u003c\/strong\u003e audio and sends it back, creates an \u003cstrong\u003eHTML certificate\u003c\/strong\u003e, and sends it as a Telegram document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance + logging:\u003c\/strong\u003e Appends a log row to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, runs an EU AI Act compliance logging sub-workflow, and triggers a \u003cstrong\u003eTapo\u003c\/strong\u003e light flash via an \u003cstrong\u003eHTTP request\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eInteractive Telegram-based “yes\/no” decision support using an entropy-derived index.\u003c\/li\u003e\n  \u003cli\u003eVoice-first oracle sessions where users can speak questions and receive spoken answers.\u003c\/li\u003e\n  \u003cli\u003eAuditable automation: store outcomes in Google Sheets and record EU AI Act compliance logs.\u003c\/li\u003e\n  \u003cli\u003eLight\/IoT feedback: coordinate a Tapo light flash with each oracle result.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore nodes:\u003c\/strong\u003e if, code, wait, Telegram, Sticky Note, HTTP Request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI transcription for voice notes and OpenAI TTS for audio replies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData logging:\u003c\/strong\u003e Google Sheets row append.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance:\u003c\/strong\u003e EU AI Act compliance-logging sub-workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIoT trigger:\u003c\/strong\u003e HTTP request to activate a Tapo light flash.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Create a Telegram bot with BotFather, add the Telegram API credential in n8n, and start a chat so the bot can receive messages.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123133305011,"sku":"N8N-20126","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PpYnvZZBrafRuRQ7_BdX3_TVL5rLE6.png?v=1790672773","url":"https:\/\/buyflowscripts.com\/products\/n8n-telegram-yes-no-oracle-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}