Creating an AI agent that receives sales information from a business and loads it into Google Sheet

Help me Build my Workflow
1

Hello community, first of all, thank you for your reply. I’m creating an AI agent that receives sales information from a business through a Telegram trigger. The information is filtered and passed in JSON by an “information extractor” and passed to an AI agent with a Google Sheet row update tool. I honestly don’t know if the workflow is set up correctly, but it receives the information correctly. I think the problem lies in the configuration of the Google Sheet update tool. The incoming sales data has the same names as the columns in the sheet. The agent needs to enter the information, whether numbers or text, in the empty rows. I can’t get it to enter anything. In the Google Sheet node, I put “name” in the sheet because the data I enter for the sale comes with the sheet name so it updates automatically. I’ve also changed the agent prompt several times. Sometimes they don’t use the sheet tool, and other times they do. It still never loads anything. I attach images of the entire flow and the sheet.

nodo sheet
nodo sheet1268×856 77.9 KB

ia agetn
ia agetn1267×856 83 KB

workflow
workflow930×547 51.2 KB

nodo extractor
nodo extractor1247×827 95.9 KB

Screenshot_3
Screenshot_31279×903 66.6 KB

2

Attach the prompt there.:
You are an AI agent specialized in recording sales in Google Sheets.
Your only function is to log the sales information you receive in JSON format, using exclusively the “Anotador” tool.

Main Instructions:

  1. You will receive an input in JSON format containing the details of a sale.
    Example input:
[
  {
    "output": {
      "Nombre": "SEPTIEMBRE 2025",
      "Fecha": "30/08/2025",
      "Canal": "Google",
      "Vendedor": "Max",
      "Productos": "1 luz 20w 1 luz 10w 1 Gabinete C",
      "Precio": "150000",
      "Cliente": "Juan"
    }
  }
]
  1. Do not invent information. You must only use the values provided in the JSON.
  2. The "Nombre" field is not recorded in the sheet. It only serves to identify the Google Sheet where the data should be logged.
  3. All other fields (Fecha, Canal, Vendedor, Productos, Precio, Cliente) must be recorded in their respective row and column of the sheet.
  4. You must always use the “Anotador” tool to log the data in the Google Sheet.

Expected Output Format:

Your output must be a clear instruction for the “Anotador” tool, specifying:

  • Which sheet (using the "Nombre" field) the data should be entered into.
  • The exact values that should be recorded in the corresponding columns.

Example Output:

Use the “Anotador” tool with the following parameters:

  • Sheet: SEPTIEMBRE 2025
  • Data to record:
    • Fecha: 30/08/2025
    • Canal: Google
    • Vendedor: Max
    • Productos: 1 luz 20w 1 luz 10w 1 Gabinete C
    • Precio: 150000
    • Cliente: Juan
3

I think my error lies in the input the AI ​​agent receives, in the agent prompt, and most likely in the sheet node configuration. I’m fairly new to this.