Skip to content
FlowHubFluxonLab

Code workflow'ları

1.006 sonuç — tümü kaynağa bağlı n8n referansı

CsheetsW
free

Generate weekly Pinterest content opportunity briefs with Apify, OpenAI and Google Sheets

Quick overview Research a Pinterest niche with FetchCat's Pinterest Search Scraper, preserve every source pin in Google Sheets, and use one evidence-controlled OpenAI call to identify recurring themes, underrepresented angles, and five production-ready content briefs without claiming search volume or trend growth. How it works Starts manually with one research niche and one to five exact Pinterest search phrases, plus locale, country, and a configurable result limit. Runs fetch_cat/pinterest-search-scraper through a Cloud-compatible HTTP Request and collects 20 to 500 public pins per search with public detail enrichment enabled. Validates, normalizes, and deduplicates returned pins. It stops before AI or destination writes when fewer than ten usable pins remain. Builds stable Google Sheets rows, deterministic phrase counts, and a bounded evidence packet, then uses one structured gpt-5.4-mini request for analysis. Removes invalid pin citations and rejects any finding that retains no supplied evidence, preventing unsupported recommendations from reaching the destination. Upserts source pins and a readable brief into separate Pins and Research Brief tabs using stable same-day research

Hanna Nosova tarafından
BCgmailsheets
free

Find and verify business emails with ScraperCity, OpenAI, Google Sheets, and Gmail

Quick overview This workflow reads contacts from Google Sheets, finds and verifies their business emails via the ScraperCity Email Finder API, generates a short personalized icebreaker with OpenAI, appends the enriched leads to another Google Sheet, and emails a run summary via Gmail. How it works Starts manually to run an email enrichment job. Reads contacts (first name, last name, domain) from an input Google Sheets worksheet and aggregates them into a single payload. Submits the contacts to the ScraperCity Email Finder API, then waits and repeatedly checks the job status until it succeeds or fails/times out. When the job succeeds, downloads the result CSV from ScraperCity, parses it, normalizes key fields (name, domain, email, verification status, provider), and keeps only rows with an email. For each verified contact, prompts OpenAI to generate one short, company-referencing cold-email opening line in the configured language. Appends the enriched lead (including email, status, and icebreaker) to an output Google Sheets worksheet and sends a summary email via Gmail. Setup Create a ScraperCity account with Email Finder credits and add an HTTP Header Auth credential that sends you

Dr. Firas tarafından
Cgmailgoogledocssheets
free

Turn support emails into FAQ drafts with Gmail, OpenAI, Sheets and Docs

Quick overview This workflow monitors a Gmail inbox for new support-style emails, uses OpenAI to extract a reusable FAQ question and safe draft answer, logs results to Google Sheets, and then creates a Google Docs draft and/or Gmail review drafts for a human reviewer. How it works Polls Gmail every 5 minutes for unread emails matching the configured support-related search query. Cleans the email content by stripping quoted replies, signatures, and HTML to produce a concise plain-text body. Sends the cleaned email and product context to OpenAI to extract a structured FAQ candidate (question, draft answer, category, score, sensitivity flag, tags, and recommended action). Calculates a routing status based on the FAQ score threshold and sensitivity/recommended action, and prepares draft text for a Google Doc and reviewer email. Appends every processed email and extracted fields to a Google Sheets tab for tracking and reporting. If the candidate is strong, creates a Google Docs FAQ draft, inserts the draft content, and creates a Gmail draft notification to the reviewer with the document link. If the candidate needs manual handling, creates a Gmail draft to the reviewer with the review n

Dr. Firas tarafından
CW
free

Draft and stage LinkedIn re-engagements with HeyReach, Twain, and Slack

Quick overview This workflow runs weekly (or manually) to pull tagged “cold” HeyReach conversations, uses Twain to draft context-aware re-engagement messages, then stages leads in a HeyReach list and notifies Slack for review while tagging processed leads to avoid duplicates. How it works Runs on a weekly schedule or via a manual trigger. Fetches all conversations from the HeyReach Inbox API using pagination. Filters conversations by HeyReach lead tags (include tags like “Cold”/“Not interested” and exclude tags like “Re-engaged”) and extracts each lead’s LinkedIn URL, name, and prior message thread. Sends the conversation context to Twain to generate a re-engagement sequence draft and add the contact to the specified Twain campaign. Adds the lead to a HeyReach re-engagement list and stores the first Twain draft message in a custom user field. Posts the drafted re-engagement message to a Slack channel for review. Tags the lead as “Re-engaged” in HeyReach to prevent reprocessing. Setup Add HeyReach API credentials for HTTP Header Auth and ensure the header matches HeyReach requirements (for example, X-API-KEY). Add Twain API credentials for HTTP Header Auth and ensure the header matc

Mohamed Yahya Chahin tarafından
CsheetsW
free

Monitor ad campaign health daily with Spendict, Google Sheets, and Slack

Quick overview This workflow runs every morning to read ad campaign metrics from Google Sheets, send each campaign to Spendict for performance diagnosis against benchmarks, log the verdicts back to Google Sheets, and post Slack alerts when a campaign needs attention. How it works Runs daily at 08:00 on a schedule trigger. Reads campaign metric rows from a Google Sheets spreadsheet. Builds a Spendict request per campaign by normalizing platform/objective fields and including only numeric metrics present in each row. Sends each campaign’s metrics to the Spendict analyze-performance API to get a verdict, score, bottleneck, and diagnosis. Routes results by verdict so healthy or insufficient-data campaigns are only logged, while fix_first and kill_or_rebuild campaigns are also prepared for alerting. Appends a dated health-check row for every campaign to a Google Sheets “health log” sheet. Posts a Slack Incoming Webhook message for fix_first and kill_or_rebuild campaigns including the score, primary bottleneck, and diagnosis. Setup Add Google Sheets credentials and select the document and sheet for both reading campaign metrics and appending to the health log. Ensure your metrics sheet h

Spendict tarafından
CW
free

Draft incident postmortems with PagerDuty, Confluence, Slack and Google Sheets

Quick overview This workflow creates a Confluence postmortem draft for resolved PagerDuty incidents, then notifies the incident owner in Slack and optionally logs the draft in Google Sheets. How it works Triggers manually for testing or receives a PagerDuty webhook when an incident is resolved. Loads shared configuration values like PagerDuty and Confluence URLs, Confluence space and parent page, Slack channel, and optional Google Sheets settings. Normalizes the incoming incident payload and fetches the incident details and log entries from the PagerDuty API. Builds an HTML postmortem draft containing an incident summary, placeholders for impact and root cause, a basic timeline, and action-item prompts. Creates a new Confluence page under the configured parent page using the generated postmortem content. Posts a Slack message to the configured channel and optionally appends a row to a Google Sheets “Postmortems” tab with key incident metadata. Setup Add PagerDuty API credentials to the PagerDuty HTTP Request steps and configure a PagerDuty webhook pointing to this workflow’s webhook URL for resolved incidents. Add Confluence (Atlassian) credentials and set your Confluence base URL,

Dyogo Henrique de Oliveira Ortega tarafından
CW
free

Analyze URLs and extract SEO metadata with forms and HTTP requests

Quick Overview This workflow collects a URL via an n8n Form, follows HTTP redirects to the final destination, extracts page and Open Graph/Twitter metadata from the final HTML, and displays the results back in a form response using only built-in n8n nodes. How it works Receives a URL submission from the n8n Form trigger. Normalizes the input so it includes an http/https scheme. Requests the URL with redirect-following disabled to capture the HTTP status and Location header. If the response is a redirect (301/302/307/308), tracks visited URLs and redirect count, detects loops or exceeding the redirect limit, and either continues to the next Location URL or shows a redirect/loop error. If the response is 200 OK, parses the HTML to extract the title, meta description, canonical URL, language, Open Graph tags, Twitter Card tags, and common tracking parameters. Displays the extracted metadata and final URL in a results form, then redirects back to the input form page. Setup Activate the workflow so the n8n Form trigger has a Production URL. Copy the Form trigger Production URL and paste it into the Set URL value to replace REPLACE_WITH_PRODUCTION_FORM_URL so the completion step redirect

EximiaAI tarafından
Cgmail
free

Send quote PDFs from form submissions with Acrewity and Gmail

Quick overview This workflow collects quote requests via an n8n Form, generates a styled PDF quote using Acrewity, emails it to the prospect through Gmail, and automatically sends a follow-up email after a configurable delay. How it works Receives a new quote request submission through the built-in n8n Form. Applies your company and follow-up settings (company name, sender name, quote validity, and delay) to the submission data. Builds an HTML quote that includes a generated quote number, validity date, and the requester’s details. Converts the HTML into a PDF using Acrewity and prepares it as an email attachment. Sends the quote PDF to the requester via Gmail with the quote number and validity date in the subject and body. Waits the configured number of days and then sends a Gmail follow-up email referencing the same quote. Setup Install the community node @acrewity/n8n-nodes-acrewity and add an Acrewity API credential. Add a Gmail credential with permission to send email from the account you want to use. Update the workflow configuration values (company name, sender name, quote validity days, follow-up delay days, and any notes) to match your business. Activate the workflow and s

Acrewity tarafından
ACW
free

Generate sales research briefs from Google Sheets with Claude and Slack

Quick overview This workflow polls a Google Sheets prospect queue, researches each new company via SerpAPI and enrichment/contact APIs, then uses Anthropic Claude to generate a structured sales brief and outreach draft, logs the result back to Google Sheets, marks the prospect as researched, and notifies a sales rep in Slack. How it works Runs every 15 minutes and reads rows from the Prospects tab in Google Sheets. Filters for prospects with Status set to "New" and processes each prospect as an individual item. Researches each prospect in parallel by pulling recent news via SerpAPI, company funding/technology data via a company enrichment API, and decision-maker contacts via a people data API. Combines the research signals into one profile per prospect and calculates a priority score and a research completeness score. Skips prospects with insufficient data and sends the rest to Anthropic Claude to generate a JSON sales brief and first-touch outreach message. Appends the brief to the SalesBriefs tab in Google Sheets, updates the original prospect’s Status to "Researched", and posts a summary plus the draft message to Slack via an incoming webhook. Setup Create a Google Sheets OAuth2

Oneclick AI Squad tarafından
Csheetssalesforce
free

Score Salesforce playbook compliance with Google Sheets, Gemini, and Slack

Quick overview This workflow manually runs to review Salesforce opportunities listed in Google Sheets, evaluates each deal against sales playbook rules using Google Gemini, updates compliance fields in Salesforce, alerts in Slack for low scores, and logs results back to Google Sheets. How it works Starts manually and loads a list of opportunities from Google Sheets. Processes each row in batches and fetches the latest matching Opportunity record from Salesforce. Adds predefined playbook rules (including a passing score) and combines them with the opportunity data. Checks whether at least two meetings are completed, and if not, auto-generates a non-compliant evaluation without using AI. For opportunities that pass the meeting minimum, sends the opportunity details and rules to Google Gemini to produce a compliance decision, missing steps, score, reason, and risk level, then normalizes the response into structured fields. Updates the Opportunity in Salesforce with compliance status, risk, score, and timestamp, and sends a Slack alert when the compliance score is below 70. For compliant opportunities, writes the final status and compliance metrics back to a Google Sheets results tab (

WeblineIndia tarafından
ACgmailsheets
free

Route procurement helpdesk tickets from Gmail with Groq and Slack

Quick Overview This workflow monitors a Gmail inbox for procurement requests, uses Groq (Llama 3.1) to classify and route each ticket with SLA logic, escalates high-risk items to Slack, creates a ticket via HTTP, sends an auto-reply from Gmail, and logs the full record to Google Sheets. How it works Triggers every minute when a new email arrives in a Gmail inbox. Extracts the sender, subject, body, timestamps, and Gmail thread/message IDs, and generates a procurement ticket ID. Looks up the email thread ID in Google Sheets to identify whether the request already exists. Uses Groq (Llama 3.1) to classify the request (category, urgency, sentiment, risk, team) and applies routing rules to set SLA deadlines, queues, and escalation flags. If escalation is required, posts a detailed alert to a Slack channel and creates an escalated ticket via an HTTP request; otherwise, creates a standard ticket via an HTTP request. Generates a short agent-facing status summary with Groq, emails the customer an acknowledgement and suggested reply via Gmail, and appends the full ticket and AI outputs to Google Sheets. Setup Connect your Gmail OAuth2 credential for both the inbox trigger and the customer a

WeblineIndia tarafından
ACgmailsheets
free

Detect early payment invoice opportunities with Groq and Google Sheets

Quick Overview This workflow runs daily to fetch invoice data from an HTTP endpoint, calculate early-payment savings and annualized ROI, and use Groq (Llama 3.3) to prioritize eligible discounts. It logs eligible and expired invoices to Google Sheets and emails a digest of HIGH-priority recommendations via Gmail. How it works Runs every day at 9:00 to start an invoice scan. Fetches invoice records from an external HTTP API endpoint. Calculates potential savings, days saved by paying early, annualized ROI, and whether each invoice is still eligible before the discount deadline. Routes eligible invoices to Groq (Llama 3.3) to return a JSON decision with a YES/NO recommendation, HIGH/MEDIUM/LOW priority, and a short reason, then normalizes the AI response. Appends eligible invoice evaluations (including ROI, savings, priority, recommendation, and reason) to a Google Sheets log. Filters for invoices marked YES and HIGH priority, aggregates them into a daily batch, and emails a plain-text digest to the finance team via Gmail. Marks ineligible invoices as expired with a skip reason and appends them to a separate Google Sheets audit log. Setup Add a Groq API credential and ensure the sele

WeblineIndia tarafından
ACgmailsheets
free

Triage supplier capacity risk with Groq, Gmail, Slack, and Google Sheets

Quick overview This workflow runs daily to pull supplier performance data from an HTTP endpoint, calculate fulfillment and delay risk metrics, use Groq (Llama 3.3) to classify supplier risk and generate mitigation actions, then notify via Gmail and Slack and log outcomes to Google Sheets. How it works Runs every day at the scheduled time. Fetches supplier performance data from an HTTP API and stops if the supplier has no orders. Normalizes the supplier fields and calculates fulfillment rate, delay, rule-based flags, and a risk score. Sends the metrics to Groq (Llama 3.3) to classify risk (Low/Medium/High) with a reason and confidence, then merges the AI result with the computed metrics (falling back to the rule-based classification if parsing fails). If the AI risk is Medium, Groq generates three mitigation actions and the workflow fetches backup supplier options from an HTTP API, then combines both into a single alert payload. Sends the mitigation actions by Gmail email and Slack message, then appends a “high risk” audit row to Google Sheets. If the AI risk is not Medium, appends a “no alert sent” audit row to Google Sheets with the assessed risk details. Setup Add Groq API creden

WeblineIndia tarafından
ACembeddingsopenaiopenaichatmodel
free

Handle WhatsApp sales inquiries with OpenAI, Pinecone, Google Calendar, and Slack

Quick overview This workflow handles inbound WhatsApp Business messages with an OpenAI-powered sales agent that uses Pinecone RAG for product answers and Google Calendar tools for scheduling, then either replies on WhatsApp or hands the conversation to Slack, with Slack-based error alerts. How it works Triggers on every inbound WhatsApp Business message and checks whether the payload contains a text body. Drops non-text messages (such as images or voice notes) and continues only with text conversations. Uses an OpenAI chat model with per-customer session memory to generate a concise sales reply and decide whether a human handoff is needed. Lets the agent query a Pinecone-backed product catalog via OpenAI embeddings to answer pricing, specs, and availability questions. Lets the agent check availability and book appointments in Google Calendar when the customer requests scheduling. Parses the agent’s HANDOFF flag and either posts the customer message plus draft reply to a Slack channel or sends the reply back to the customer on WhatsApp. Sends a Slack alert to an ops channel if any step in the workflow fails. Setup Connect WhatsApp Business Cloud credentials and set the WhatsApp Phon

Redowan Ahmed Farhan tarafından
ACW
free

Verify loan documents and score eligibility with Claude and Google Sheets

Quick overview This workflow receives loan applications via webhook, uses Anthropic Claude to verify document text and generate an underwriting recommendation, calculates an explainable risk score in code, logs each application to Google Sheets, and sends decision emails through SendGrid before returning a JSON response. How it works Receives a loan application via a POST webhook, including applicant details and extracted text from ID, income proof, and bank statement documents. Uses Anthropic Claude to extract key fields from the documents and cross-checks them against the applicant’s declared name, employer, and income to produce a verification score and inconsistency list. Stops early and returns a “Documents Insufficient” webhook response when the verification score is below the threshold. Calculates verified income, estimated monthly installment, debt-to-income and loan-to-income ratios, and a weighted 0–100 risk score and tier from credit score, ratios, employment tenure, bank health, and document consistency. Waits briefly, then uses Anthropic Claude to generate an eligibility recommendation (Approve, Conditional Approval, Manual Review, or Decline) with reasoning, condition

Oneclick AI Squad tarafından
Cgmailgooglebigquerygooglecloudfirestore
free

Draft personalized welcome emails for new signups with Twain, Gmail, and Slack

Quick overview This workflow receives new signup events, enriches each contact with Twain (and optionally a LinkedIn lookup), drafts a personalized welcome email in Gmail, and posts review-ready previews to Slack, with optional LinkedIn-step handoff to HeyReach. How it works Receives a new signup via a POST webhook secured with header authentication (with optional disabled schedule-based backfills from Google BigQuery or Google Firestore). Normalizes the signup fields (email, name, UID, timestamps, LinkedIn URL) and de-duplicates signups by UID across workflow executions. If the signup has no LinkedIn URL but does have an email, looks up a LinkedIn profile URL via Findymail (or other disabled provider alternatives) and merges the resolved profile back into the contact. If the contact has a usable work email or LinkedIn URL, calls the Twain Generate Sequence API to research the person and generate a personalized welcome sequence, otherwise posts a “skipped” notice to Slack. Builds a formatted draft payload and previews (email steps vs LinkedIn steps) from the Twain response, including any warning flags and a link back to the lead in Twain. If a work email is available, creates a Gma

Mohamed Yahya Chahin tarafından
ACgmailgoogledrive
free

Create a Gmail morning audio briefing with Google Gemini and Google Drive

Quick Overview This workflow runs every weekday at 7 AM to fetch up to 10 unread Gmail messages from the last day, summarize them into a narrated script with Google Gemini, convert the script to an MP3 using Smallest.ai, upload it to Google Drive, and email you a public listening link. How it works Runs on a schedule every weekday at 7:00 AM. Pulls up to 10 unread Gmail emails from the last 24 hours. Cleans and categorizes the emails into URGENT, NEWSLETTERS, and OTHER sections while skipping common job-alert style messages. Uses a LangChain AI Agent powered by Google Gemini to turn the digest into a plain-text morning briefing script. Truncates the script to a safe character limit and converts it to speech as an MP3 with Smallest.ai. Uploads the MP3 to Google Drive, makes the file publicly readable, and sends a Gmail message with the listening link and the script text. Setup Connect your Gmail credentials for both reading unread emails and sending the briefing email, and update the recipient address in the outgoing email step. Add Google Gemini credentials in the Google Gemini Chat Model used by the AI Agent. Add your Smallest.ai API credentials for text-to-speech generation. Conn

nStack. tarafından
CW
free

Draft security questionnaire answers with Notion, Google Docs, and Slack

Quick overview This workflow runs on demand to match security questionnaire questions against an approved-answer library in Notion, then creates a Google Docs draft and notifies reviewers in Slack, optionally updating a Notion tracker page. How it works Starts manually to run a test questionnaire and load configuration values like the Notion database ID, Google Drive folder ID, and confidence threshold. Loads a list of questionnaire questions and queries the Notion database for answers whose Status equals the configured approved value. Compares each questionnaire question to the approved Notion questions, selects the closest match, and marks low-confidence matches as “Needs review” instead of auto-answering. Branches based on whether any answers need review and posts a corresponding Slack notification to the configured review channel. Builds a formatted draft body containing each question, match confidence, owner, and either the approved answer or a “Needs review” placeholder. Creates a new Google Docs document for the draft and optionally updates a Notion questionnaire tracker page with “Draft ready for review” and the needs-review count. Setup Add Notion credentials and set the a

Dyogo Henrique de Oliveira Ortega tarafından
ACgoogledrive
free

Create narrated blog audio from RSS with Google Gemini, Smallest.ai and WordPress

Quick Overview This workflow polls a blog RSS feed, rewrites new posts into a spoken-word script using Google Gemini, generates an MP3 with Smallest.ai, uploads it to Google Drive, and updates the matching WordPress post to embed a public audio player. How it works Polls an RSS feed every minute to detect newly published or updated blog items. Extracts the post body and strips HTML, scripts, styles, and common entities to produce clean plain text. Uses Google Gemini to rewrite the text into a single, conversational narration script with an intro/outro and length limits. Sends the rewritten script to Smallest.ai to synthesize an English MP3 audio file. Uploads the MP3 to Google Drive and updates sharing so anyone with the link can play it. Updates the corresponding WordPress post to embed an HTML5 audio player pointing to the Google Drive link and includes the article text below it. Setup Set the RSS feed URL in the RSS Feed Trigger node and confirm the feed provides the fields used for the post content and GUID. Add credentials for Google Gemini (Google AI / Gemini) and select that connection in the chat model used by the rewrite step. Add your Smallest.ai API credentials and verif

Zain Khan tarafından
ACgmailgoogledrive
free

Qualify leads and send personalized audio follow-ups with Gemini and Smallest.ai

Quick Overview This workflow receives lead submissions via a webhook, uses Google Gemini to qualify the lead and write a personalized spoken follow-up script, and for qualified leads generates an MP3 with Smallest.ai, shares it from Google Drive, emails it via Gmail, logs outcomes to Google Sheets, and alerts sales in Slack. How it works Receives a POST webhook request containing a lead’s name, email, and message. Sends the lead details to a Google Gemini–powered AI agent to determine whether the lead is qualified and, if so, generate a short personalized audio script. Parses the agent’s JSON response and routes the workflow based on the qualified flag. If the lead is qualified, Smallest.ai synthesizes the script into an MP3 and uploads it to Google Drive. Shares the Google Drive audio file publicly and sends the lead a Gmail message with a link to listen. Appends the qualified lead record (including the audio link and timestamp) to Google Sheets and posts a notification to a Slack channel. If the lead is unqualified, appends the lead details and timestamp to Google Sheets without generating audio or sending email. Setup Enable the webhook and copy the generated /lead-capture URL i

Zain Khan tarafından
CgmailsheetsW
free

Send Calendly meeting prep briefs with Gmail, Notion, OpenAI and Sheets

Quick Overview This workflow monitors Gmail for Calendly “New Event” emails, extracts meeting details with OpenAI, enriches the invitee with Notion CRM data, Google Sheets STR records, and SerpApi building research, then generates and schedules a meeting-prep brief email to send 30 minutes before the meeting. How it works Triggers every minute when a new Gmail message arrives and continues only if it is a Calendly notification for a new event. Uses OpenAI to extract the invitee email and meeting date/time from the email and calculates a send time 30 minutes before the meeting. Looks up the lead in a Notion database by invitee email and pulls building research via SerpApi, then uses OpenAI to extract building details from the AI Overview results. Loads STR registration data from Google Sheets and matches it to the building address to flag whether the property appears in STR records. Searches recent Gmail history in two accounts for messages involving the lead’s email address and checks whether any history exists. If email history exists, uses OpenAI to summarize the relationship and generate a concise meeting brief, then formats it as an HTML email. If no email history exists, uses

Marc Soummer tarafından
CfacebookgraphapiW
free

Flag Meta ad creative fatigue with Facebook Graph API and send ranked reports to Slack

Quick overview This workflow runs every morning, pulls 14 days of daily ad-level insights from the Meta (Facebook Graph) API, detects creative fatigue by comparing yesterday’s CTR to each ad’s own historical average, and posts a ranked fatigue report to Slack via an incoming webhook. How it works Runs daily on a cron schedule (default 10:00). Loads configuration values such as the lookback window and fatigue thresholds. Retrieves daily ad-level insights from the Meta (Facebook Graph) API for the configured ad account, including CTR, spend, and impressions. Calculates each ad’s CTR drop by comparing yesterday’s CTR to that same ad’s average CTR across prior running days that meet minimum spend and impression thresholds, then labels ads as WARN/WATCH/OK/NEW and ranks the biggest drops. Sends a formatted, monospaced Slack message containing the ranked table and summary counts to your Slack channel using an incoming webhook. Setup Create or connect Facebook Graph API credentials with access to the target Meta ad account. Set environment variables for META_AD_ACCOUNT_ID (your act_… ID) and SLACK_WEBHOOK_URL (your Slack incoming webhook URL). Review and adjust the thresholds in the Confi

Nocode Expert tarafından
Cyoutube
free

Clean duplicate and dead YouTube playlist videos with Slack reports

Quick overview This workflow runs weekly to scan a YouTube playlist, flagging deleted/unavailable/private videos and duplicate entries, optionally removing them from the playlist, and posting a cleanup report to a Slack channel. How it works Runs every week on a schedule trigger. Loads the target YouTube playlist ID, the dry-run toggle, and the Slack channel ID. Retrieves all items from the specified YouTube playlist and looks up each referenced video’s status. Classifies each playlist item as active or dead (deleted/unavailable/private) and flags duplicates by video ID while keeping the first occurrence. If dry run is disabled, deletes the flagged playlist items from YouTube in batches. Builds a summary of what was found/removed and posts the report to the configured Slack channel. Setup Connect a YouTube (Google) OAuth2 credential with permissions enabled to read playlists and delete playlist items as needed. Connect a Slack credential with permission enabled to post messages to your chosen channel. Set your playlistId, slackChannelId, and (optionally) dryRun in the workflow options before turning on the workflow. Requirements A Google account with YouTube access and an OAuth2 cr

Kevin Yu tarafından
Csheetsyoutube
free

Unpublish expired YouTube videos using Google Sheets and Slack

Quick Overview This workflow runs daily and checks a Google Sheets embargo schedule for YouTube videos whose unpublish date has passed, then updates their privacy status on YouTube and logs the result back to the sheet while sending a recap (or “nothing due”) message to Slack. How it works Runs every day at 6am on a schedule trigger. Reads your embargo control spreadsheet from Google Sheets. Selects videos whose “Unpublish Date” is today or earlier (using a configured timezone), skips rows already marked Expired, and defaults the target privacy status to private when missing. For each due video, fetches the current video snippet and status from YouTube. If the video is not already at the target privacy status, updates the video on YouTube to private or unlisted while preserving its existing title and category. Updates the matching row in Google Sheets to Status = Expired and writes an “Unpublished At” timestamp, then posts a Slack recap of the processed videos. If no videos are due, posts a “nothing due” notice to the configured Slack channel. Setup Add a YouTube (Google) OAuth2 credential with permission to read and update videos, and select it in both YouTube steps. Add a Google

Kevin Yu tarafından