Skip to content
FlowHubFluxonLab

Code Workflows

1.006 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen

CsheetsW
free

Generate and score Google Maps leads with Gemini, Apify, and Google Sheets

Quick overview Youtube Video:https://youtu.be/NGruDecKxAg?si=ot9pj6IN4IoLstow This workflow takes a chat-based search request, scrapes matching businesses from Google Maps using Apify, scores and ranks them with Google Gemini, deduplicates against an existing Google Sheet by placeId, saves new leads to the sheet, and returns a formatted results message to the chat. How it works Receives a message from an n8n chat trigger containing the user’s Google Maps lead search request. Sends the request to Google Gemini to extract structured search parameters (business type, location, max results, and output mode). Calls an Apify Google Maps scraping actor with the extracted parameters and selects a clean set of lead fields from the results. Removes duplicate businesses based on Google Maps placeId and batches the remaining leads into a single list. Sends the lead list to Google Gemini to add a 0–100 score and short reason to each lead and returns them sorted by score. Checks the scored leads against existing rows in Google Sheets and filters out any placeId values that are already saved. Appends or updates the new leads in Google Sheets and returns a formatted ranked lead list back to the ch

von iamvaar
CW
free

Track data deletion requests from Gmail with Jira, BigQuery, and Slack

Quick Overview This workflow monitors a Gmail inbox for potential privacy/data deletion requests, classifies each email, creates the appropriate Jira issue, logs a minimal audit record to BigQuery, and alerts the team in Slack, with an optional Gmail confirmation draft for human review. How it works Triggers when a new email matching deletion-related keywords arrives in Gmail (or runs manually for testing). Loads shared configuration values like Jira project details, BigQuery destination, SLA window, Slack channel, and confidence threshold. Cleans the email text, extracts the requester address, classifies the request type (deletion/access/correction), and calculates an SLA due date with a confidence score. Creates a Jira task for the privacy team when the classification is confident, or creates a separate Jira task labeled for manual review when it is not. Inserts an audit row into Google BigQuery with metadata such as request type, confidence, received time, due date, and whether a Jira issue was created. Posts a Slack message to the configured channel about the routed request or the need for manual review. Creates a draft confirmation email in Gmail for the requester after a rout

von Dyogo Henrique de Oliveira Ortega
Csendemail
free

Monitor Hostinger email DNS records weekly and send alert emails via SMTP

Quick Overview This workflow runs every Monday at 8am to check email-related DNS records (MX, SPF, DMARC, and DKIM) for all domains in your Hostinger account and sends an HTML alert email when it detects missing records, tracking prior results to highlight new breakage. How it works Runs every Monday at 8am and sets the notification email address used for alerts. Fetches the full domain list from Hostinger and processes each domain one by one. Retrieves the DNS zone for each domain from Hostinger and checks for active MX records plus valid SPF, DMARC, and DKIM TXT records. Compares the current results to the previous run stored in workflow static data to mark problems as new or ongoing. Builds an HTML email describing the missing records for any affected domain and sends the alert via SMTP/email credentials to the configured recipient. Setup Add your Hostinger API credentials for the steps that list domains and retrieve DNS zones. Configure your SMTP/email-sending credentials for the email node used to send alerts. Update the notification email address (and, if needed, the from/to fields) so alerts go to the right recipient. Review and adjust the DNS validation rules in the code st

von Hostinger
CsheetsW
free

Calculate court deadlines with Google Calendar, Outlook, and Clio

Quick overview This workflow receives a webhook with a trigger date and deadline rules, calculates court deadlines (skipping weekends and US federal holidays for business-day rules), then creates matching events in Google Calendar or Microsoft Outlook, creates high-priority tasks in Clio, logs each deadline to a Google Sheets audit sheet. How it works Receives a POST webhook request containing a matter ID, trigger date, optional rule set, and the target calendar platform. Validates the payload and stops early if the matter ID is missing or the trigger date is not in YYYY-MM-DD format. Calculates one deadline per rule using calendar-day or business-day offsets that skip weekends and US federal holidays. Creates a calendar entry for each deadline in Google Calendar (all-day) or Microsoft Outlook via Microsoft Graph (timed), depending on the requested platform. Creates a high-priority pending task in Clio for each deadline and links it to the provided Clio matter ID. Appends one audit row per deadline to the “Audit Log” tab in the OPS1 Compliance Log Google Sheet. Setup Configure the webhook URL in the system that triggers deadline creation and ensure it sends at least matter_id and t

von Dele Tosh @ Protomated
BCsheetsgroqchatmodel
free

Confirm and log WhatsApp restaurant orders with Groq and Google Sheets

Quick Overview This workflow triggers on incoming WhatsApp orders, uses Groq to extract items and quantities, validates them against a live Google Sheets menu, logs the result to an orders sheet, and replies to the customer with either a clarification request or a priced confirmation (with optional VIP owner alerts). How it works Triggers when a new WhatsApp message is received on your WhatsApp Business Cloud number. Sends the message text to Groq (Llama 3.3) to extract a structured list of ordered items and quantities. Reads the latest menu (item name, price, availability) from a Google Sheets “Menu” tab. Matches extracted items to the menu, checks availability, calculates line subtotals and the total price, and compiles any validation issues. If there are issues, replies to the customer on WhatsApp asking for a corrected order and appends a “needs_clarification” entry to the Google Sheets “Orders” tab. If the order is valid, appends a “confirmed” entry to the Google Sheets “Orders” tab and sends a WhatsApp confirmation with the item summary and total. If the confirmed total meets or exceeds the VIP threshold, sends a separate WhatsApp notification to the owner number. Setup Conne

von Kanishka Shrivastava
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

von 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,

von 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

von WeblineIndia
CgmailW
free

Send gold-silver ratio opportunity alerts with GoldAPI and Gmail

Quick overview This workflow fetches live gold (XAU) and silver (XAG) prices from GoldAPI.io, calculates the gold-silver ratio, evaluates it against buy/hold thresholds, and sends a formatted opportunity alert email via Gmail. How it works Starts manually and loads configuration values such as the GoldAPI.io key, currency, alert email, and ratio thresholds. Requests the latest gold and silver prices from GoldAPI.io and extracts the numeric price values. Combines both price results and calculates the gold-silver ratio. Compares the ratio to the configured thresholds to decide whether to signal “buy silver”, “buy gold”, or “hold”. Generates a timestamped alert message with an insight and interpretation for the selected signal. Sends the full report (prices, ratio, signal, and explanation) to the configured recipient using Gmail. Setup Create a GoldAPI.io account, copy your API key, and paste it into the workflow configuration value used by the GoldAPI.io requests. Connect a Gmail OAuth2 credential in n8n and ensure the workflow can send email from your Gmail account. Set the recipient email address, currency code (for example, INR), and your buy-silver and buy-gold ratio thresholds i

von WeblineIndia
Csheets
free

Classify documents and extract invoice data with LDXhub AnalyzeDoc and Google Sheets

Quick overview This workflow collects uploaded PDFs or images, classifies each document type using LDXhub AnalyzeDoc, and routes it accordingly; invoices get high-detail field extraction and are appended as a new row in Google Sheets. How it works Receives a file upload through an n8n form for a PDF, JPG, or PNG business document. Sends the file to LDXhub AnalyzeDoc (low-detail) to classify it as invoice, receipt, business_card, contract, blank, or other. Parses the returned JSON and routes the execution based on the detected document_type. For invoices, reattaches the original uploaded file and runs LDXhub AnalyzeDoc (high-detail) to extract key invoice fields in structured JSON. Flattens the extracted fields and appends them as a new row in a selected Google Sheets worksheet. For receipts, business cards, and other types, sends the item to placeholder routes where you can add your own processing. Setup Create an LDXhub account, generate an API key, and configure an LDXhub API credential in n8n for both AnalyzeDoc steps. Connect a Google Sheets OAuth2 credential and select the target spreadsheet and worksheet in the append step. Ensure the first row of your sheet contains headers

von Hideki Mori
ACWopenaichatmodel
free

Generate executive decision briefings from APIs with OpenAI and Google Sheets

Quick overview This workflow runs daily or via an on-demand webhook to pull financial metrics, operational KPIs, and market quotes via HTTP APIs, then uses OpenAI to detect anomalies and generate an executive briefing that is POSTed to a dashboard endpoint and logged to Google Sheets. How it works Runs on a daily schedule or receives a POST request via a webhook to start an executive briefing run with a configurable lookback period. Fetches financial metrics, operational KPIs, and market data in parallel from three HTTP API endpoints and continues even if one source fails. Merges and normalizes the three datasets into a single snapshot, marking missing sources as unavailable so downstream steps keep a consistent structure. Uses OpenAI to analyze the snapshot for anomalies, unusual trends, and data gaps, returning a severity-scored findings JSON. Uses OpenAI again to turn the anomaly findings and raw metrics into a structured executive briefing with a health score, risks, opportunities, and recommended actions. Formats a final JSON payload and delivers it by POSTing to your dashboard endpoint and appending a summary row to a Google Sheets tracker. If the run was triggered by the web

von Oneclick AI Squad
Cgmail
free

Generate and email Stripe invoice PDFs with PDFBolt and Gmail

Quick overview This workflow triggers on successful Stripe invoice payments, formats the invoice data for a PDFBolt template, generates a PDF invoice, and emails it to the customer through Gmail. How it works Triggers when Stripe emits an invoice.payment_succeeded event for a paid invoice. Extracts the Stripe invoice object, formats amounts, and maps customer and line-item fields into templateData for PDFBolt. Generates a PDF from a published PDFBolt template using the Direct endpoint and returns the file as binary data. Sends the generated PDF as an attachment in a Gmail email to the customer’s email address from the Stripe invoice. Setup Connect your Stripe account and ensure the trigger can receive invoice.payment_succeeded events. Add your PDFBolt API key from https://app.pdfbolt.com/api-keys, publish an invoice template in PDFBolt, and paste its Template ID into the PDFBolt node. Connect your Gmail account and adjust the email subject or body text if you want different wording or branding. Requirements Stripe account connected in n8n PDFBolt account and API key Published PDFBolt invoice template Gmail account connected in n8n Customization Use your own PDFBolt Template ID Matc

von PDFBolt
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

von Mohamed Yahya Chahin
Csendemail
free

Deploy curated Docker app stacks to a Hostinger VPS via forms and email

Quick overview This workflow collects a stack choice and notification email via a form, lets you pick a Hostinger VPS, deploys the selected curated app stack as separate Docker Compose projects using the Hostinger API, and emails a per-app deployment summary with ports, container status, and generated credentials. How it works Receives a form submission with the selected stack (Developer, Hobbyist, Freelancer, or AI/LLM) and a notification email address. Uses the Hostinger API to list available VPS instances and presents a second form to select the target virtual machine. Expands the chosen stack into one item per app by generating Docker Compose content and creating random values for any required secrets. Creates a Docker Compose project for each app on the selected Hostinger VPS via the Hostinger API. Waits briefly, polls the Hostinger action status for each deployment, and branches based on whether the action completes successfully. On success, lists the project’s containers and formats a status block including ports, container states, and any generated credentials, and on failure, fetches recent Docker project logs and formats an error block. Aggregates all per-app blocks into

von Hostinger
Csendemail
free

Guard Hostinger VPS CPU spikes with Anthropic, SSH, and email approvals

Quick overview This workflow monitors a Hostinger VPS every 15 minutes for CPU spikes, correlates them with traffic anomalies, and either auto-activates a lockdown firewall or emails a process report with AI analysis and an email-reply approval path to snapshot and kill high-CPU processes. How it works Runs every 15 minutes and loads the VPS ID, SSH host, alert email, and CPU/traffic thresholds. Fetches the last two hours of CPU and network traffic metrics from the Hostinger API and determines whether the latest CPU usage exceeds the configured threshold and whether traffic is anomalous. When a CPU spike is detected, connects over SSH to run ps aux --sort=-%cpu, formats the top processes, and flags PIDs exceeding the kill CPU threshold. Sends the raw process list to Anthropic (Claude) to generate a short diagnosis and recommendation. If the spike appears traffic-driven, lists/creates a Hostinger “lockdown” firewall that only allows the configured ports, activates it on the VPS, and emails a lockdown alert. If the spike is not traffic-driven, writes a pending-approval case entry to /var/log/n8n-cpu-guard.log over SSH and emails a report with the case ID, process table, AI analysis,

von Hostinger
Cgmail
free

Send daily Zillow new-listing digests to Gmail with ScraperAPI

Quick Overview This workflow monitors Zillow searches using ScraperAPI’s AI Parser, stores seen listings in n8n Data Tables, and emails a daily HTML digest of newly found listings via Gmail. How it works Runs on a daily 9AM schedule or manually to check for new listings across saved Zillow search URLs. Loads all search configurations from an n8n Data Table and processes them one at a time. Uses ScraperAPI AI Parser to scrape each Zillow search results page and extract listing fields like address, price, beds, baths, and URL. Filters the scraped listings against the search thresholds and compares them to previously logged ZPIDs in an n8n Data Table to identify new listings. Writes each newly discovered listing into the “seen” Data Table to prevent duplicate alerts in future runs. Retrieves all listings first seen today, builds an HTML digest grouped by search name, and sends it as a Gmail email. Setup Create n8n Data Tables access (or enable Data Tables in your n8n instance) and run the manual initialization trigger once to create and seed the zillow_searches and zillow_seen tables. Add your ScraperAPI credentials, run the “Create Parser” manual trigger once, and copy the resulting

von ScraperAPI
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

von Precision Tech
ACsheets
free

Create TikTok carousel posts with Upload Post, Google Sheets, Gemini, GPT-4.1

Quick overview This workflow runs daily to pull TikTok post and profile analytics from Upload Post, updates a Google Sheets performance log, uses Google Gemini and OpenAI to generate a new carousel concept and caption, creates four images via fal.ai, publishes to TikTok, and updates a persistent “Agent Skill” sheet. How it works Runs on a daily schedule (or manually) and loads product, Upload Post, and Google Sheets configuration values. Reads the Google Sheets “Performance Log,” selects posts missing stats or posted recently, fetches TikTok post analytics from the Upload Post API, and writes updated metrics back to the sheet. Aggregates the refreshed history, fetches TikTok profile analytics from Upload Post, reads the “Agent Skill” sheet, and compiles a single context summary. Uses Google Gemini (via a structured JSON output) to generate a TikTok carousel plan including caption, strategy notes, four slide prompts, hashtags, and an engagement question. Sends the four prompts to fal.ai to generate four 9:16 PNG carousel images and collects their hosted image URLs. Uses OpenAI (GPT-4.1) to write a short TikTok photo-post description, publishes the carousel to TikTok via Upload Post

von amanullah
CsheetsWsendemail
free

Collect post-purchase product reviews with WooCommerce, Google Sheets, and SMTP

Quick overview This workflow sends post-purchase review request emails for WooCommerce orders, stores expiring form links in Google Sheets, optionally shortens links with Dub.co and delays delivery, serves a hosted rating form via n8n webhooks, and submits collected reviews back to WooCommerce. How it works Receives an order completion event via a WooCommerce webhook or an external POST webhook and returns a 200 OK response. Normalizes the incoming order payload, generates a unique form token and expiry, and builds a customer-specific review form URL. Fetches each product’s image and permalink from the WooCommerce REST API, aggregates the product list, and appends the form record to a Google Sheets tab. Optionally shortens the form URL using the Dub.co API and optionally waits a configured number of days before sending the message. Renders an HTML email containing the ordered products and the review link and sends it via SMTP to the customer. When the customer opens the review link, looks up the form token in Google Sheets, validates status/expiry, and serves either the multi-product rating form HTML or an error page. When the form is submitted, validates the token again, posts eac

von Business Atlas
CW
free

Organize VNTANA showroom assets by style and color via webhook and CSV report

Quick overview This workflow receives a VNTANA showroom event (or a manual UUID) via webhook, fetches the showroom, validates naming and metadata rules, reorganizes products into ordered groups, updates the showroom in VNTANA, and returns a CSV report of the new layout. How it works Receives a POST webhook containing either a showroomUuid field or a VNTANA showroom event payload with showroom.uuid. Validates and extracts the showroom UUID from the request body. Calls the VNTANA API to fetch the full showroom details and product list. Enforces organization rules by requiring a Style attribute on every product, a _.ext filename pattern, and unique color codes within each style group, then builds grouped and sorted ordering data. Updates the same showroom in VNTANA by writing the computed groups and per-product order back via the API. Generates a CSV “receipt” listing each asset UUID, name, assigned group, and order, and returns it as a downloadable file in the webhook response. Setup Create and configure a VNTANA API credential in n8n and assign it to the VNTANA API requests. Ensure showroom assets in VNTANA have a non-empty Style attribute and follow the _.ext naming pattern with un

von Derek Cicero
CW
free

Monitor competitor web page changes with HTTP and Slack or Discord

Quick overview This workflow checks a list of competitor web pages every six hours, detects content changes by hashing cleaned page text, and posts a diff-style alert to a Discord or Slack channel via an incoming webhook. How it works Runs every 6 hours on a schedule. Loads a configured list of target competitor page URLs and the destination Discord/Slack webhook URL. Fetches each target page over HTTP with browser-like headers and continues even if a request fails. Converts the fetched HTML into cleaned plain text, stores a baseline on first run, and compares the latest hash against the previously saved version. When a change (or fetch error) is detected, generates a message including the URL and a small list of added/removed lines. Sends the alert message to your Discord or Slack webhook endpoint. Setup Create an incoming webhook in Discord or Slack and paste its URL into the workflow configuration. Update the target list with the competitor page names and URLs you want to monitor. Ensure n8n can persist workflow static data between runs (so change history is retained) and that your instance can reach the target sites over HTTP. Requirements n8n version 1.60+. A Discord or Slack

von Ruben Fabioux
Cgoogledrivepostgres
free

Extract invoice data from Google Drive images with GPT-4o and Postgres

Quick overview This workflow watches a Google Drive folder for new invoice images, extracts key invoice fields with OpenAI vision, checks for duplicates in Postgres, and then stores the invoice or moves the file into processed, duplicate, or failed folders. How it works Triggers every hour when a new file is created in a specific Google Drive folder. Downloads the new file from Google Drive and sends the image to OpenAI (GPT-4o) to extract invoice fields as JSON. Cleans and parses the AI response into structured invoice data, routing invalid or unparseable results to a failed path. Checks Postgres to see if an invoice with the same vendor name, invoice number, and total already exists. If the invoice is a duplicate, moves the source file in Google Drive to a duplicate folder. If the invoice is not a duplicate, inserts the invoice into the Postgres invoices table (status set to processed) and moves the source file to a processed folder. Setup Connect Google Drive OAuth2 credentials and set the incoming, processed, duplicate, and failed folder IDs to match your Drive structure. Add an OpenAI API credential and ensure the selected model (gpt-4o) is available for image analysis. Add Po

von pawan
airtableCfacebookgraphapi
free

Post TikTok, YouTube Shorts and Instagram Reels with Airtable, OpenAI and Google

Quick Overview This workflow runs on a schedule, pulls the next publish-ready video from Airtable, uses OpenAI, Google Gemini, and CloudConvert to generate a transcript, title, description, tags, and hashtags, then uploads to YouTube Shorts, posts an Instagram Reel via Meta Graph API, and queues TikTok publishing via Google Sheets. How it works Runs on a schedule (or manually) and waits a random number of minutes to stagger posting. Searches Airtable for content marked Publish = true and Status = “In Publish Queue”, then selects a single record to process. Downloads the video, converts it to MP3 with CloudConvert, and transcribes the audio with OpenAI. Uses OpenAI and Google Gemini to extract a main keyword, generate a YouTube-optimized title, and create YouTube tags, hashtags, and a full YouTube description, then derives a shorter content-only caption for Instagram/TikTok. Uploads the video to tmpfiles.org to generate a direct file URL and updates the Airtable record with the generated metadata and set Status = “Published”. Uploads the video to YouTube with the generated title, description, and tags. Creates and publishes an Instagram Reel via the Meta (Facebook) Graph API after a

von Iliyan Ivanov
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

von Hanna Nosova