Here is the JSON structure for the data and the Make.com Logic to build the Autonomous FAQ Agent.
1. The Knowledge Base Structure (Google Sheets)
Tell your viewers to set up their Google Sheet with these exact headers. This ensures the AI has a clean “brain” to pull from.
| Header A: Category | Header B: Question | Header C: Answer / Procedure |
| Shipping | How long is delivery? | 3-5 business days via UPS. |
| Pricing | Do you offer discounts? | Yes, 10% off for first-time buyers with code AIHUB10. |
| Tech Support | Bot isn’t responding. | Check your API key in the settings tab. |
2. The Make.com Blueprint Logic (JSON Mapping)
When you are setting up the OpenAI Module, you need to “Map” the data from Google Sheets into the prompt. Here is how that JSON structure looks inside the module:
The Message Content (User Role):
JSON
{
"customer_query": "{{1.text_from_customer}}",
"business_knowledge": "{{2.aggregated_rows_from_google_sheets}}",
"instruction": "Answer the customer_query using ONLY the business_knowledge provided. If the answer is missing, say: 'I'll escalate this to a human specialist immediately.'"
}
3. The “Secret” Module: Array Aggregator
This is the pro-tip for your video: Most beginners try to send one row at a time. Tell your viewers: “Use the Array Aggregator after the Google Sheets ‘Search Rows’ module. This bundles your entire FAQ list into one package so the AI can scan everything at once for the right answer.”
4. High-Energy Script “Add-on”
Add this specific line around the 30-second mark of your script:
“The magic happens here in the Array Aggregator. We’re taking your entire business history and turning it into a searchable brain for the AI. It’s not just guessing; it’s looking up the facts in real-time.”
5. Final Description “Technical Blueprint” (Add to YouTube)
Add this to the bottom of your YouTube description to help with SEO and provide value:
⚙️ THE BLUEPRINT SETUP:
- Trigger: Webhook or Email (Customer reaches out).
- Search: Google Sheets (Search Rows for the FAQ sheet).
- Aggregate: Array Aggregator (Bundle all answers together).
- Brain: OpenAI GPT-4o (Feed the bundle + the question).
- Action: Send Response (Gmail, Slack, or WhatsApp).
