Process Customer Inquiries with OpenAI Assistant and Store Responses in Airtable
Workflow Description
This workflow receives customer inquiries via webhook from HubSpot, processes them using OpenAI's intelligent assistant, and automatically stores both the inquiry and response in Airtable for tracking and analysis. Enables efficient customer support automation with full audit trail.
How it works
- 1.Receive customer inquiry through webhook from HubSpot
- 2.Send inquiry to OpenAI Assistant for intelligent processing and response generation
- 3.Validate response and store inquiry-response pair in Airtable with metadata
Use cases
- Automate responses to frequently asked customer questions without manual intervention
- Create searchable records of all customer interactions for compliance and analysis
- Reduce response time for routine inquiries while maintaining human oversight capability
Requirements
- Active OpenAI account with valid API key configured
- Airtable base with table schema for storing inquiries, responses, and metadata
- HubSpot webhooks enabled to trigger workflow on incoming customer messages
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (34)
getHubspotMessage
HTTP Request
OpenAi Create Thread
HTTP Request
OpenAI Run
HTTP Request
Get Run
HTTP Request
Get Last Message
HTTP Request
HTTP Request
HTTP Request
Completed, Action or Inprogress
Switch
Wait
Wait
Wait1
Wait
Submit Data
HTTP Request
Select Function
Switch
Code1
Code
Wait2
Wait
HTTP Request1
HTTP Request
Code
Code
Submit Data1
HTTP Request
Wait3
Wait
respondHubspotMessage1
HTTP Request
IF
If
Airtable
Airtable
IF1
If
createThread
Airtable
OpenAI Run1
HTTP Request
IF2
If
Sticky Note1
Sticky Note
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
OpenAI
OpenAI
Webhook
Webhook