Google Chat to Sheets Integration

I need a small workflow that watches a dedicated space in Google Chat and pushes every new message—full text, sender, timestamp, and thread link—straight into a Google Sheet the moment it is posted. Real-time speed is critical; hourly or daily syncs won’t work for this purpose... (Budget: ₹100 - ₹400 INR, Jobs: API Integration, Automation, Google Chrome, Google Sheets, JavaScript, PHP, Scripting, Software Architecture, Workflow Automation)