Automated stock trading with AI: integrating Alpaca and Google Sheets
Description Transform your investment strategy with a fully automated, AI-driven trading bot. This workflow bridges the gap between AI-powered market insights and real-world trading by executing buy and sell orders directly through the Alpaca paper trading API. Designed to work in tandem with the Automated Stock Sentiment Analysis workflow, this solution takes the top-performing stocks based on daily news sentiment and automatically rebalances your portfolio. It's perfect for algorithmic traders, data-driven investors, and n8n enthusiasts who want to see their AI analysis translate into tangible actions, all while maintaining a comprehensive log of every transaction in Google Sheets. Key Features & Benefits Automated Trading Execution: Automatically places buy and sell orders on the Alpaca paper trading platform without manual intervention. Sentiment-Driven Decisions: Leverages the output from the sentiment analysis workflow to make informed decisions, selling positions with waning sentiment and buying into those with high positive sentiment. Dynamic Portfolio Rebalancing: Intelligently calculates which positions to close and how to allocate the resulting funds into new, high-potential stocks. Paper Trading Ready: Safely test and refine your trading strategies in a risk-free environment using Alpaca's paper trading API. Daily Performance Tracking: Automatically logs your account equity and daily percentage change to a Google Sheet, giving you a clear view of your portfolio's performance. Detailed Trade Logging: Every buy and sell order is meticulously recorded in a Google Sheet for easy review and historical analysis. Scheduled and Autonomous: The entire process runs on a daily schedule, making it a "set and forget" solution for systematic trading. How It Works This workflow executes a sophisticated, automated trading strategy in a few key stages: Daily Kick-off & Snapshot: The workflow triggers on a daily schedule, first fetching your current Alpaca account balance and logging it to a Google Sheet to track daily performance. Strategy Formulation: It then reads the daily sentiment scores produced by the accompanying "Stock Sentiment Analysis" workflow. A Code node filters these results to identify the top four stocks with the highest positive sentiment. The Decision Engine: The core of the workflow is a custom Code node that acts as the trading brain. It: Retrieves your currently open positions from Alpaca. Compares your holdings against the day's top four sentiment stocks. Generates a "sell list" of positions you hold that are no longer in the top four. Generates a "buy list" of top-sentiment stocks that you don't yet own. Calculates the total cash value from the "sell list" and determines the exact notional value to invest in each stock on the "buy list." Trade Execution: The workflow first iterates through the "sell list" and executes a DELETE request to Alpaca for each, closing the positions. A Wait node pauses the workflow for two minutes to ensure the sell orders are filled and the account balance is updated. It then iterates through the "buy list," executing POST requests to Alpaca to purchase the new assets with the calculated funds. Record Keeping: All executed orders (both buys and sells) are merged and logged in a dedicated Google Sheet, giving you a permanent and detailed transaction history. Nodes Used Schedule Trigger HttpRequest (Alpaca API) Google Sheets Code (JavaScript) SplitOut Wait Merge This workflow is the perfect next step for anyone looking to take their AI analysis to the next level. Take the emotion out of your trading and let this bot systematically execute your data-driven strategy.
By Raz HadasLinkedIn engagement automator with GPT-4o/Claude, human review & multilingual comments
Automate LinkedIn engagement without sounding like a bot. This workflow: 🌍 Detects language & tone (German / English) 👍 Chooses the right reaction (like / celebrate / support …) 🗣 Generates a personalised comment in your voice and mentions the author 📲 Optional Telegram review – approve ✅ or regenerate ❌ before posting 💸 Runs on cost-efficient GPT-4o mini or Claude 3.5 Haiku ☁️ Publishes comment + reaction via the Unipile API Setup (≈ 15-30 min) Unipile – connect LinkedIn → copy account_id, dsn, then create an Access-Token (X-API-KEY). Telegram (optional) – create a bot, add a credential named YOUR TELEGRAM ACCOUNT. OpenAI / Anthropic – add your API key and keep one LLM node (delete the other). Open the “Defining guardrails” node and replace the credential placeholders. (Optional) Tweak role, commentlength and openersexample_1-3 for your brand voice. Security: no live keys included – all secrets are placeholders. Best for: solopreneurs, marketing teams, personal-branding consultants.
By StefanDaily Google Search Console SEO pulse: Catch top movers across keyword segments
This workflow helps SEO teams catch top movers in Google Search Console by comparing daily performance across keyword segments like brand, nonbrand, and content categories. Instead of serving as a routine check, it highlights the queries and pages with the biggest jumps or drops, making it ideal for spotting wins, losses, or unexpected shifts early. How It Works Runs daily on a scheduled trigger (e.g. every morning). Pulls GSC data for the prior two days (e.g. yesterday vs. day before). Segments traffic by keyword type or URL pattern (e.g. brand, nonbrand, recipes, blogs, etc.). Calculates changes in clicks, impressions, CTR, and average position. Flags top movers with the biggest positive or negative deltas. Sends structured reports via Slack or email, grouped by segment and sorted by impact. Setup Steps Connect your Google Search Console account and optionally Gmail or Slack. Swap in your own domain(s) and customize segmentation logic (e.g. brand terms, path filters). By default, the workflow includes Slack alerts, but these can be easily switched to or combined with email, webhook, or other channels. Full setup takes around 15–20 minutes with working GSC credentials. Note: The “recipes” segment is included as an example of how to segment content. This can be changed to match blog, FAQ, product pages, or any other category.
By MattFComprehensive API integration suite with health, webhook, auth & rate limit monitoring
How it works This workflow creates a complete MCPserver that provides comprehensive API integration monitoring and testing capabilities. The server exposes five specialized tools through a single MCP endpoint: API health analysis, webhook reliability testing, rate limit monitoring, authentication verification, and client report generation. External applications can connect to this MCP server to access all monitoring tools. Who is this for This template is designed for DevOps engineers, API developers, integration specialists, and technical teams responsible for maintaining API reliability and performance. It's particularly valuable for organizations managing multiple API integrations, SaaS providers monitoring client integrations, and development teams implementing API monitoring strategies. Requirements MCP Client: Any MCP-compatible application (Claude Desktop, custom MCP client, or other AI tools) Network Access: Outbound HTTP/HTTPS access to test API endpoints and webhooks Authentication: Bearer token authentication for securing the MCP server endpoint Target APIs: The APIs and webhooks you want to monitor (no special configuration required on target systems) How to set up Configure MCP Server Authentication - Update the MCP Server - API Monitor Entry node with your desired authentication method and generate a secure bearer token for accessing your MCP server Deploy the Workflow - Save and activate the workflow in your n8n instance, noting the MCP server endpoint URL that will be generated for external client connections Connect MCP Client - Configure your MCP client (such as Claude Desktop) to connect to the MCP server endpoint using the authentication token you configured Test Monitoring Tools - Use your MCP client to call the available tools: Analyze Api Health, Validate Webhook Reliability, Monitor API Limits, Verify Authentication, and Generate Client Report with your API endpoints and credentials
By Grace GbadamosiTask escalation system with Google Sheets, Gmail, Telegram & Jira automation
Description This workflow sends an instant email alert when a task in a Google Sheet is marked as Urgent, and then sends a Telegram reminder notification after 2 hours if the task still hasn’t been updated. Then a Jira ticket is created so the task enters in the formal workflow and another Telegram message is sent with the details of the issue created. It helps teams avoid missed deadlines and ensures urgent tasks get attention — without requiring anyone to refresh or monitor the sheet manually. Context In shared task lists, urgent items can be overlooked if team members aren't actively checking the spreadsheet. This workflow solves that by: Sending an email as soon as a task becomes Urgent Waiting 2 hours Checking if the task is still open Sending a Telegram reminder only if action has not been taken Creating a Jira issue Sending a Telegram message with the details of the issue created This prevents both silence and spam, creating a smart and reliable alert system. Target Users Project Managers using Google Sheets Team leads managing shared task boards Remote teams needing lightweight coordination Anyone who wants escalation notifications without complex systems Technical Requirements Google Sheets credential Gmail credential Telegram Bot + Chat ID Google Sheet with a column named Priority Jira credential Workflow Steps Trigger: Google Sheets Trigger (on update in the “Priority” column) IF Node – Checks if Priority = Urgent Send Email – Sends alert email with task name, owner, status, deadline Mark Notified = Yes in the sheet Wait 2 hours IF Status is still not resolved Send Telegram reminder create an Issue on Jira based on the information provided Send Telegram message with the details of the ticket Key Features Real-time alerts on critical tasks Simple logic (no code required) Custom email body with dynamic fields Works on any Google Sheet with a “Priority” column Telegram notification ensures the task doesn’t get forgotten Expected Output Personalized email alert when a task is marked as "Urgent" Email includes task info: title, owner, deadline, status, next step Telegram message after 2 hours if the task is still open Automatic creation of a Jira issue with the higgest priority Telegram message to notify about the new Jira ticket How it works Trigger: Watches for “Priority” updates 🔍 Check: If Priority = Urgent AND Notified is empty 📧 Email: Sends a personalized alert ✏️ Sheet Update: Marks the task as already notified ⏳ Wait: 2-hour delay 🤖 Check Again: If Status hasn’t changed → send Telegram reminder, create Jira ticket and send the details. Tutorial video: Watch the Youtube Tutorial video About me : I’m Yassin a Project & Product Manager Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin
By Yassin ZeharTypeform lead capture to HubSpot with scoring and Slack alerts
📄 Smart Lead Capture, Scoring & Slack Alerts This workflow captures new leads from Typeform, checks for duplicates in HubSpot CRM, enriches and scores them, assigns priority tiers (Cold, Warm, Hot), and instantly notifies your sales team in Slack. 🔧 How It Works Typeform Trigger → Monitors form submissions and passes lead details into the workflow. HubSpot Deduplication → Searches HubSpot by email before creating a new record. Conditional Routing → If no match → Creates a new contact in HubSpot. If match found → Updates the existing contact with fresh data. Lead Scoring (Function Node) → Custom JavaScript assigns a score based on your rules (e.g. company email, job title, engagement signals, enrichment data). Tier Assignment → Categorizes the lead as ❄️ Cold, 🌡 Warm, or 🔥 Hot based on score thresholds. Slack Notification → Sends formatted lead alerts to a dedicated sales channel with priority indicators. 👤 Who Is This For? Sales teams who need to prioritize hot leads in real-time. Marketing teams running inbound lead capture campaigns with Typeform. RevOps teams that want custom scoring beyond HubSpot defaults. Founders/SMBs looking to tighten lead-to-revenue pipeline with automation. 💡 Use Case / Problem Solved ❌ Duplicate contacts clogging HubSpot CRM. ❌ Manual lead triage slows down response time. ❌ HubSpot’s default scoring is rigid. ✅ Automates lead creation + scoring + notification in one flow. ✅ Sales teams get immediate Slack alerts with context to act fast. ⚙️ What This Workflow Does Captures lead data directly from Typeform. Cleans & deduplicates contacts before pushing to HubSpot CRM. Scores and categorizes leads via custom logic. Sends structured lead alerts to Slack, tagged by priority. Provides a scalable foundation you can extend with data enrichment (e.g., Clearbit, Apollo). 🛠️ Setup Instructions 🔑 Prerequisites Typeform account with API access → Typeform Developer Docs HubSpot CRM account with API key or OAuth → HubSpot API Docs Slack workspace & API access → Slack API Docs (Optional) n8n automation platform to build & run → n8n Hub 📝 Steps to Configure Typeform Node (Trigger) Connect your Typeform account in n8n. Select the form to track submissions. Fields typically include: first name, last name, email, company, phone. HubSpot Node (Search Contact) Configure a search by email. Route outcomes: Not Found → Create Contact Found → Update Contact HubSpot Node (Create/Update Contact) Map Typeform fields into HubSpot (email, name, phone, company). Ensure you capture both standard and custom properties. Function Node (Lead Scoring) Example JavaScript: // Simple lead scoring example const email = $json.email || ""; let score = 0; if (email.endsWith("@company.com")) score += 30; if ($json.company && $json.company.length > 2) score += 20; if ($json.phone) score += 10; let tier = "❄️ Cold"; if (score >= 60) tier = "🔥 Hot"; else if (score >= 30) tier = "🌡 Warm"; return { ...$json, leadScore: score, leadTier: tier }; Customize rules based on your GTM strategy. Reference → n8n Function Node Docs Slack Node (Send Message) Example Slack message template: 🚀 New Lead Alert! 👤 {{ $json.firstname }} {{ $json.lastname }} 📧 {{ $json.email }} | 🏢 {{ $json.company }} 📊 Score: {{ $json.leadScore }} — {{ $json.leadTier }} Send to dedicated sales-leads channel. Reference → Slack Node in n8n 📌 Notes & Extensions 🔄 Add enrichment with Clearbit or Apollo.io before scoring. 📊 Use HubSpot workflows to trigger nurturing campaigns for ❄️ Cold leads. ⏱ For 🔥 Hot leads, auto-assign to an SDR using HubSpot deal automation. 🧩 Export data to Google Sheets or Airtable for analytics.
By Krishna Sharma