Workflow Templates

This is a production-ready, end-to-end workflow that automatically compares hotel prices across multiple booking platforms and delivers beautiful email reports to users. Unlike basic building blocks, this workflow is a complete solution ready to deploy. ✨ What Makes This Production-Ready ✅ Complete End-to-End Automation Input**: Natural language queries via webhook Processing**: Multi-platform scraping & comparison Output**: Professional email reports + analytics Feedback**: Real-time webhook responses ✅ Advanced Features 🧠 Natural Language Processing for flexible queries 🔄 Parallel scraping from multiple platforms 📊 Analytics tracking with Google Sheets integration 💌 Beautiful HTML email reports 🛡️ Error handling and graceful degradation 📱 Webhook responses for real-time feedback ✅ Business Value For Travel Agencies**: Instant price comparison service for clients For Hotels**: Competitive pricing intelligence For Travelers**: Save time and money with automated research 🚀 Setup Instructions Step 1: Import Workflow Copy the workflow JSON from the artifact In n8n, go to Workflows → Import from File/URL Paste the JSON and click Import Step 2: Configure Credentials A. SMTP Email (Required) Settings → Credentials → Add Credential → SMTP Host: smtp.gmail.com (for Gmail) Port: 587 User: your-email@gmail.com Password: your-app-password (not regular password!) Gmail Setup: Enable 2FA on your Google Account Generate App Password: https://myaccount.google.com/apppasswords Use the generated password in n8n B. Google Sheets (Optional - for analytics) Settings → Credentials → Add Credential → Google Sheets OAuth2 Follow the OAuth flow to connect your Google account Sheet Setup: Create a new Google Sheet Name the first sheet "Analytics" Add headers: timestamp, query, hotel, city, checkIn, checkOut, bestPrice, platform, totalResults, userEmail Copy the Sheet ID from URL and paste in the "Save to Google Sheets" node Step 3: Set Up Scraping Service You need to create a scraping API that the workflow calls. Here are your options: Option A: Use Your Existing Python Script Create a simple Flask API wrapper: api_wrapper.py from flask import Flask, request, jsonify import subprocess import json app = Flask(name) @app.route('/scrape/<platform>', methods=['POST']) def scrape(platform): data = request.json query = f"{data['checkIn']} to {data['checkOut']}, {data['hotel']}, {data['city']}" try: result = subprocess.run( ['python3', 'price_scrap_2.py', query, platform], capture_output=True, text=True, timeout=30 ) Parse your script output output = result.stdout Assuming your script returns price data return jsonify({ 'price': extracted_price, 'currency': 'USD', 'roomType': 'Standard Room', 'url': booking_url, 'availability': True }) except Exception as e: return jsonify({'error': str(e)}), 500 if name == 'main': app.run(host='0.0.0.0', port=5000) Deploy: pip install flask python api_wrapper.py Update n8n HTTP Request nodes: URL: http://your-server-ip:5000/scrape/booking URL: http://your-server-ip:5000/scrape/agoda URL: http://your-server-ip:5000/scrape/expedia Option B: Use Third-Party Scraping Services Recommended Services: ScraperAPI** (scraperapi.com) - $49/month for 100k requests Bright Data** (brightdata.com) - Pay as you go Apify** (apify.com) - Has pre-built hotel scrapers Example with ScraperAPI: // In HTTP Request node URL: http://api.scraperapi.com Query Parameters: api_key: YOUR_API_KEY url: https://booking.com/search?hotel={{$json.hotelName}}... Option C: Use n8n SSH Node (Like Your Original) Keep your SSH approach but improve it: Replace HTTP Request nodes with SSH nodes Point to your server with the Python script Ensure error handling and timeouts // SSH Node Configuration Host: your-server-ip Command: python3 /path/to/price_scrap_2.py "{{$json.hotelName}}" "{{$json.city}}" "{{$json.checkInISO}}" "{{$json.checkOutISO}}" "booking" Step 4: Activate Webhook Click on "Webhook - Receive Request" node Click "Listen for Test Event" Copy the webhook URL (e.g., https://your-n8n.com/webhook/hotel-price-check) Test with this curl command: curl -X POST https://your-n8n.com/webhook/hotel-price-check \ -H "Content-Type: application/json" \ -d '{ "message": "I want to check Marriott Hotel in Singapore from 15th March to 18th March", "email": "user@example.com", "name": "John Doe" }' Step 5: Activate Workflow Toggle the workflow to Active The webhook is now live and ready to receive requests 📝 Usage Examples Example 1: Basic Query { "message": "Hilton Hotel in Dubai from 20th December to 23rd December", "email": "traveler@email.com", "name": "Sarah" } Example 2: Flexible Format { "message": "I need prices for Taj Hotel, Mumbai. Check-in: 5th January, Check-out: 8th January", "email": "customer@email.com" } Example 3: Short Format { "message": "Hyatt Singapore March 10 to March 13", "email": "user@email.com" } 🎨 Customization Options 1. Add More Booking Platforms Steps: Duplicate an existing "Scrape" node Update the platform parameter Connect it to "Aggregate & Compare" Update the aggregation logic to include the new platform 2. Change Email Template Edit the "Format Email Report" node's JavaScript: Modify HTML structure Change colors (currently purple gradient) Add your company logo Include terms and conditions 3. Add SMS Notifications Using Twilio: Add new node: Twilio → Send SMS Connect after "Aggregate & Compare" Format: "Best deal: ${hotel} at ${platform} for ${price}" 4. Add Slack Integration Add Slack node after "Aggregate & Compare" Send to #travel-deals channel Include quick booking links 5. Implement Caching Add Redis or n8n's built-in cache: // Before scraping, check cache const cacheKey = ${hotelName}-${city}-${checkIn}-${checkOut}; const cached = await $cache.get(cacheKey); if (cached && Date.now() - cached.timestamp < 3600000) { return cached.data; // Use 1-hour cache } 📊 Analytics & Monitoring Google Sheets Dashboard The workflow automatically logs to Google Sheets. Create a dashboard with: Metrics to track: Total searches per day/week Most searched hotels Most searched cities Average price ranges Platform with best prices (frequency) User engagement (repeat users) Example Sheet Formulas: // Total searches today =COUNTIF(A:A, TODAY()) // Most popular hotel =INDEX(C:C, MODE(MATCH(C:C, C:C, 0))) // Average best price =AVERAGE(G:G) Set Up Alerts Add a node after "Aggregate & Compare": // Alert if prices are unusually high if (bestDeal.price > avgPrice * 1.5) { // Send alert to admin return [{ json: { alert: true, message: High prices detected for ${hotelName} } }]; } 🛡️ Error Handling The workflow includes comprehensive error handling: 1. Missing Information If user doesn't provide hotel/city/dates → Responds with helpful prompt 2. Scraping Failures If all platforms fail → Sends "No results" email with suggestions 3. Partial Results If some platforms work → Shows available results + notes errors 4. Email Delivery Issues Uses continueOnFail: true to prevent workflow crashes 🔒 Security Best Practices 1. Rate Limiting Add rate limiting to prevent abuse: // In Parse & Validate node const userEmail = $json.email; const recentSearches = await $cache.get(searches:${userEmail}); if (recentSearches && recentSearches.length > 10) { return [{ json: { status: 'rate_limited', response: 'Too many requests. Please try again in 1 hour.' } }]; } 2. Input Validation Already implemented - validates hotel names, cities, dates 3. Email Verification Add email verification before first use: // Send verification code const code = Math.random().toString(36).substring(7); await $sendEmail({ to: userEmail, subject: 'Verify your email', body: Your code: ${code} }); 4. API Key Protection Never expose scraping API keys in responses or logs 🚀 Deployment Options Option 1: n8n Cloud (Easiest) Sign up at n8n.cloud Import workflow Configure credentials Activate Pros: No maintenance, automatic updates Cons: Monthly cost Option 2: Self-Hosted (Most Control) Using Docker docker run -it --rm \ --name n8n \ -p 5678:5678 \ -v ~/.n8n:/home/node/.n8n \ n8nio/n8n Using npm npm install -g n8n n8n start Pros: Free, full control Cons: You manage updates Option 3: Cloud Platforms Railway.app (recommended for beginners) DigitalOcean App Platform AWS ECS Google Cloud Run 📈 Scaling Recommendations For < 100 searches/day Current setup is perfect Use n8n Cloud Starter or small VPS For 100-1000 searches/day Add Redis caching (1-hour cache) Use queue system for scraping Upgrade to n8n Cloud Pro For 1000+ searches/day Implement job queue (Bull/Redis) Use dedicated scraping service Load balance multiple n8n instances Consider microservices architecture 🐛 Troubleshooting Issue: Webhook not responding Solution: Check workflow is Active Verify webhook URL is correct Check n8n logs: Settings → Log Streaming Issue: No prices returned Solution: Test scraping endpoints individually Check if hotel name matches exactly Verify dates are in future Try different date ranges Issue: Emails not sending Solution: Verify SMTP credentials Check "less secure apps" setting (Gmail) Use App Password instead of regular password Check spam folder Issue: Slow response times Solution: Enable parallel scraping (already configured) Add timeout limits (30 seconds recommended) Implement caching Use faster scraping service

This enterprise-grade n8n workflow automates the entire event planning lifecycle — from client briefs to final reports — using Claude AI, real-time financial data, and smart integrations. It converts raw client data into optimized, insight-driven event plans with cost savings, risk management, and automatic reporting, all with zero manual work. Key Features Multi-source data fusion** from Google Sheets (ClientBriefs, BudgetEstimates, ActualCosts, VendorDatabase) AI-powered orchestration* using *Claude 3.5 Sonnet** for event plan optimization Automatic ROI and variance analysis** with cost-saving insights Vendor intelligence** — ranks suppliers by cost, rating, and reliability Risk engine** computes event risk (probability × impact) Auto-approval logic** for safe, high-ROI events Multi-channel delivery:** Slack + Email + Google Sheets Audit-ready:** Full JSON plan + execution logs Scalable triggers:** Webhook or daily schedule Workflow Process | Step | Node | Description | | ---- | --------------------------- | -------------------------------------------------------- | | 1 | Orchestrate Trigger | Runs daily at 7 AM or via webhook (/event-orchestrate) | | 2 | Read Client Brief | Loads event metadata from the ClientBriefs sheet | | 3 | Read Budget Estimates | Fetches estimated budgets and vendor data | | 4 | Read Actual Costs | Loads live cost data for comparison | | 5 | Read Vendor Database | Pulls vendor pricing, reliability, and rating | | 6 | Fuse All Data | Merges data into a unified dataset | | 7 | Data Fusion Engine | Calculates totals, variances, and validates inputs | | 8 | AI Orchestration Engine | Sends structured prompt to Claude AI for analysis | | 9 | Parse & Finalize | Extracts JSON, computes ROI, risks, and savings | | 10 | Save Orchestrated Plan | Updates OrchestratedPlans sheet with results | | 11 | Team Sync | Sends status & summary to Slack | | 12 | Executive Report | Emails final interactive plan to event planner | Setup Instructions 1. Import Workflow Open n8n → Workflows → Import from Clipboard Paste the JSON workflow 2. Configure Credentials | Integration | Details | | ----------------- | -------------------------------------------------- | | Google Sheets | Service account with spreadsheet access | | Claude AI | Anthropic API key for claude-3-5-sonnet-20241022 | | Slack | Webhook or OAuth app | | Email | SMTP or Gmail OAuth credentials | 3. Update Spreadsheet IDs Ensure your Google Sheets include: ClientBriefs BudgetEstimates ActualCosts VendorDatabase OrchestratedPlans 4. Set Triggers Webhook:** /webhook/event-orchestrate Schedule:** Daily at 7:00 AM 5. Run a Test Use manual execution to confirm: Sheet updates Slack notifications Email delivery Google Sheets Structure ClientBriefs | eventId | clientName | eventType | attendees | budget | eventDate | plannerEmail | spreadsheetId | teamChannel | priority | |----------|-------------|------------|-----------|----------|------------|---------------|---------------|-------------| | EVT-2025-001 | Acme Corp | Conference | 200 | 75000 | 2025-06-15 | sarah@acme.com | 1A... | #event-orchestration | High | BudgetEstimates | category | item | budgetAmount | estimatedCost | vendor | | -------- | -------------- | ------------ | ------------- | ----------- | | Venue | Grand Ballroom | 20000 | 22500 | Luxe Events | ActualCosts | category | actualCost | | -------- | ---------- | | Venue | 23000 | VendorDatabase | vendorName | category | avgCost | rating | reliability | | ----------- | -------- | ------- | ------ | ----------- | | Luxe Events | Venue | 21000 | 4.8 | High | OrchestratedPlans Automatically filled with: eventId, savings, roi, riskLevel, status, summary, fullPlan (JSON) System Requirements | Requirement | Version/Access | | --------------------- | ---------------------------------------------- | | n8n | v1.50+ (LangChain supported) | | Claude AI API | claude-3-5-sonnet-20241022 | | Google Sheets API | https://www.googleapis.com/auth/spreadsheets | | Slack Webhook | Required for notifications | | Email Service | SMTP, Gmail, or SendGrid | Optional Enhancements Add PDF export for management reports Connect Google Calendar for event scheduling Integrate CRM (HubSpot / Salesforce) for client updates Add interactive Slack buttons for approvals Export results to Notion or Airtable Enable multi-event batch orchestration Add forecasting from past data trends Result: A single automated system that plans, analyzes, and reports events — with full AI intelligence and zero manual work. Explore More AI Workflows: https://www.oneclickitsolution.com/contact-us/

How It Works This workflow automates cost analysis and budget optimization for enterprises managing complex operational expenses. Designed for CFOs, finance teams, and operations managers, it addresses the challenge of identifying cost inefficiencies and generating actionable recommendations in real-time. The system runs every 15 minutes, monitoring cost metrics and generating AI performance data. The Cost Intelligence Agent aggregates financial data before routing to parallel AI processing. Claude AI executes budget optimization analysis while a specialized cost model identifies spending patterns. Routing engines evaluate optimization strategies, with NVIDIA parsers ensuring standardized outputs. The Optimization Coordinator consolidates insights and routes by severity: critical overruns trigger executive alerts via email and Slack, warnings generate management notifications, while routine optimizations proceed to documentation and historical storage for trend analysis. Setup Steps Configure Schedule Trigger for 15-minute intervals Add Claude API credentials in Workflow Configuration and Budget Alert Tool nodes Set up NVIDIA API keys in Cost Intelligence Agent and Structured Output Parser nodes Connect Gmail authentication and configure finance team distribution lists Integrate Slack workspace credentials and specify budget alert channels Configure storage endpoints in cost history nodes with database connections Prerequisites Claude API access, NVIDIA API credentials, Gmail/Google Workspace account, Slack workspace integration Use Cases Multi-department budget variance analysis, cloud cost optimization, procurement pattern detection Customization Integrate ERP systems, add department-specific rules, customize alert thresholds by category Benefits Reduces overruns 40% through early detection, identifies 15-20% monthly savings

Customer Testimonial Collector Workflow Transform scattered testimonials into organized marketing assets - achieving 500 percent increase in testimonial collection, instant multi-channel optimization, and turning happy customers into brand advocates with automated rewards and recognition. What This Workflow Does Revolutionizes testimonial management with AI-powered analysis and multi-channel optimization: Centralized Collection via Jotform with structured fields for consistency AI Tone Detection using GPT-4 to analyze sentiment, authenticity, and emotional impact with 0-100 scoring Smart Quote Extraction that automatically identifies best soundbites for different marketing channels Organized Library using Google Sheets database with searchable tags, ratings, and usage permissions Automated Thank-You emails with exclusive coupon codes (20 percent for 5-star reviews) Social Media Optimization where AI creates Twitter, LinkedIn, and website versions automatically Marketing Team Alerts with real-time notifications including priority levels and usage recommendations Smart Rewards using dynamic discount codes based on rating quality Use Case Matching where AI identifies which marketing channels and audiences fit each testimonial Marketing-Ready Assets including headlines, callout words, and visual suggestions Key Features AI Testimonial Analyst: GPT-4 evaluates testimonials across 20 plus dimensions including tone, authenticity, emotional impact, and competitive advantages revealed Multi-Channel Optimization: Automatically generates Twitter-ready (280 characters), LinkedIn professional (150 words), and website polished (50-75 words) versions Tone and Sentiment Detection: Classifies testimonials as Enthusiastic, Professional, Grateful, Impressed, Transformative, or Skeptical-to-Believer with 0-100 sentiment scores Best Quote Extraction: AI identifies the single most impactful sentence plus 2-3 alternate quotes for different contexts Authenticity Scoring: Filters generic testimonials by rating authenticity as very-authentic, authentic, or generic Key Benefits Identification: Automatically extracts specific benefits mentioned such as time savings, cost reduction, and quality improvement Pain Points Mapping: Identifies what problems the customer solved by using your product or service Specific Results Tracking: Captures measurable outcomes like revenue increase, efficiency gains, and customer satisfaction improvements Marketing Priority Levels: AI assigns high, medium, or low priority to help marketing teams focus on most impactful testimonials Target Audience Matching: Identifies which customer segments would most relate to each testimonial Buyer Journey Staging: Tags testimonials by awareness, consideration, or decision stage for funnel optimization Competitive Differentiation: Identifies what each testimonial reveals about your competitive advantages Visual Design Suggestions: AI recommends graphic styles and callout words for testimonial graphics Permission Tracking: Automatically logs customer consent for public use across different channels Smart Coupon Generation: Creates unique codes with expiration dates and rating-based discount tiers Referral Incentives: Thank-you emails include referral program details to drive word-of-mouth Perfect For SaaS Companies needing social proof for landing pages and product pages E-commerce Stores showcasing customer satisfaction and product quality B2B Service Providers including consulting, agencies, and professional services building credibility Course Creators and online educators leveraging student success stories Healthcare Practices with patient testimonials (HIPAA-compliant with proper permissions) Real Estate Agents collecting client feedback for marketing materials Restaurants and Hospitality businesses gathering guest reviews and experiences Fitness and Wellness brands showcasing transformation stories What You Will Need Required Integrations Jotform - Testimonial submission form (free tier works) OpenAI API - GPT-4 for AI testimonial analysis (approximately 20-40 cents per testimonial) Gmail - Automated thank-you emails and marketing team notifications Google Sheets - Testimonial library and searchable database Optional Integrations Social Media APIs to auto-post testimonials to Twitter, LinkedIn, Facebook CRM Integration to link testimonials to customer profiles in HubSpot or Salesforce WordPress or Website integration to auto-publish approved testimonials to website testimonial pages Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 recommended for best analysis) Create Jotform Testimonial Form with fields for Customer Name, Email, Company, Job Title, Product Used, Testimonial Text, Rating, Permission to Share, Photo Upload, and Use Case Configure Gmail - Add Gmail OAuth2 credentials (same for both Gmail nodes) Setup Google Sheets - Create spreadsheet with Testimonial Library sheet and replace sheet ID in workflow Customize Coupon Logic if needed by editing the Generate Coupon Code node Brand Email Templates by updating company name, logo URLs, and colors Set Marketing Team Email address in notification node Test Workflow by submitting test testimonial through Jotform Launch Campaign by sharing form link in post-purchase emails Customization Options Multi-Language Support by translating forms and AI prompts for international customers Video Testimonials by adding video upload field and storing URLs in sheets Anonymous Options to allow customers to submit testimonials without public attribution Approval Workflow by adding manager approval step before testimonials go live A/B Testing to tag testimonials for split testing different versions on landing pages Industry-Specific Fields customized for your vertical such as results achieved, ROI, time saved Automated Publishing to connect to WordPress or CMS to auto-publish approved testimonials Social Media Auto-Posting to schedule tweets and LinkedIn posts with testimonial content Reward Tiers to create VIP rewards for customers who refer others after submitting testimonials NPS Integration to combine with Net Promoter Score surveys Review Platform Sync to auto-request reviews on Google, Yelp, Trustpilot, G2, Capterra Case Study Pipeline to flag high-impact testimonials for full case study development Customer Success Alerts to notify CSMs when their customers submit testimonials Testimonial Rotation to auto-rotate testimonials on website based on visitor industry Sentiment Trending to track sentiment scores over time Expected Results 500 percent increase in testimonial submissions due to easy form and rewards 90 percent reduction in manual testimonial management through automated categorization 10 hours per month saved as marketing team instantly finds perfect testimonials 40 percent improvement in conversion rates from authentic testimonials on landing pages 85 percent customer satisfaction with reward process driving loyalty 60 percent of testimonials rated high priority by AI filtering 100 percent organized testimonial library ensuring no great testimonial is lost 3x increase in referrals from thank-you emails with incentives 75 percent reduction in testimonial editing time as AI creates ready-to-use content 50 percent more social media engagement from optimized testimonial posts Use Cases SaaS Company Example A marketing manager with 150 customers needs social proof for new landing page launching next week. Scattered testimonials exist in emails, support tickets, and social media messages with no time to organize them. Solution: Sends form link to 50 happiest customers and receives 35 testimonials within 48 hours. AI analyzes all submissions and extracts best quotes. Manager filters by high priority and landing page use case to find 8 perfect testimonials with website versions already optimized. Result: Landing page launches on time with authentic testimonials. Conversion rate increases 42 percent. Customer uses discount code to upgrade plan. Refers 2 colleagues who become customers. Total impact exceeds 1400 dollars in incremental revenue. E-commerce Fashion Brand Example Post-purchase emails have generic review links. Most customers ignore them. Social proof on product pages is weak with only 2-3 old reviews while competitors have hundreds of testimonials. Solution: Adds form link to order confirmation emails 7 days post-delivery with incentive messaging. 500 customers submit testimonials in first month (10 percent response rate). AI identifies best testimonials for each product category. Result: Product pages updated with enthusiastic testimonials. Add-to-cart rate increases 65 percent. Customer uses discount code for repeat purchase. Posts social media content that brand reposts to followers. One testimonial workflow generates over 3500 dollars in attributed revenue. B2B Consulting Firm Example Proposals need client testimonials but they are trapped in old email threads. Asking clients feels awkward and time-consuming with no systematic collection process. Solution: Sends form link at project completion milestones via personal email from account manager. 22 of 30 clients submit testimonials (73 percent response rate). AI extracts ROI stories and specific results. Result: Testimonial added to proposal template addressing exact objection about being better than current firm. Close rate on proposals increases 30 percent. Client refers colleague who becomes high-value client. Full case study developed generates inbound leads. One testimonial workflow generates over 80000 dollars in new business. Online Course Creator Example Students post success stories in Facebook group and via email with no organized collection system. Website has only 3 old testimonials from 2 years ago. Low enrollment due to lack of social proof. Solution: Adds form link to course completion emails and shares in Facebook group with incentive. 180 students submit testimonials in first month (9 percent of students). AI identifies transformation stories and specific skills gained. Result: Testimonial added to course landing page as featured transformation story. Enrollment rate increases 55 percent as specific details address will-this-work objection. Student enrolls in advanced course using discount code. Testimonial shared in ads generates high ROAS. Workflow drives over 15000 dollars in additional course revenue. Healthcare Practice Example Patients verbally express gratitude but practice has only 15 online reviews. Need more social proof for website to attract new patients. Asking patients in-person feels pushy. Solution: Sends form link in post-appointment follow-up emails with clear HIPAA disclosure. Permission checkboxes for sharing testimonial publicly and using name and photo. 75 patients submit testimonials in first month. AI identifies compassionate care themes and specific improvements. Result: Testimonial added to service page. Inquiry rate increases 40 percent as testimonial addresses surgery fear objection. Patient agrees to video testimonial which becomes centerpiece of landing page. Multiple new patients mention seeing testimonial during consultations. One testimonial workflow generates multiple new patients and significant revenue. Practice review rating improves substantially. Pro Tips Timing is Everything: Send form 7-10 days after purchase or project completion when customers are still excited Incentivize Generously: 15-20 percent discount codes dramatically increase submission rates Make It Easy: Pre-fill customer information when possible and keep form under 10 fields Photo Requests Work: 60 percent of customers will upload headshots if you explain it increases credibility Video Follow-Ups: After receiving strong text testimonial, reach out personally to request video version Permission Clarity: Be explicit about where and how testimonials will be used Response Templates: Create templates for personal follow-ups to high-priority testimonials Quarterly Campaigns: Run testimonial collection campaigns quarterly with bonus rewards Showcase Submissions: Feature new testimonials in monthly newsletter A/B Test Formats: Test different testimonial layouts on website Industry Segmentation: Filter testimonials by industry for targeted landing pages NPS Integration: Send testimonial forms only to Promoters for higher quality submissions Social Proof Everywhere: Use testimonial snippets in email signatures and proposal templates Update Regularly: Refresh website testimonials quarterly to maintain relevance Track Attribution: Tag testimonials with UTM parameters when shared on social media Learning Resources This workflow demonstrates advanced automation including AI Agents for Content Optimization, Dynamic Reward Logic, Marketing Asset Generation, Sentiment Analysis, Data Organization, Multi-Channel Optimization, Customer Journey Mapping, Competitive Intelligence, Workflow Efficiency, and Permission Management. Business Impact Metrics Track these key metrics to measure success: Testimonial Collection Rate: Monitor percentage of customers who submit testimonials (target 10-15 percent) Submission Quality Score: Monitor average AI authenticity and sentiment scores (target 80 plus out of 100) Marketing Team Efficiency: Measure time saved finding and formatting testimonials (expect 10 plus hours per month saved) Conversion Rate Impact: A/B test pages with and without optimized testimonials (expect 30-50 percent lift) Reward Redemption Rate: Track percentage of customers who use thank-you coupon codes (typical 40-60 percent) Referral Generation: Count referrals attributed to testimonial thank-you emails (expect 3-5 percent referral rate) Social Media Engagement: Monitor engagement on testimonial posts versus other content (expect 2-3x higher) High-Priority Testimonial Ratio: Track percentage of testimonials rated high priority by AI (target 50-70 percent) Time to Marketing Use: Measure days from submission to live testimonial on website (aim for under 1 day) Customer Satisfaction: Survey customers about testimonial submission experience (target 90 percent plus positive) Template Compatibility Compatible with n8n version 1.0 and above Works with n8n Cloud and Self-Hosted No coding required for basic setup Fully customizable for industry-specific needs Ready to turn customers into brand advocates? Import this template and transform scattered testimonials into organized marketing assets with AI-powered analysis and automation!

This n8n template from Intuz provides a complete and automated solution for scaling your DevOps practices across multiple repositories. Are you tired of the repetitive dance between git push, creating a pull request in GitHub, updating the corresponding task in JIRA, and then manually notifying your team in Slack, or Notion? This template puts your entire post-commit workflow on autopilot, creating a seamless and intelligent bridge between your code and your project management. By embedding specific keywords and a JIRA issue ID into your git commit commands, this workflow automatically creates a Pull Request in the correct GitHub repository and updates the corresponding JIRA ticket. This creates a complete, centralized system that keeps all your projects synchronized, providing a massive efficiency boost for teams managing a diverse portfolio of codebases. Who This Template Is For? This template is a must-have for any organization looking to streamline its software development lifecycle (SDLC). It’s perfect for: Development Teams: Eliminate tedious, manual tasks and enforce a consistent workflow, allowing developers to stay focused on coding. DevOps Engineers: A ready-to-deploy solution that integrates key developer tools without weeks of custom scripting. Engineering Managers & Team Leads: Gain real-time visibility into development progress and ensure processes are followed without constant check-ins. Project Managers: Get accurate, automatic updates in JIRA the moment development work is completed, improving project tracking and forecasting. Step-by-Step Setup Instructions Follow these steps carefully to configure the workflow for your environment. 1. Connect Your Tools (Credentials) GitHub: Create credentials with repo scope to allow PR creation. JIRA: Create an API token and connect your JIRA Cloud or Server instance. Slack: Connect your Slack workspace using OAuth2. Notion: Connect your Notion integration token. 2. Configure the GitHub Webhook (For Each Repository) This workflow is triggered by a GitHub webhook. You must add it to every repository you want to automate. First, Save and Activate the n8n workflow to ensure the webhook URL is live. In the n8n workflow, copy the Production URL from the Webhook node. Go to your GitHub repository and navigate to Settings > Webhooks > Add webhook. In the Payload URL field, paste the n8n webhook URL. Change the Content type to application/json. Under "Which events would you like to trigger this webhook?", select "Just the push event." Click "Add webhook." Repeat this for all relevant repositories. 3. Configure the JIRA Nodes (Crucial Step) Your JIRA project has unique IDs for its statuses. You must update the workflow to match yours. Find the two JIRA nodes named "Update task status after PR" and "Update the task status without PR." In each node, go to the Status ID field. Click the dropdown and select the status that corresponds to "Done" or "Development Done" in your specific JIRA project workflow. The list is fetched directly from your connected JIRA instance. 4. Configure Notification Nodes Tell the workflow where to send updates. For Slack: Open the two nodes named "Send message in slack..." and select your desired channel from the Channel ID dropdown. For Notion: Open the two nodes named "Append a block in notion..." and paste the URL of the target Notion page or database into the Block ID field. 5. Final Activation Once all configurations are complete, ensure the workflow is Saved and the toggle switch is set to Active. You are now ready to automate! Customization Guidance This template is a powerful foundation. Here’s how you can adapt it to your team's specific needs. 1. Changing the PR Title or Body: Go to the "Request to create PR" (HTTP Request) node. In the JSON Body field, you can edit the title and body expressions. For example, you could add the committer's name ({{$('Webhook').item.json.body.pusher.name }}) or a link back to the JIRA task. 2. Adapting to a Fixed Branching Strategy: If your team always creates pull requests against a single branch (e.g., develop), you can simplify the workflow. In the "Request to create PR" node, change the base value in the JSON body from {{...}} to your static branch name: "base": "develop". You can then remove the base branch logic from the "Commit Message Breakdown" (Code) node. 3. Modifying Notification Messages: The text sent to Slack and Notion is fully customizable. Open any of the Slack or Notion nodes and edit the text fields. You can include any data from previous nodes, such as the PR URL ({{ $('Request to create PR').item.json.body.html_url }}) or the repository name. 4. Adjusting the Commit Regex for Different Conventions: This is an advanced customization. If your team uses a different commit format (e.g., (DEV-123) instead of DEV-123), you can edit the regular expression in the "Commit Message Breakdown" (Code) node. Be sure to test your changes carefully. 5. Adding/Removing Notification Channels: Don't use Notion? Simply delete the two Notion nodes. Want to send an email instead? Add a Gmail or SMTP node in parallel with a Slack node and configure it with the same data. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started

(Retail) Supplier Restock Request Trigger This workflow automatically monitors your Shopify inventory, detects low-stock products, generates smart alert messages, logs records in Google Sheets and sends priority-based notifications to Slack. This workflow checks your Shopify store every 5 hours, identifies products with low inventory (≤10 units), generates professional alert messages using AI, prevents duplicate alerts using Google Sheets, assigns priority based on stock level and notifies your team on Slack. You receive: Automated inventory checks every 5 hours** Google Sheet tracking for low-stock products** Priority-based Slack alerts (High / Medium / Low)** Ideal for teams that want proactive inventory visibility without manual stock checks. Quick Start – Implementation Steps Connect your Shopify account to fetch products and inventory. Connect OpenAI to generate alert messages. Connect a Google Sheet for tracking alerts. Connect Slack to receive notifications. Activate the workflow — monitoring starts automatically. What It Does This workflow automates low-stock monitoring for Shopify products: Runs automatically every 5 hours. Fetches all products and inventory levels from Shopify. Cleans and prepares product data (SKU, name, stock, vendor). Processes products in small batches to avoid overload. Filters only products with stock ≤ 10 units. Generates a professional alert message using AI. Checks Google Sheets to avoid duplicate records. Appends new records or updates existing ones. Assigns priority based on stock level: 2 units → High priority 6 units → Medium priority 10 units → Low priority Sends a clear Slack alert to the team. This ensures timely restocking with no duplicate alerts. Who’s It For This workflow is ideal for: E-commerce store owners Inventory & operations teams Shopify store managers Supply chain teams Startups managing limited stock Businesses wanting automated restock alerts Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Shopify store** with API access OpenAI API key** Google Sheets** access Slack workspace** with API permissions No advanced technical knowledge required. How It Works Scheduled Check – Workflow runs every 5 hours. Fetch Products – Retrieves all Shopify products. Prepare Data – Extracts SKU, name, stock, vendor. Low-Stock Filter – Keeps only items ≤ 10 units. AI Message Creation – Generates alert text. Duplicate Check – Looks up Google Sheet records. Update or Insert – Keeps the sheet up to date. Priority Assignment – Sets urgency level. Slack Alert – Notifies the team instantly. Setup Steps Import the provided n8n workflow JSON. Open the Shopify nodes → connect your Shopify credentials. Add your OpenAI API key in the AI nodes. Connect your Google Sheets account and map fields. Connect Slack and select the alert channel. Adjust stock thresholds if needed. Activate the workflow — done! How To Customize Nodes Customize Stock Thresholds Modify the IF / Switch nodes to: Change low-stock limits Add more priority levels Customize Alert Messages Edit the AI prompt to: Change tone (urgent, friendly, formal) Add emojis or mentions Include pricing or vendor info Customize Google Sheet Fields You can add: Vendor name Last updated date Restock status Assigned team member Customize Slack Alerts Enhance messages with: @mentions Emojis Links to Shopify product pages Add-Ons (Optional Enhancements) You can extend this workflow to: Send email alerts Create weekly summary reports Add auto-restock triggers Integrate with ERP systems Track restock completion Add dashboards using Google Sheets Use Case Examples 1\. Inventory Monitoring Automatically track low-stock items. 2\. Restock Planning Prioritize restocking based on urgency. 3\. Team Alerts Notify operations instantly via Slack. 4\. Audit & Tracking Maintain a clean inventory alert log. 5\. Store Scaling Prevent stock-outs as order volume grows. Troubleshooting Guide | Issue | Possible Cause | Solution | |----------------------|----------------------|----------------------------------| | No Slack alerts | Slack not connected | Check Slack credentials | | Duplicate rows | SKU mismatch | Ensure SKU is consistent | | No low-stock items | Threshold too low | Adjust IF condition | | AI message empty | OpenAI key missing | Verify API key | | Workflow not running | Trigger disabled | Enable Schedule Trigger | Need Help? If you need help customizing or extending this workflow with advanced features like adding analytics, ERP integrations, advanced alerts or scaling it for high-volume stores, then our n8n workflow developers at WeblineIndia are happy to help.

AI Meeting Assistant: Sync Fireflies Transcripts to ClickUp & Gmail Act as your personal executive assistant with this high-level automation designed to handle the most tedious post-meeting tasks. This workflow ensures that no action item is forgotten and that participants receive professional follow-ups without you having to lift a finger. Who is this for? Busy executives and managers who have back-to-back meetings. Project managers who need to sync action items directly into ClickUp. Sales teams who want to automate professional follow-up emails based on meeting context. How it works Fetch Transcripts: The workflow runs on a schedule and retrieves your latest meeting data directly from the Fireflies.ai API using HTTP nodes. Intelligent Filtering: A JavaScript node filters the list to process only today's meetings. AI Task Extraction: An AI Agent (using GPT-4o-mini) analyzes the transcript to find tasks specifically assigned to the host. It then uses the ClickUp tool to create these tasks with priorities and descriptions. Human-in-the-Loop: To ensure quality, the workflow sends a summary to your Telegram. It asks for approval before sending any external emails. Automated Follow-up: Once approved, a second AI Agent drafts a concise, professional email summary and sends it via Gmail to the external participants. Requirements Fireflies.ai Account:** You need an API Key (Settings -> Integrations -> Fireflies API). OpenAI API Key:** To power the AI Agents. ClickUp Workspace:** To manage the generated tasks. Telegram Bot:** For the approval notifications. Gmail Account:** For sending the follow-up emails. How to set up Fireflies API Key: Create a Header Auth credential in n8n. Set the Name to Authorization and the Value to Bearer YOUR_API_KEY_HERE. Configure Credentials: Add your credentials for OpenAI, ClickUp, Telegram, and Gmail. ClickUp Configuration: In the "Create ClickUp Task" node, select your specific Workspace, Space, and List from the dropdown menus. Identity Setup: Open the "Format Transcript Data" code node. Update the hostNames array with your name and aliases (e.g., ['Host', 'My Name']) so the AI correctly identifies you. Telegram Chat ID: Enter your Chat ID in the Telegram nodes to receive the approval prompts.

Overview This workflow automates end-to-end contract analysis using AI. It extracts clauses, evaluates risks, tracks obligations, and generates an executive summary from uploaded contracts. By combining multiple AI agents with structured parsing and scoring logic, the workflow provides deep legal insights and automatically flags high-risk contracts. It helps legal, compliance, and business teams review contracts faster, reduce risk, and ensure better decision-making. How It Works Webhook Trigger Accepts contract uploads via API endpoint. Workflow Configuration Defines: Risk threshold Alert recipients Slack notification channel PDF Text Extraction Extracts raw text from uploaded contract files. Parallel AI Analysis Multiple AI agents process the contract simultaneously: Clause Extraction Agent Identifies and categorizes contract clauses Risk Assessment Agent Evaluates clause-level risks Assigns risk levels and recommendations Obligation Extraction Agent Extracts responsibilities, deadlines, and commitments Executive Summary Agent Generates structured contract summary and insights Structured Output Parsing Ensures consistent JSON outputs for all agents Data Aggregation Merges outputs from all AI agents into one dataset Risk Scoring Engine Calculates weighted risk score based on: Clause types Risk levels Missing critical clauses AI confidence scores Generates: Score breakdown Red flags Recommendations Data Preparation Formats contract data for storage and tracking Database Storage Stores: Contract metadata Clauses Obligations Risk scoring results Risk Evaluation Compares calculated risk score against threshold Alert System If risk is high: Sends email alerts Sends Slack notifications Setup Instructions Webhook Setup Configure endpoint (contract-upload) Connect to your document upload system AI Model Setup Add Anthropic (Claude 3.5) or OpenAI credentials Connect model to all AI agent nodes Database Setup Configure Postgres credentials Create tables: contracts contract_clauses contract_obligations risk_scoring Email Integration Configure Gmail or SMTP credentials Set alert recipient emails Slack Integration Add Slack credentials Set channel ID for alerts Configuration Settings Adjust: Risk threshold (e.g., 0.7) Alert recipients Slack channel Use Cases Legal contract review automation Vendor agreement risk assessment Compliance and audit workflows Procurement contract validation AI-powered legal tech solutions Requirements AI model API (Anthropic or OpenAI) Postgres database Email service (Gmail/SMTP) Slack workspace n8n instance Key Features Multi-agent AI contract analysis Clause extraction and categorization Risk scoring with weighted logic Obligation tracking and deadline extraction Executive summary generation Automated high-risk alert system Structured database storage for audit Summary A powerful AI-driven contract intelligence workflow that transforms unstructured legal documents into structured insights, risk scores, and actionable recommendations. It enables faster contract reviews, better risk management, and scalable legal automation.

Automated AI-Powered Testimonial Processing & Social Media Workflow Overview: This comprehensive workflow automates the entire testimonial collection and publishing process, from submission to social media-ready content. It uses AI to enhance testimonials, generates beautiful branded cards, and implements an approval system before posting. Key Features: ✅ Webhook-based submission - Accept testimonials via API 🤖 AI Enhancement - GPT-4 polishes grammar while maintaining authenticity 🎨 Automated Design - Generates professional 800x600px testimonial cards ☁️ Cloud Storage - Uploads to Google Drive with organized naming 📊 Database Logging - Tracks all testimonials in Google Sheets 🔔 Team Notifications - Slack alerts for new and approved testimonials ✅ Approval Workflow - Manual review before social media posting 🔄 Scheduled Checker - Auto-detects approved testimonials every 5 minutes Workflow Steps: Main Flow (Testimonial Processing): Receives testimonial via webhook (POST request) Validates and cleans data (name, testimonial, photo, email) Enhances testimonial using GPT-4 Turbo Generates HTML template with customer details Converts HTML to PNG image (800x600px) Uploads image to Google Drive Logs all data to Google Sheets with "Pending Approval" status Sends Slack notification to review team Approval Flow (Scheduled Check): Runs every 5 minutes automatically Checks Google Sheets for approved testimonials Filters testimonials not yet posted Sends ready-to-post Slack notification with formatted text Marks testimonial as processed in database Use Cases: SaaS companies collecting customer feedback Marketing agencies managing client testimonials E-commerce businesses showcasing reviews Course creators featuring student success stories Any business automating social proof collection What Makes This Workflow Special: Zero manual design work** - Beautiful cards generated automatically AI-powered quality** - Professional grammar enhancement Audit trail** - Complete tracking in Google Sheets Approval control** - Review before publishing Duplicate prevention** - Smart matching by Drive ID Flexible input** - Accepts multiple field name variations 🔧 Required Integrations: OpenAI API (GPT-4 Turbo) - AI testimonial enhancement HTML/CSS to Image API - Screenshot generation Google Drive OAuth2 - Image storage Google Sheets OAuth2 - Database management Slack API - Team notifications 📋 Prerequisites: n8n instance (self-hosted or cloud) OpenAI API key (https://platform.openai.com) HTML/CSS to Image account (https://htmlcsstoimg.com) - Free tier available Google Cloud project with Drive & Sheets API enabled Slack workspace with app permissions 🚀 Setup Instructions: 1. Import Workflow Download the JSON file Import into your n8n instance Replace placeholder credentials (see below) 2. Configure Credentials Add these credentials in n8n: OpenAI API** - Your API key htmlcsstoimgApi** - User ID and API key Google Drive OAuth2** - Configure OAuth app Google Sheets OAuth2** - Same Google Cloud project Slack API** - Create Slack app with chat:write scope 3. Update Configuration Replace in the JSON: Google Drive Folder ID** - Your testimonial storage folder Google Sheets ID** - Your database spreadsheet Slack Channel ID** - Your notification channel 4. Test the Workflow Send a POST request to your webhook URL: { "name": "Sarah Johnson", "designation": "Marketing Director", "photo_url": "https://i.pravatar.cc/400?img=5", "testimonial_text": "Working with this team was amazing!", "email": "sample@gmail.com" } 📊 Google Sheets Setup: Create a Google Sheet with these columns: Timestamp Name Designation Original Testimonial Testimonial (Enhanced) Image Link Drive ID Status Email Original Length Enhanced Source Posted to Social Posted At 🎨 Customization Options: Modify AI prompt for different enhancement styles Change HTML template colors/design Add more validation rules Integrate with Twitter/LinkedIn APIs for auto-posting Add email notifications instead of Slack Include rating/score system Add custom approval fields 🆘 Troubleshooting: Webhook not receiving data: Check webhook URL is correct Verify HTTP method is POST Ensure Content-Type is application/json AI enhancement failing: Verify OpenAI API key is valid Check API usage limits Ensure sufficient credits Image not generating: Confirm htmlcsstoimg credentials are correct Check HTML template has no errors Verify you haven't exceeded free tier limit Google Drive upload failing: Re-authenticate OAuth2 connection Check folder ID is correct Verify folder permissions 🏆 Perfect For: Marketing teams Customer success teams Product managers Social media managers Growth hackers Agency owners ⚖️ License: Free to use and modify for personal and commercial projects.

How it works This workflow triggers when a HubSpot deal stage changes to Closed Won and automatically generates an invoice. It collects deal and contact data, builds a styled invoice, converts it into a PDF, and sends it to the client. The system logs all invoices and alerts the team, then monitors payment status with automated reminders. If payment is delayed, it escalates the issue and handles errors separately. Step-by-step Trigger and data collection** HubSpot - Deal Trigger – Starts workflow on deal stage change. IF - Is Deal Closed Won? – Filters only Closed Won deals. HTTP - Get Deal Details – Fetches deal information. HTTP - Get Deal Associations – Retrieves linked contacts. Code - Extract Contact ID – Extracts and formats data. HTTP - Get Contact Details – Gets customer details. Invoice generation** Code - Build Invoice + HTML – Creates invoice data and HTML layout. Send and store invoice** HTTP - Generate PDF – Converts HTML into PDF. Google Sheets - Log Invoice – Stores invoice records. Notion - Create Invoice Record – Tracks invoice internally. Gmail - Send Invoice Email – Sends invoice to client. Slack - Invoice Sent Alert – Notifies team. Payment tracking and follow-up** Wait - 7 Day Payment Window – Waits before checking payment. HTTP - Recheck Deal Stage – Checks payment status. IF - Payment Received? – Branches based on payment. Gmail - Follow-up Email #1 – Sends reminder if unpaid. Wait - 5 More Days – Adds extra delay. HTTP - Final Payment Check – Verifies final status. Slack - Payment Confirmed – Confirms successful payment. Escalation handling** IF - Still Unpaid? (Escalate) – Detects overdue invoices. Slack - Escalation Alert – Alerts team for action. Notion - Flag as Overdue – Updates record status. Slack - Late Payment Confirmed – Handles delayed payments. Error handling (separate flow)** Error Trigger – Captures workflow failures. Slack - Workflow Error Alert – Sends error notification. Why use this? Fully automates invoicing from deal closure to payment tracking Reduces manual billing work and human errors Improves payment collection with automated reminders Provides clear visibility with logs and team alerts Ensures reliability with built-in error monitoring

AI Customer Support Triage with Gmail, OpenAI, Airtable & Slack How it Works This workflow monitors your Gmail support inbox every minute, automatically sending each unread email to OpenAI for intelligent analysis. The AI evaluates sentiment (Positive/Neutral/Negative/Critical), urgency level (Low/Medium/High/Critical), categorizes requests (Technical/Billing/Feature Request/Bug Report/General), extracts key issues, and generates professional response templates. The system calculates a priority score (0-110) by combining urgency and sentiment weights, then routes tickets accordingly. Critical issues trigger immediate Slack alerts with full context and 30-minute SLA reminders, while routine tickets post to standard monitoring channels. Every ticket logs to Airtable with complete analysis and thread tracking, then updates a Google Sheets dashboard for real-time analytics. A secondary AI pass generates strategic insights (trend identification, risk assessment, actionable recommendations) and stores them back in Airtable. The entire process takes seconds from email arrival to team notification, eliminating manual triage and ensuring critical issues get immediate attention. Who is this for? Customer support teams needing automated prioritization for high email volumes SaaS companies tracking support metrics and response times Startups with lean teams requiring intelligent ticket routing E-commerce businesses managing technical, billing, and return inquiries Support managers needing data-driven insights into customer pain points Setup Steps Setup time:** 20-30 minutes Requirements:** Gmail, OpenAI API key, Airtable account, Google Sheets, Slack workspace Monitor Support Emails: Connect Gmail via OAuth2, configure INBOX monitoring for unread emails AI Analysis Engine: Add OpenAI API key, system prompt pre-configured for support analysis Parse & Enrich Data: JavaScript code automatically calculates priority scores (no changes needed) Route by Urgency: Configure routing rules for critical vs routine tickets Slack Alerts: Create Slack app, get bot token and channel IDs, replace placeholders in nodes Airtable Database: Create base with "tblSupportTickets" table, add API key and Base ID (replace appXXXXXXXXXXXXXX) Google Sheets Dashboard: Create spreadsheet, enable Sheets API, add OAuth2 credentials, replace Sheet ID (1XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX) Generate Insights: Second OpenAI call analyzes patterns, stores insights in Airtable Test: Send test email, verify Slack alerts, check Airtable/Sheets data logging Customization Guidance Priority Scoring:** Adjust urgency weight (25) and sentiment weight (10) in Code node to match your SLA requirements Categories:** Modify AI system prompt to add industry-specific categories (e.g., healthcare: appointments, prescriptions) Routing Rules:** Add paths for High urgency, VIP customers, or specific categories Auto-Responses:** Insert Gmail send node after routine tickets for automatic acknowledgment emails Multi-Language:** Add Google Translate node for non-English support VIP Detection:** Query CRM APIs or match email domains to flag enterprise customers Team Assignment:** Route different categories to dedicated Slack channels by department Cost Optimization:** Use GPT-3.5 (~$0.001/email) instead of GPT-4, self-host n8n for unlimited executions Once configured, this workflow operates as your intelligent support triage layer—analyzing every email instantly, routing urgent issues to the right team, maintaining comprehensive analytics, and generating strategic insights to improve support operations. Built by Daniel Shashko Connect on LinkedIn

Disclaimer Please note - This workflow is only available on n8n self-hosted as it’s making use of the community node for the Decodo Web Scraping This n8n workflow automates the process of scraping, analyzing, and summarizing Amazon product reviews using Decodo’s Amazon Scraper, OpenAI GPT-4.1-mini, and Google Sheets for seamless reporting. It turns messy, unstructured customer feedback into actionable product insights — all without manual review reading. Who this is for This workflow is designed for: E-commerce product managers** who need consolidated insights from hundreds of reviews. Brand analysts and marketing teams** performing sentiment or trend tracking. AI and data engineers** building automated review intelligence pipelines. Sellers and D2C founders** who want to monitor customer satisfaction and pain points. Product researchers** performing market comparison or competitive analysis. What problem this workflow solves Reading and analyzing hundreds or thousands of Amazon reviews manually is inefficient and subjective. This workflow automates the entire process — from data collection to AI summarization — enabling teams to instantly identify customer pain points, trends, and strengths. Specifically, it: Eliminates manual review extraction from product pages. Generates comprehensive and abstract summaries using GPT-4.1-mini. Centralizes structured insights into Google Sheets for visualization or sharing. Helps track product sentiment and emerging issues over time. What this workflow does Here’s a breakdown of the automation process: Set Input Fields Define your Amazon product URL, geo region, and desired file name. Decodo Amazon Scraper Fetches real-time product reviews from the Amazon product page, including star ratings and AI-generated summaries. Extract Reviews Node Extracts raw customer reviews and Decodo’s AI summary into a structured JSON format. Perform Review Analysis (GPT-4.1-mini) Uses OpenAI GPT-4.1-mini to create two key summaries: Comprehensive Review: A detailed summary that captures sentiment, recurring themes, and product pros/cons. Abstract Review: A concise executive summary that captures the overall essence of user feedback. Persist Structured JSON Saves the raw and AI-enriched data to a local file for reference. Append to Google Sheets Uploads both the original reviews and AI summaries into a Google Sheet for ongoing analysis, reporting, or dashboard integration. Outcome: You get a structured, AI-enriched dataset of Amazon product reviews — summarized, searchable, and easy to visualize. Setup Pre-requisite If you are new to Decode, please signup on this link visit.decodo.com Please make sure to install the n8n custom node for Decodo. Step 1 — Import the Workflow Open n8n and import the JSON workflow template. Ensure the following credentials are configured: Decodo Credentials account → Decodo API Key OpenAI account → OpenAI API Key Google Sheets account → Connected via OAuth Step 2 — Input Product Details In the Set node, replace: amazon_url → your product link (e.g., https://www.amazon.com/dp/B0BVM1PSYN) geo → your region (e.g., US, India) file_name → output file name (optional) Step 3 — Connect Google Sheets Link your desired Google Sheet for data storage. Ensure the sheet columns match: product_reviews all_reviews Step 4 — Run the Workflow Click Execute Workflow. Within seconds, your Amazon product reviews will be fetched, summarized by AI, and logged into Google Sheets. How to customize this workflow You can tailor this workflow for different use cases: Add Sentiment Analysis** — Add another GPT node to classify reviews as positive, neutral, or negative. Multi-Language Reviews** — Include a language detection node before summarization. Send Alerts** — Add a Slack or Gmail node to notify when negative sentiment exceeds a threshold. Store in Database** — Replace Google Sheets with MySQL, Postgres, or Notion nodes. Visualization Layer** — Connect your Google Sheet to Looker Studio or Power BI for dynamic dashboards. Alternative AI Models** — Swap GPT-4.1-mini with Gemini 1.5 Pro, Claude 3, or Mistral for experimentation. Summary This workflow transforms the tedious process of reading hundreds of Amazon reviews into a streamlined AI-powered insight engine. By combining Decodo’s scraping precision, OpenAI’s summarization power, and Google Sheets’ accessibility, it enables continuous review monitoring. In one click, it delivers comprehensive and abstract AI summaries, ready for your next product decision meeting or market strategy session.