Help whit agent ai to google sheet

Questions
1

Hello everyone,

I’m new to n8n and I’m trying to create a workflow where an AI Agent with GPT-4 can receive a message in a chat (via Telegram) containing expense information and then save it into a Google Sheets, ensuring that the data is stored in the correct cells (for example, date, description, and amount in separate columns).

The problem I’m facing is that all the information is currently being saved in a single cell as plain text instead of being split correctly into the respective columns. I don’t know how to process the AI model’s response so that each piece of data goes into the correct cell.

I’m new to n8n and workflow automation, so I’d also appreciate any tutorials or guides to better understand how to work with AI agents in n8n.

Has anyone solved a similar issue or can guide me through the process? Any advice or resources would be greatly appreciated!

Thanks in advance for your help!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hi @Matias_Romero

Welcome to the community! Can you share your current workflow so the community can help here? We are building a great AI series on youtube you should check out , Max is giving great tips on how to build these type of workflows:

https://www.youtube.com/playlist?list=PLlET0GsrLUL7LWMf4Q3gHNu5mk-hur7QV

Hope this helps!