Automated customer feedback triage with Gemini, Jotform, Google Sheets & Gmail replies

Who’s it for

Teams that collect product feedback with Jotform and want automated triage: instant alerts for urgent issues, knowledge-based replies to questions, and a clean backlog for suggestions.

How it works / What it does

New Jotform submissions are classified by Feedback Type (comments, questions, suggestions) and analyzed for sentiment. Angry or negative messages trigger a Telegram alert to your support channel. Questions are answered automatically using an agent that consults your internal Google Sheet “Q&A” database, then replies via Gmail with a styled HTML email. Suggestions are summarized, sent to a team chat, and appended to a Google Sheets backlog with name, email, summary, and date. All comments are logged to a structured sheet for reporting.

How to set up

- Connect your Jotform form and map fields (Name, E-mail, feedback text).

- Add credentials for Google Sheets, Gmail, Telegram, and LLM.

- Point the agent to your “Q&A” sheet/tab.