{"product_id":"telegram-photo-product-inspection-workflow-n8n-google-sheets","title":"Telegram Photo Product Inspection Workflow (n8n) + Google Sheets","description":"\u003ch3\u003eInspect product photos in Telegram, score them against your standards with Google Gemini, and log results automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eTelegram Photo Product Inspection Workflow (n8n) + Google Sheets\u003c\/strong\u003e automatically receives inspection images from a Telegram bot, matches each item to its quality reference in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and uses \u003cstrong\u003eGoogle Gemini 2.5 Flash\u003c\/strong\u003e to produce a structured \u003cstrong\u003ePASS\/FAIL\u003c\/strong\u003e defect verdict—then routes alerts to \u003cstrong\u003eTelegram, Gmail, and Slack\u003c\/strong\u003e.\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 Runs when a Telegram bot receives a new message containing a downloaded image.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidation + extraction:\u003c\/strong\u003e Confirms a photo is attached, then extracts the \u003cstrong\u003eproduct code\u003c\/strong\u003e from the caption and reads image metadata from the Telegram message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStandards lookup:\u003c\/strong\u003e Searches Google Sheets for the product’s reference standard and tolerance notes using the product code.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini inspection + JSON parsing:\u003c\/strong\u003e Sends the image and reference standard to \u003cstrong\u003eGoogle Gemini 2.5 Flash\u003c\/strong\u003e, parses the response into normalized JSON (PASS\/FAIL, defect details, confidence, recommended action).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogging:\u003c\/strong\u003e Appends every inspection result to the Google Sheets \u003cstrong\u003eInspection_Log\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFail handling:\u003c\/strong\u003e If the verdict is FAIL, logs the item to \u003cstrong\u003eRejected_Items\u003c\/strong\u003e, sends a Telegram failure alert, and emails a detailed report to the supervisor via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePass handling:\u003c\/strong\u003e If PASS, sends a Telegram confirmation back to the originating chat.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVisibility for issues:\u003c\/strong\u003e Posts \u003cstrong\u003eSlack\u003c\/strong\u003e alerts for workflow-level errors and for Google Gemini analysis errors so failed inspections are immediately visible.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFactory or warehouse teams submitting inspection photos via Telegram for rapid quality checks.\u003c\/li\u003e\n  \u003cli\u003eOperators needing automated defect reports with confidence and recommended action.\u003c\/li\u003e\n  \u003cli\u003eSupervisors tracking rejected items in Google Sheets and receiving Gmail notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Telegram (photo intake), Google Sheets (standards + logs), Google Gemini 2.5 Flash (verdict generation), Gmail (supervisor email), Slack (error alerts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003etelegram\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, plus workflow notes via \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpreadsheet tabs:\u003c\/strong\u003e \u003cem\u003eInspection_Log\u003c\/em\u003e and \u003cem\u003eRejected_Items\u003c\/em\u003e (with product standards referenced by product code).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812007567539,"sku":"N8N-17972","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mAzhyR8y7Dkbmsc-QTHtu_1f0YGGPE.png?v=1786352768","url":"https:\/\/buyflowscripts.com\/products\/telegram-photo-product-inspection-workflow-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}