Facebook Messenger AI Product Q&A with OpenAI + Google Sheets

Automatically answer product questions on Facebook Messenger using OpenAI + your Google Sheets inventory

This 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.

What this workflow does

• Triggers on new Messenger messages sent to your Facebook Page.
• Splits the webhook payload into individual messaging events and ignores non-text messages and Page echo messages. Any skipped events are logged to Google Sheets.
• Uses OpenAI to extract a normalized product name and the customer intent (for example: availability, price, or other request types).
• Loads your full inventory from Google Sheets, aggregates it into a single lookup list, and prepares it for matching.
• Uses OpenAI to match the requested product against your inventory, generates a confidence score, and drafts a ready-to-send reply.
• Sends the Facebook Messenger response via the Facebook Graph API: uses the AI reply when confidence is high, otherwise sends a predefined “not found” template.
• Appends conversation details and outcome to a Google Sheets conversation log.

Use cases

• A shopper asks on Messenger whether a specific product is available; your bot checks Google Sheets inventory and responds instantly.
• A customer requests pricing—OpenAI extracts the intent, matches the product, and replies based on your inventory data.
• An operator reviews skipped events and low-confidence “not found” cases in a Google Sheets log.

Technical details

• Facebook Messenger trigger with webhook event handling.
• Google Sheets integration for inventory lookup and conversation logging.
• OpenAI for product/intent extraction and inventory matching with confidence scoring.
• Facebook Graph API to send replies back to customers.
• Core n8n flow logic uses nodes such as if, set, merge, split out, and aggregate (plus sticky notes for clarity).