Skip to content
FlowHubFluxonLab

Slack workflows

1,961 results — 383 downloadable workflow files, 1,578 source-linked n8n references

Csheets
free

Route supplier risk alerts from Gmail to Slack with Gemini and Google Sheets

Quick overview This workflow monitors incoming Gmail messages from suppliers, uses Google Gemini to analyze sentiment and relationship risk, generates an engagement strategy for risky emails, sends an alert to Slack, and logs the analysis and recommended response to Google Sheets. How it works Triggers every minute by checking Gmail for new incoming emails. Filters out irrelevant messages (for example newsletters, unsubscribe emails, no-reply senders, and auto-replies) and keeps only valid supplier emails. Extracts the sender, subject, and email snippet into a single text block and waits briefly to buffer processing. Sends the email text to Google Gemini to return a structured JSON analysis with sentiment score/label, intent, urgency, key concern, and deterioration risk, then normalizes these fields and derives a trend. Flags the interaction as high risk based on the deterioration risk value or a low sentiment score and waits briefly before continuing. Uses Google Gemini to generate a concise engagement strategy (recommended action, draft opening message, and follow-up timeline), then parses it and formats a Slack-ready alert. Sends the alert to a selected Slack user and appends th

by WeblineIndia
airtableCsheetsW
free

Route insurance quote leads with OpenAI, Airtable, Sheets, Teams, Slack and Twilio

Quick overview This workflow receives insurance quote submissions via a webhook, normalizes and deduplicates them against Airtable and/or Google Sheets, uses OpenAI to score and classify the lead, then routes hot/warm leads to Microsoft Teams and/or Slack (plus Twilio SMS for hot leads) and logs the quote. How it works Receives an insurance quote request through a webhook endpoint. Applies configurable settings (log destination, notification channels, thresholds) and normalizes the incoming form payload into a standard quote format. Checks Airtable and/or Google Sheets for recent matching email/phone/hash entries to detect duplicate submissions. If the quote is new and has contact details, sends the quote data to OpenAI to generate a lead score, priority, underwriting flags, missing info, and recommended next steps. Routes the quote as hot, warm, or cold based on the score/priority and prepares formatted alert messages for Microsoft Teams and Slack. Posts hot/warm alerts to Microsoft Teams and/or Slack, and sends a Twilio SMS to an agent for hot leads. Creates a quote log record in Airtable and/or appends a row to Google Sheets, then returns a JSON response with logging and notific

by Precision Tech
BCgooglecalendaropenaichatmodel
free

Schedule weekly focus-time blocks with Google Calendar, OpenAI, and Slack

Quick overview This workflow runs every Sunday at 18:00 to scan your Google Calendar for next week, find free gaps of at least two hours within your working hours, auto-book them as “🧘 Focus Time” events, and then DM you a personalized deep-work plan in Slack using OpenAI. How it works Runs every Sunday at 18:00 on a schedule. Loads your working-hour preferences and fetches all events from your Google Calendar. Calculates weekday-only free gaps within your working hours and keeps only gaps that meet the minimum block length. If no qualifying gap exists, sends you a Slack DM warning that next week is too fragmented for a focus block. If gaps exist, limits the number of blocks for the week and creates “🧘 Focus Time (protected by n8n)” events in Google Calendar for each selected slot. Uses OpenAI to generate a short, personal Slack message that lists the protected blocks and suggests what kind of work fits each. Sends the generated deep-work plan to you as a Slack DM. Setup Add Google Calendar credentials, select the calendar to read from and the calendar to create “🧘 Focus Time” events in. Add Slack credentials and set your target Slack username in both the plan DM and warning mes

by kenta
Csheetsyoutube
free

Audit YouTube video metadata changes with Google Sheets and Slack

Quick Overview This workflow runs daily to fetch all videos from a YouTube channel, compare key metadata fields against a prior snapshot stored in Google Sheets, log any differences, and optionally post a summary to Slack. How it works Runs every day at 08:00 on a schedule. Reads your YouTube channel’s uploads playlist and retrieves each video’s current title, description, tags, privacy status, and category. Loads the previous snapshot from Google Sheets and compares the tracked fields to detect added, removed/hidden, or changed metadata. When changes are found, appends each changed field (old value vs new value) to a Google Sheets change log. Clears and rewrites the snapshot in Google Sheets with the latest metadata so the next run compares against today’s baseline. Posts a summary to a Slack channel when changes are detected (or when alwaysNotify is enabled). Setup Add a YouTube (Google) OAuth2 credential and set your target channel ID in the audit options. Add a Google Sheets credential, set the spreadsheet ID, and ensure your spreadsheet has a Snapshot tab and a Change Log tab mapped in the Google Sheets steps. Add a Slack credential and set the target Slack channel ID for the

by Kevin Yu
Cgoogledrive
free

Create daily webpage PDF reports with PDFBolt, Slack and Google Drive

Quick overview This workflow creates a daily PDF report from a webpage URL with PDFBolt, posts it to Slack, and archives the same PDF in Google Drive. How it works Runs every day at 08:00 on a scheduled trigger. Sets the report date, webpage URL, report title, Slack message, and a dated PDF filename. Converts the configured webpage URL into an A4 PDF with PDFBolt, using Network Idle so charts, images, and async content can finish loading. Uploads the generated PDF to Slack with a title, filename, and initial comment. Uploads the same PDF file to a selected Google Drive folder for storage. Setup Add your PDFBolt API key from https://app.pdfbolt.com/api-keys in n8n. Add a Slack OAuth2 connection and replace the Slack channel ID with your target channel. Add a Google Drive OAuth2 connection and choose the destination Drive and folder for archived reports. Update the report URL and report name values in the report settings code so they match the page you want to capture. Requirements PDFBolt account and API key Slack account connected in n8n Google Drive account connected in n8n Customization Change the report URL, report name, and PDF filename Choose a different Slack channel Choose a

by PDFBolt
ACgmailW
free

Send weekly blended ad performance reports with Meta, Google Ads, GA4 and OpenAI

Quick overview This workflow runs every Monday at 8am to pull the last 7 days of performance from Meta Ads, Google Ads, and GA4, calculate blended KPIs, generate an OpenAI-powered narrative summary, email an HTML report via Gmail, and post an internal update (and errors) to Slack. How it works Runs every Monday at 8am on a scheduled trigger. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights API, campaign cost and conversion metrics from the Google Ads API, and conversions and revenue by channel from the GA4 Reporting API. Combines the three datasets and calculates blended KPIs including total spend, total conversions, total revenue, and ROAS. Sends the computed metrics to an OpenAI chat model to generate a 3–4 sentence client-friendly performance summary with one risk and one recommendation. Builds a simple HTML report containing the KPIs and AI summary. Emails the HTML report to the client via Gmail and posts a brief confirmation with spend and ROAS to a Slack channel. If the workflow fails, posts an error alert message to an ops Slack channel. Setup Configure authentication for the HTTP requests to Meta Ads (access token), Google Ads (OAuth/access

by Redowan Ahmed Farhan
ACWopenaichatmodel
free

Manage Google and Trustpilot reviews with OpenAI and Slack

Quick overview This workflow runs hourly to fetch new Google Business Profile and Trustpilot reviews, deduplicates them, uses OpenAI via a LangChain agent to draft sentiment-aware replies, escalates negative reviews in Slack, and routes positive replies to Slack for approval before posting the reply back to Trustpilot. How it works Runs every hour on a schedule. Fetches the latest reviews from the Google Business Profile API and the Trustpilot API and combines the results. Deduplicates reviews by tracking previously seen review IDs in workflow static data and stops if there are no new reviews. Processes each new review and uses OpenAI (via a LangChain agent) to generate structured JSON containing sentiment, a draft reply, and an optional suggested resolution. Sends negative reviews to a Slack channel for the owner along with the suggested resolution. Sends positive draft replies to Slack for one-tap approval (with a 24-hour timeout) and, if approved, publishes the reply to the Trustpilot API. Sends a Slack alert to the ops channel if the workflow errors. Setup Configure authentication and replace placeholders for the Google Business Profile reviews endpoint (account and location) i

by Redowan Ahmed Farhan
gmailWwhatsappbusinesscloud
free

Recover abandoned Shopify carts with Gmail, WhatsApp, and Slack alerts

Quick overview This workflow listens for Shopify checkout creations, waits 15 minutes, checks whether the checkout converted into an order, and if not sends a recovery message via Gmail and WhatsApp, while reporting any workflow errors to a Slack channel. How it works Triggers in Shopify when a checkout is created. Waits 15 minutes to give the customer time to complete the purchase. Calls the Shopify Admin Orders API to check whether an order exists for the checkout token. Stops if an order is found, indicating the cart converted. If no order is found, compiles the customer email, phone, cart item summary, discount code, and recovery URL from the Shopify checkout data. Sends a personalized recovery email through Gmail and a recovery message through WhatsApp using the same discount code and checkout link. If the workflow errors at any point, posts the error details to Slack for operational alerting. Setup Connect your Shopify Admin credentials for the Shopify trigger and ensure it can receive the checkouts/create topic. Configure the HTTP request to your store by replacing YOUR_STORE (or ensuring the checkout payload provides domain) and add Shopify Admin API authentication for /adm

by Redowan Ahmed Farhan
Csalesforce
free

Predict Salesforce deal escalation risk with Gemini and Slack alerts

Quick overview This workflow pulls open Salesforce opportunities and their last-30-days activities, uses Google Gemini to predict escalation risk per deal, then flags high-risk opportunities in Salesforce and notifies a Slack user. How it works Starts manually and fetches open opportunities and recent Salesforce Task activities from the last 30 days. Merges opportunities with their related activities and builds a per-deal context including amount, probability, type, activity list, and whether all activities are completed. Batches the deals and skips ones that have 100% probability and active/completed engagement, then waits briefly between remaining items to reduce API load. Sends each deal context to Google Gemini to classify risk (high/medium/low), identify specific risk flags, and return a one-line summary as JSON. Cleans and validates the Gemini response by stripping formatting, parsing JSON safely, and normalizing invalid risk levels to “unknown.” For deals marked as high risk, updates the Salesforce opportunity description with the risk details and sends a formatted alert message to a specified Slack user. Setup Add Salesforce OAuth2 credentials and ensure the workflow has ac

by WeblineIndia
Csheetssalesforce
free

Detect revenue leakage with Salesforce, Google Sheets, Gemini, and Slack

Quick overview This workflow manually audits Closed Won Salesforce opportunities against billed amounts in Google Sheets, uses Google Gemini to analyze any revenue gap, then alerts a Slack user and writes an audit note back to the Salesforce opportunity. How it works Starts when you run the workflow manually. Fetches up to 20 Salesforce opportunities where the stage is "Closed Won" and processes them in batches with a short delay to reduce API pressure. Looks up matching billing rows in Google Sheets and totals the billed amount for the same Deal ID, then calculates the missing revenue versus the Salesforce Amount. For deals with a positive revenue gap, sends the discrepancy details to Google Gemini to classify severity and generate a root cause, recommendation, and Salesforce-ready audit note. Parses the Gemini JSON response and builds a formatted Slack message containing the deal, gap, severity, and recommended action. Sends the Slack alert and updates the Salesforce opportunity description with the audit note and the expected, billed, and missing amounts. Setup Add credentials for Salesforce OAuth2, Google Sheets OAuth2, Google Gemini (PaLM) API, and Slack OAuth2. In Salesforce,

by WeblineIndia
Csheets
free

Monitor ride surge events and analyze ride errors with Sheets, Slack and Gemini

Quick overview This workflow pulls ride events and error records from Google Sheets, detects surge pricing and long waits, and notifies via Slack. For error records, it uses Google Gemini with real-time traffic and weather API lookups to diagnose the issue and send recommended actions to Slack. How it works Runs manually and reads ride records from a Google Sheets spreadsheet. Processes the rows one by one with a short delay and routes each record based on whether its type is an event or an error. For event records, checks if the ride price is more than 1.5× the normal price and the wait time is over 10 minutes. If surge conditions are met, sends a surge and delay notification to Slack and records a surge-alert log entry. If surge conditions are not met, records a normal “no alert needed” log entry. For error records, structures the ride and error context and asks Google Gemini to generate an incident summary, probable cause, and recommended actions, calling traffic and weather APIs as needed. Parses the Gemini response into JSON and posts the formatted error report to Slack. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet and sheet tab in the Google S

by WeblineIndia
CgmailW
free

Draft personalized pre-demo messages from demo bookings with Twain, Gmail, and Slack

Quick overview This workflow triggers on new demo bookings (webhooks or Google Calendar), uses Twain to research the prospect and generate a personalized pre-demo sequence plus an AE brief, drafts the email in Gmail, optionally queues LinkedIn steps in HeyReach, and posts everything to Slack for review. How it works Triggers when a demo booking is received via a webhook (generic, Chili Piper, or HubSpot) or when a new Google Calendar event is created. Normalizes the incoming booking payload into a consistent format, filters to demo meetings only, and de-duplicates repeat bookings across executions. If no LinkedIn URL is provided but an email exists, looks up a LinkedIn profile URL using Findymail and merges it back into the contact. If a usable work email or LinkedIn URL is available, calls the Twain API to generate contact research, an AE pre-demo brief, and a multi-step outbound sequence; otherwise it posts a “skipped” notice to Slack. Builds an email-ready draft (subject and HTML body) plus previews for email and LinkedIn steps from the Twain output. If a work email exists, creates a Gmail draft and posts the brief and draft preview to Slack (or posts a “no draft created” messag

by Mohamed Yahya Chahin
shopify
free

Generate studio and on-model product photos for new Shopify products with Dreem AI

Quick overview This workflow turns every new Shopify product into a complete photo set with Dreem.ai: studio product shots plus an on-model render, generated from one photo and added straight back to the listing. Optional Slack approval before anything goes live. How it works A Shopify webhook fires on every new product. Products without a photo are skipped. The Dreem node renders your chosen shot types from the product's first image (defaults: flat lay + ghost mannequin). The first generated product shot becomes the garment input for the on-model render - a clean studio input instead of your raw upload - on the talent and pose you pick. Each render calls the workflow back when ready. Product shots + on-model shot are appended to the product, keeping existing photos. An optional second row adds back-view shots. Setup Add a Shopify Admin access token credential with read_products and write_products scopes and select it in the Shopify trigger and update nodes. Install the Dreem community node and add a Dreem API key credential (dreem_pk_...) to the Dreem generate nodes. Ensure new Shopify products include at least one image (and a second image if you plan to enable back-shot generati

by Kristian Jønsson
Csheets
free

Route meeting action items to Slack using Gmail, OpenAI, and Google Sheets

Quick overview This workflow watches a Gmail label for new meeting transcript emails, extracts the transcript, uses OpenAI to generate a summary and action items, routes urgent items to the right Slack channel, and logs the meeting and action items to Google Sheets. How it works Triggers every minute when an unread email arrives in Gmail with the label Transcripts. Applies your configured Google Sheets and Slack settings, then extracts meeting metadata and transcript text from the email body. Reads the existing meeting log from Google Sheets and skips processing if the email matches a previously logged message ID or meeting hash. Sends the transcript to OpenAI to produce a JSON analysis including summary, decisions, risks, and structured action items. Parses and normalizes the action items, then routes the result as urgent, standard, or FYI based on priority and due date threshold. Posts a formatted message to the appropriate Slack channel when action items exist, otherwise marks the run as FYI. Appends the meeting record to the Meetings sheet and writes each extracted action item as a separate row in the ActionItems sheet. Setup Connect credentials for Gmail OAuth2, Google Sheets

by Precision Tech
CsheetsW
free

Score LinkedIn job matches with OpenAI, Google Sheets, Slack, and Apify

Quick overview Runs fetch_cat/linkedin-jobs-scraper daily to collect recent LinkedIn jobs, scores each listing against your candidate profile with OpenAI, saves qualified matches to Google Sheets, and sends the five strongest results to Slack without redelivering previously processed job IDs. How it works Runs on a daily schedule (or via manual trigger) and ensures an n8n Data Table exists to track which LinkedIn job IDs have already been delivered. Runs the FetchCat LinkedIn Jobs Scraper (fetch_cat/linkedin-jobs-scraper) through Apify's API using your configured keywords and location, waits for the Actor run to finish, and downloads up to 10 structured job records from its dataset. Normalizes the scraped job records, caps the list to 10 items, and skips any jobs that already exist in the delivery ledger. Sends the remaining jobs to OpenAI in one structured request to score each job against your candidate profile and filters out results below the minimum score. Appends or updates qualified matches in Google Sheets (upserting by LinkedIn job ID) and formats a Slack message containing the five highest-scoring jobs. Posts the digest to your chosen Slack channel and records the deliver

by Hanna Nosova
ACembeddingsopenai
free

Route WhatsApp support requests with Claude, Supabase, HubSpot and Slack

Quick overview This workflow turns incoming WhatsApp messages (text, audio, images, and documents) into actionable support interactions by extracting content, detecting sentiment, and using an AI agent with a Supabase knowledge base to route requests to Google Calendar, HubSpot, Slack, Gmail, and back to WhatsApp. How it works Receives incoming WhatsApp messages via a WhatsApp webhook trigger. Routes the message by type and converts it into text using OpenAI Whisper for audio, OpenAI GPT-4o Vision for images, or a PDF extractor for documents (or passes text messages through). Loads the sender’s session context from Supabase and runs sentiment/language detection on the extracted text. Uses a LangChain AI agent (Claude) with Supabase vector search (with OpenAI embeddings and Cohere reranking) plus tool access (Google Calendar, HubSpot, Slack, and Gmail) to produce a structured intent, response, and metadata. Logs conversation analytics (intent, sentiment, message type, and response length) to an n8n Data Table. Routes by intent to either create a Google Calendar event, create/update a HubSpot contact, email a document via Gmail (and upload it to Google Drive), create a HubSpot ticket

by Multifly
CsheetsW
free

Calculate Shopify variant prices from Google Sheets with Slack approvals

Quick overview Video Explanation: https://youtu.be/_geRatkc1kU?si=qALW_nrPrNB4THuO This workflow runs daily to calculate Shopify variant prices from Google Sheets COGS inputs, automatically updates qualifying prices in Shopify, and posts Slack alerts for changes that need manual approval; it also supports Slack-based approvals to apply a proposed price from a Slack thread. How it works Runs every day on a scheduled trigger. Reads product dependency/recipe data from Google Sheets and looks up the latest supplier prices in a second Google Sheets sheet. Calculates raw COGS, landed COGS (with hidden cost percentage), and a target-margin retail price for each Shopify variant. Checks the calculated price against thresholds and either updates the Shopify variant price via the Shopify Admin API or posts an approval-required alert to Slack. Posts a Slack confirmation message when a scheduled Shopify price update succeeds. Triggers on Slack reaction events, verifies an authorized Slack user approved the change, then fetches the Slack thread replies and extracts the variant ID and approved price. Updates the Shopify variant price with the extracted value and posts a final status message to Sl

by iamvaar
CWnotion
free

Post a daily project health standup to Slack with Notion and Groq

Quick overview This workflow runs every morning, reads yesterday’s standup and today’s active projects from Notion, uses Groq (OpenAI-compatible chat completions) to generate a red/yellow/green project health standup, posts it to Slack, and saves the new standup back to Notion for tomorrow. How it works Runs every day at 7:30 AM on a schedule. Reads the previous standup digest from a Notion “memory” database row and fetches all “Active” projects from a Notion projects database. Builds a prompt that includes yesterday’s digest plus today’s project notes, last update dates, and next milestone dates. If there are no active projects, posts an “All quiet” message to a Slack channel. If there are active projects, sends the prompt to Groq’s chat completions endpoint to score projects as Red/Yellow/Green and list changes since yesterday. Posts the generated standup text to Slack and updates the Notion memory row with today’s digest and timestamp. Setup Add a Notion credential and set the database IDs for your Projects database and the single-row Memory database used to store the daily digest. Create a Groq API header-auth credential (Authorization: Bearer ) for the Groq chat completions re

by Kevin Yu
Cgmailgooglecalendarsheets
free

Calculate litigation deadlines from intake forms with Google Calendar, Sheets, Slack and Gmail

Quick Overview This workflow collects litigation matter intake details via an n8n form, calculates limitation and procedural deadlines using a built-in rules table, then creates deadline and reminder events in Google Calendar, logs each deadline to Google Sheets, and sends a summary via Slack and Gmail. How it works Receives a submission from an n8n form with the matter details, jurisdiction, claim type, and trigger dates. Loads the configured limitation rules, procedural rules, holidays, reminder offsets, and target Google Calendar/Google Sheets/Slack/email settings. Calculates limitation and procedural due dates (and any review notes) from the provided dates, rolling deadlines off weekends/holidays and generating reminder dates. Appends each calculated deadline record to a Google Sheets register. Creates an all-day Google Calendar event for each calculated deadline and separate all-day events for each upcoming reminder offset. Posts a consolidated deadline summary to a Slack channel and emails the same summary via Gmail to the responsible lawyer (or a fallback team email). Setup Connect credentials for Google Calendar, Google Sheets, Slack, and Gmail. In the rules/settings step,

by Kevin Yu
shopify
free

Create on-model Shopify product photos with Dreem AI and Slack approvals

Quick overview This workflow fires when a new Shopify product is created, renders it on a virtual model with Dreem.ai, and appends the shot back to the product - with optional Slack posting and approval. How it works A Shopify webhook fires when a product is created. Products without a photo are skipped. The Dreem node renders the product's first image on your chosen virtual model and pose (400+ talents, 700+ poses). A second product image is used as the back reference for accurate back-facing renders. Dreem renders in the background and calls the workflow back. Optional: enable the disabled Slack nodes for an Approve / Reject step before anything goes live. The on-model shot is appended to the Shopify product, keeping existing photos. Setup Add a Shopify Admin API access token credential with at least read_products and write_products scopes. Install the Dreem community node and add a Dreem API key credential (dreem_pk_...). In the Dreem step, set the talentId and shotCodes you want to use and ensure your products include a front image (and optionally a second image for back reference). (Optional) Add a Slack OAuth2 credential, enable the disabled Slack steps, and select the target

by Kristian Jønsson
CgoogledrivesheetsW
free

Build a sound effect library with Google Sheets, ElevenLabs, Google Drive and Slack

Quick overview This workflow runs manually or every 15 minutes to read queued sound-effect prompts from Google Sheets, generate MP3s via the ElevenLabs sound-generation API, upload them to Google Drive, update each row with status and a file link, and post a run recap to Slack. How it works Runs manually or on a 15-minute schedule. Reads all rows from a Google Sheets tab and selects a capped batch where Status is blank or Queued and Description is present, clamping DurationSeconds and PromptInfluence to valid ranges. Sends each selected Description to the ElevenLabs sound-generation API to generate an MP3 file. Uploads the returned MP3 to a specified Google Drive folder using a deterministic filename based on the sheet row. Updates the matching Google Sheets row to Done with the Google Drive link and timestamp, or to Failed with error notes and timestamp if generation or upload fails. Counts how many rows succeeded or failed in the run and posts a one-line recap message to a selected Slack channel. Setup Add an ElevenLabs HTTP Header Auth credential (xi-api-key) and select it in the ElevenLabs request step. Connect Google Sheets OAuth2 credentials and set the spreadsheet and sheet

by Kevin Yu
Ccryptodiscordsheets
free

Send LemonSqueezy subscription alerts to Slack, Discord, Telegram and log them in Google Sheets

Quick overview Get an alert in Slack, Discord or Telegram within seconds every time a LemonSqueezy subscription is created, cancelled, expires or a payment fails, plus a running log of every event in Google Sheets. How it works Receives a POST webhook from LemonSqueezy with the raw request body. Computes an HMAC signature for the raw body and compares it to LemonSqueezy’s x-signature header, stopping if they don’t match. Parses the webhook JSON and extracts the event name from the headers or payload metadata. Normalizes subscription and payment payloads into flat fields like customer email, product, plan, status, amount, and currency. Appends the normalized event to Google Sheets as an event log. If the event is not subscription_updated, sends an alert message to Slack, Discord, and/or Telegram with the key event details. Setup In LemonSqueezy, create a webhook pointing to this workflow’s Production webhook URL and set a signing secret. Configure the Crypto credential/secret used for the HMAC calculation so it matches your LemonSqueezy webhook signing secret exactly. Set up at least one alert destination: connect Slack OAuth and choose a channel, or provide a Discord webhook URL, o

by Mark Kato
BCgmailsheets
free

Track asset warranty deadlines with Google Sheets, Gmail, Todoist, Slack, and OpenAI

Quick overview This workflow runs daily to read an asset register from Google Sheets, calculate warranty expiry dates, and escalate upcoming deadlines via Gmail, Slack, and Todoist, while using OpenAI to draft vendor negotiation emails for high-value assets and updating expired items back in the sheet. How it works Runs every day at 08:30. Reads all assets from a Google Sheets register and calculates each item’s warranty expiry date and days remaining from the purchase date and warranty months. For already-expired assets, updates the Google Sheets register to set the status to “warranty expired.” For assets expiring within 7 days, posts an urgent Slack message and creates a Todoist task due on the warranty expiry date. For assets expiring within 30 days, emails the asset owner via Gmail asking them to choose whether to extend, replace, or let the warranty lapse. For 30-day warnings where the asset value is at least 2000, uses OpenAI to draft a vendor warranty-extension negotiation email and saves it as a Gmail draft for review. Setup Create a Google Sheets asset register with columns for asset, owner_email, purchase_date, warranty_months, vendor, value, and status. Add credentials

by kenta
ACW
free

Triage network read and commit requests with Slack, Anthropic, and pyATS

Quick overview This Slack ChatOps workflow uses AI agents and a pyATS MCP server to handle day-to-day data network housekeeping tasks: from on-demand checks and validations per device, to configuration change proposals that require human approval before commit. Read the docs here: https://cs.co/9004BEMGZm How it works A network engineer mentions the Slack bot in a channel or thread. The workflow acknowledges the request and captures the full message The request is sent to a Planning Agent connected to pyATS through read-only MCP tools. The agent determines whether the user wants operational data or a configuration change, gathers live device evidence if needed, and evaluates whether the request is safe. If the request is operational only, or if the proposed change is unsafe, the workflow replies in the same Slack thread with a clear technical summary, including the relevant device findings or the reason why no change will be made. If the request is a safe configuration change, the workflow creates one approval card per target device. Each card shows the proposed change, the pre-check evidence collected from the device, and the safety rationale so the engineer can review exactly wha

by Poncho Sandoval