How can I collect chatbot conversations into a spreadsheet by session ID and automatically add extracted names and emails to our CRM?

You don’t need to parse the chat yourself. Add a line to your prompt asking the model to capture name and email when they appear and output them directly. Then, in the workflow, map the model’s JSON response to a Google Sheet: create a row with columns for the session ID, the raw message, and the extracted name/email. Use the ‘Add Row’ action, select your spreadsheet, and map the fields from the node output (message, response, session ID) to the appropriate columns. This eliminates manual parsing and lets you store each chat session in the sheet automatically.