Push JSON data into an app or to spreadsheet file
This workflow template shows how to load JSON data into a workflow and push that data into an App or convert it into a Spreadsheet file. Specifically, this workflow shows how to make a generic API request that returns JSON. It then shows how to load that into a Google Sheets spreadsheet, or convert it to .CSV file format. However, you can use the general pattern to load data into any app or convert to any spreadsheet file format (such as .xlsx).
By n8n TeamRecipe recommendations with Qdrant and Mistral
This n8n workflow demonstrates creating a recipe recommendation chatbot using the Qdrant vector store recommendation API. Use this example to build recommendation features in your AI Agents for your users. How it works For our recipes, we'll use HelloFresh's weekly course and recipes for data. We'll scrape the website for this data. Each recipe is split, vectorised and inserted into a Qdrant Collection using Mistral Embeddings Additionally the whole recipe is stored in a SQLite database for later retrieval. Our AI Agent is setup to recommend recipes from our Qdrant vector store. However, instead of the default similarity search, we'll use the Recommendation API instead. Qdrant's Recommendation API allows you to provide a negative prompt; in our case, the user can specify recipes or ingredients to avoid. The AI Agent is now able to suggest a recipe recommendation better suited for the user and increase customer satisfaction. Requirements Qdrant vector store instance to save the recipes Mistral.ai account for embeddings and LLM agent Customising the workflow This workflow can work for a variety of different audiences. Try different sets of data such as clothes, sports shoes, vehicles or even holidays.
By JimleukAuto-generate product comparison pages with OpenAI & Google Sheets
Auto-generate product comparison pages that help users buy faster This workflow creates detailed "X vs Y" product comparison pages designed to help readers make faster, more confident purchase decisions — all with zero manual writing. --- How it works Triggered manually or via Google Sheets row Takes two product names as input (e.g. “Notion vs Evernote”) Uses AI to generate: ✅ A compelling title and meta description 📝 Clear feature-by-feature comparison 🤝 Use-case-based recommendations 💬 FAQ section tailored to user pain points Saves each section into a Google Sheet for review or publishing Final output can be exported to your CMS or website builder (like Dorik, Webflow, etc.) --- Set up steps You’ll need OpenAI and Google Sheets credentials Takes 10–15 minutes to plug in your keys and connect the sheet Adjust prompts to match your brand tone or SEO goals 📝 You can easily expand this to generate pricing tables, testimonials, or even localized versions using the same structure. --- Ideal for SaaS companies, affiliate marketers, or content teams who want to scale up comparison content — without spending hours writing.
By Abrar SamiAnalyze customer feedback with Azure GPT-4, Jira tasks & Outlook reports from Monday.com
Description Automate customer feedback analysis and action planning by integrating Monday.com, Azure OpenAI, Jira, Google Sheets, and Outlook. This workflow classifies customer feedback with AI, calculates business impact, creates Jira tasks for high-priority issues, and sends weekly performance summaries — turning raw feedback into actionable insights. 💬📈🤖 What This Template Does Step 1: Triggers automatically every Monday at 9:00 AM to fetch new customer feedback from Monday.com. ⏰ Step 2: Normalizes and structures data into consistent fields (title, account, ARR, NPS, etc.). 🧩 Step 3: Uses Azure OpenAI GPT-4 to classify sentiment and identify feedback themes (e.g., “UI Design,” “App Crash”). 🧠 Step 4: Calculates a business impact score based on ARR, NPS delta, and sentiment weightings. ⚙️ Step 5: Creates Jira tasks for high-impact feedback items for product or engineering follow-up. 🎫 Step 6: Logs all feedback and impact scores into Google Sheets for analytics dashboards. 📊 Step 7: Generates a professional HTML report summarizing metrics, wins, and risks, then emails it via Outlook. 📧 Step 8: Sends automated error-alert emails if any node fails during execution. 🚨 Key Benefits ✅ Converts qualitative feedback into measurable business intelligence ✅ Identifies critical customer issues automatically using AI ✅ Reduces manual effort in triaging and prioritizing feedback ✅ Creates real-time visibility for product and CX teams ✅ Provides weekly executive summaries and performance insights Features Weekly scheduled trigger (every Monday 9 AM) Monday.com data fetching and field normalization Azure OpenAI GPT-4-based sentiment and theme detection Impact scoring combining ARR + NPS + sentiment weighting Jira issue creation with context-rich descriptions Google Sheets logging for dashboards and historical records Outlook HTML email reports for leadership visibility Automated Gmail error-notification system Requirements Monday.com API credentials with board access Azure OpenAI GPT-4 API credentials Jira Software Cloud API credentials Google Sheets OAuth2 credentials with edit permissions Microsoft Outlook OAuth2 credentials for email delivery Gmail OAuth2 credentials for error alerting Target Audience Product and CX teams analyzing customer sentiment SaaS businesses tracking post-implementation feedback Customer-success and support operations teams Product managers prioritizing improvements based on impact Leadership teams monitoring customer health and satisfaction Step-by-Step Setup Instructions 1️⃣ Connect Monday.com API and update your boardId and groupId. 2️⃣ Configure Azure OpenAI GPT-4 credentials for the AI classifier. 3️⃣ Set Jira project ID and issue type for ticket creation. 4️⃣ Link Google Sheets and replace YOURSHEETID. 5️⃣ Connect Outlook OAuth2 and add recipient email for reports. 6️⃣ Configure Gmail OAuth2 for error alerts. 7️⃣ Adjust the cron expression (0 9 1) to fit your timezone. 8️⃣ Test the workflow end-to-end with sample data. 9️⃣ Enable automation for seamless weekly feedback intelligence. ✅
By Rahul Joshi