Google Sheets → OpenAI GPT-4o → QuickChart → Gmail
Perfect for support teams, product managers or anyone who wants a zero-code mood ring for their users’ feedback.
| 🔩 Node | 💡 Purpose |
|---|---|
| Manual Trigger | Lets you test the workflow on demand. |
| Select Google Sheet | Points to the spreadsheet that holds your reviews. |
| Loop Over Items | Feeds each row through the analysis routine. |
| Sentiment Analysis (LangChain) | Calls GPT-4o-mini and returns only the sentiment category. |
| Update Google Sheet | Writes the new Sentiment value into column C. |
| Read Data from Google Sheet | Pulls the full sheet again to create a summary. |
| Extract Number of Answers per Sentiment (Code node) | Tallies up how many reviews fall into each category. |
| Generate QuickChart | Creates a doughnut (or pie) chart as a PNG. |
| Send Gmail with Sentiment Chart | Fires the chart off to your inbox. |
| (Sticky Notes) | Friendly setup tips scattered around the canvas. |
| ✅ Step | Where |
|---|---|
| Connect Google Sheets → paste your Spreadsheet ID & choose the correct sheet. | All Google Sheets nodes |
| Add OpenAI credentials (sk-… key). | Sentiment Analysis node |
| Configure Gmail OAuth2 + recipient address. | Gmail node |
| Match your sheet columns → “Review title”, “Review text”, empty “Sentiment”. | Google Sheet itself |
| (Optional) Switch to gpt-4o for maximum accuracy. | Sentiment Analysis “Model” param |
Happy automating! 🎉
