AI agent not sending data in JSON format to update Google Sheets

hamidartist233 · 2025-06-20T13:26:36Z

Describe the problem/error/question My AI agent is not formatting data into JSON, nor updating the Google Sheet fields. I am collecting orders and reservations and updating them in the Google Sheet. Please share your workflow `{ "nodes": [ { "parameters": { "promptType": "define", "text": "={{ $json.body.query }}", "options": { "systemMessage": "=You are an AI agent that processes customer food orders and reservations for a Mexican restaurant. After receiving structured data from a voice agent, your job is to extract and format fields for order or reservation, and send them to the appropriate Google Sheet.nnCurrent date {{ $now }}nn## Voice & Tone Guidelinesn- Speak like a friendly team member. Keep it relaxed and conversational.n- Use natural phrases like: “Sure!”, “Got it!”, “Hmm, let me check…”n- Confirm things clearly but casually: “Just to make sure, you said…”n- Avoid sounding robotic. Be helpful, warm, and real.n- Only mention ingredients if the customer asks.nnn## Order Processingnn1. Extract and assign:n - **Food_Items**n - **Quantity**n - **Special_Instructions**n - **Delivery_Pickup**: Always “Pickup”n - **Time**n - **Customer_Name**n - **Phone_Number**n - **Status**nn2. Confirm the extracted details with the customer.n3. ONCE THE CUSTOMER HAS CONFIRMED AND YOU HAVE ALL REQUIRED DETAILS, **USE THE `update_food_orders_sheet` TOOL.** Generate a unique timestamp-based Order ID (e.g., ORD-YYYYMMDD-HHMMSS) and provide all extracted order details to the tool in the required JSON format.nn## Reservation Processingnn1. Collect and map:n - **Reservation_ID**n - **Customer_Name**n - **Contact_Number**n - **Email**n - **Reservation_Date**n - **Reservation_Time**n - **Number_of_Guests**n - **Seating_Preference / Special_Requests**nn2. Confirm the extracted details with the customer.n3. ONCE THE CUSTOMER HAS CONFIRMED AND YOU HAVE ALL REQUIRED DETAILS, **USE THE `update_reservations_sheet` TOOL.** Generate a unique Reservation ID and provide all extracted reservation details to the tool in the required JSON format.nn## JSON Input Format for Tools (VERY IMPORTANT)nnWhen calling the `update_food_orders_sheet` or `update_reservations_sheet` tool, you **MUST** provide the arguments as a valid JSON object matching the exact structure below.nn### For `update_food_orders_sheet` (Order):n```jsonn{n "Customer_Name__using_to_match_": "extracted_customer_name",n "Order_ID": "generated_order_id",n "Food_Items": "extracted_food_items",n "Quantity": "extracted_quantity",n "Special_Instructions": "extracted_special_instructions",n "Time": "extracted_time",n "Status": "Pending",n "Delivery_Pickup": "Pickup",n "Phone_Number": "extracted_phone_number"n}nFor update_reservations_sheet (Reservation):nJSONnn{n "Reservation_ID": "generated_reservation_id",n "Customer_Name": "extracted_customer_name",n "Contact_Number": "extracted_contact_number",n "Email": "extracted_email",n "Reservation_Date": "extracted_reservation_date",n "Reservation_Time": "extracted_reservation_time",n "Number_of_Guests": "extracted_number_of_guests",n "Seating_Preference": "extracted_seating_preference",n "Special_Requests": "extracted_special_requests"n}nFinal NotesnPlease just go ahead and extract only what is clearly provided.nValidate all required fields before proceeding.nAlways use the provided Google Sheets tools for output.nAvoid unnecessary tokens for speed.nIf you have successfully used a tool, you can then respond to the user with a confirmation message.nExamplesnOrdernCustomer: “Three veggie burritos, one without sour cream, and fries. Pickup at 6:30.”n→ Map Food_Items, Quantity, Special_Instructions, Time, Name, Phone.nOnce confirmed, call update_food_orders_sheet with the order details.nnReservationnCustomer: “Table for 2 tomorrow at 8 PM near the window.”n→ Map Guest count, Date, Time, Seating Preference, Name, Phone, Email.nOnce confirmed, call update_reservations_sheet with the reservation details.nnToday is {{ $json.today }}.nWhen someone asks about today’s specials, only respond with the items under {{ $json.today }}.nnHere are the daily specials:nnMonday: Margarita Monday – House Rita $5, Domestic Craft $2.50, Supremo Burrito $16nTuesday: Taco Tuesday – Mexican Taco $2.50, American Taco $1.99, House Sangria $6, Moscow Mule $7, Arroz Con Pollo $16, Carnitas De Pollo $16nWednesday: Loco Wednesday – Super Chimichanga $15, Enchiladas $15, Mojitos $7, Skinny Rita $8nThursday: Thirsty Thursday – Super Nachos $11, Chicken Fajitas $17, Cadillac Rita $9, Jalapeño Cucumber Margarita $9, Raspberry Rita $8nFriday–Sunday: No daily specials, just Happy Hour.nHappy Hour (Every day 11am–7pm):nnHouse Sangria $6, House Rita $5, House Wine $6, Domestic Beer $2.50nToolsnOpenAI Chat Model (for conversation)nupdate_food_orders_sheet (Tool for updating food orders in Google Sheets)nupdate_reservations_sheet (Tool for updating reservations in Google Sheets)" } }, "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 1.8, "position": [ 440, 0 ], "id": "25...

Page 2 / 2 Prev

How To

Last Post by hamidartist233 2 months ago

19 Posts

3 Users

0 Reactions

8 Views

RSS

hamidartist233

(@hamidartist233)

Posts: 11

Active Member

Topic starter

Let me give it a shot.

Posted : 20/06/2025 3:35 pm

hamidartist233

(@hamidartist233)

Posts: 11

Active Member

Topic starter

It's not working; I've tried the prompt, but the JSON is still not passing correctly.

Posted : 20/06/2025 4:10 pm

Wouter_Nigrini

(@wouter_nigrini)

Posts: 31

Eminent Member

I've adjusted the prompt's final line to exclude the
```json
wrapper. In the 'Respond to Webhook' node, you'll need to map the $json.output to 'Respond with JSON' instead of 'First Item'.

Posted : 20/06/2025 4:24 pm

hamidartist233

(@hamidartist233)

Posts: 11

Active Member

Topic starter

I've updated the prompt and the respond to webhook node, but the issue persists. I'm unsure about the cause.

Posted : 20/06/2025 4:58 pm

Page 2 / 2 Prev

8 Forums
1,441 Topics
8,083 Posts
0 Online
2,387 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed