Process shoe availability inquiries via webhook with…

This automation template helps shoe retailers respond quickly and accurately to customer inquiries about product availability. Using AI and data from Google Sheets, it receives text queries via HTTP webhook, analyzes them, checks stock, and sends structured responses—fully automated, no manual intervention needed.

## Who it´s for
- Online shoe stores aiming to automate customer inquiry handling
- Sales managers seeking fast, consistent responses to product requests
- Owners of Telegram/Instagram-based stores using text messages for product search
- Support teams looking to improve response speed and quality with AI

## What the automation does
- Receives incoming customer inquiries via HTTP webhook
- Uses GPT-3.5 to extract key parameters: brand, model, size, color
- Checks product availability in Google Sheets based on criteria
- Suggests alternative options if exact match is unavailable
- Generates a natural, friendly response using GPT-4
- Returns the result via API back to the client’s system

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic with LangChain integration
- Integrations with OpenAI API and Google Sheets API
- Basic written instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Google Sheet with inventory data (brand, model, size, color, availability, price)
- OpenAI API key (for GPT-3.5 and GPT-4)
- Webhook endpoint to receive incoming queries (e.g., from Telegram bot or website)

## Benefits and outcomes
- Reduced workload for sales and support teams
- Faster responses in seconds
- Higher accuracy in query processing
- Scalability without hiring additional staff
- Improved customer experience with instant, polite replies
- Automatic suggestion of alternatives when items are out of stock

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.