Help Needed: How to Parse and Split Multi-Line Workout Input for Google Sheets via AI Chatbot (Telegram/WhatsApp to n8n)

Hi all,

I’m building an AI agent (using n8n, OpenAI, Google Sheets, etc.) that takes workout logs sent from Telegram or WhatsApp and automatically adds the data to Google Sheets.
Currently, if I enter each workout movement one-by-one (e.g., as separate messages), it works fine and each movement goes into the correct row and columns.

The problem:
If I paste my whole workout (with multiple exercises and details—reps, weight, etc.) into the chat as a single message, the bot doesn’t split the exercises.
Instead, it either tries to put all of them into a single row/cell, only logs one exercise, or sometimes doesn’t log anything at all.
So, the AI agent isn’t separating or parsing each movement from a multi-line input.

Example input I want to send:

400m run
60x db deadlift 32 kg

400m run
60 x Dumbell snatch 15 kg

400m run
60 x db goblet squats 16 kg

400m run
60 x Dumbell oh press 12.5KG

Date Movement Reps Weight
03/06/2025 Bench Press 60 60kg
Pull Ups 60 Bodyweight
Deadlift 60 100kg