{"product_id":"facebook-messenger-ai-product-q-a-with-openai-google-sheets","title":"Facebook Messenger AI Product Q\u0026A with OpenAI + Google Sheets","description":"\u003ch3\u003eAutomatically answer product questions on Facebook Messenger using OpenAI + your Google Sheets inventory\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for new Facebook Messenger messages, identifies the customer’s requested product and intent with OpenAI, checks availability against your inventory in Google Sheets, and replies back through the Facebook Graph API—while logging outcomes and skipped events to a conversation sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers on new Messenger messages\u003c\/b\u003e sent to your Facebook Page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSplits the webhook payload\u003c\/b\u003e into individual messaging events and \u003cb\u003eignores non-text messages\u003c\/b\u003e and \u003cb\u003ePage echo messages\u003c\/b\u003e. Any skipped events are \u003cb\u003elogged to Google Sheets\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI to extract\u003c\/b\u003e a normalized product name and the customer intent (for example: \u003ci\u003eavailability\u003c\/i\u003e, \u003ci\u003eprice\u003c\/i\u003e, or other request types).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads your full inventory\u003c\/b\u003e from Google Sheets, aggregates it into a single lookup list, and prepares it for matching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI to match\u003c\/b\u003e the requested product against your inventory, generates a \u003cb\u003econfidence score\u003c\/b\u003e, and drafts a ready-to-send reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends the Facebook Messenger response\u003c\/b\u003e via the Facebook Graph API: uses the AI reply when confidence is high, otherwise sends a predefined “\u003cb\u003enot found\u003c\/b\u003e” template.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends conversation details and outcome\u003c\/b\u003e to a Google Sheets conversation log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA shopper asks on Messenger whether a specific product is available; your bot checks Google Sheets inventory and responds instantly.\u003c\/li\u003e\n  \u003cli\u003eA customer requests pricing—OpenAI extracts the intent, matches the product, and replies based on your inventory data.\u003c\/li\u003e\n  \u003cli\u003eAn operator reviews skipped events and low-confidence “not found” cases in a Google Sheets log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eFacebook Messenger trigger\u003c\/b\u003e with webhook event handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets integration\u003c\/b\u003e for inventory lookup and conversation logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e for product\/intent extraction and inventory matching with confidence scoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFacebook Graph API\u003c\/b\u003e to send replies back to customers.\u003c\/li\u003e\n  \u003cli\u003eCore n8n flow logic uses nodes such as \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e, and \u003cb\u003eaggregate\u003c\/b\u003e (plus \u003cb\u003esticky notes\u003c\/b\u003e for clarity).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785702564019,"sku":"N8N-17904","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NtIqIR2T0aUGojsqauguZ_kTApi57C.png?v=1786180337","url":"https:\/\/buyflowscripts.com\/products\/facebook-messenger-ai-product-q-a-with-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}