Skip to content
FlowHubFluxonLab

HTTP Request Workflows

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

ACgmail
free

Send a daily AI-ranked job match digest with Anthropic and Gmail from 6+ boards

Quick Overview This workflow runs every morning to pull jobs from multiple free job boards (and optional Adzuna), filters and de-duplicates results, scores each role against your resume and preferences using Anthropic, then emails a ranked digest via Gmail. How it works Runs every morning at 08:00 using a schedule trigger. Builds a list of job board API URLs (RemoteOK, Remotive, Arbeitnow, Jobicy, Himalayas, TheMuse, and optional Adzuna) based on your search settings. Fetches job listings from each board over HTTP. Normalizes all responses into a single job format, applies your filters (title keywords, tags, locations/remote, salary, and excluded terms), and de-duplicates roles across boards. Sends your resume, preferences, and the short-listed jobs to an Anthropic-powered AI agent to return a structured fit score, fit reason, risk/concerns, and a tailored first-person pitch for each job. Keeps only roles at or above your minimum score, ranks them by score, and generates an HTML email digest with links and source board attribution. Sends the digest to your target address using Gmail. Setup Add an Anthropic API credential, select an Anthropic chat model, and keep the structured outp

von Nocode Expert
BCgmail
free

Match Japanese jGrants subsidies to your company with Gemini, Slack and Gmail

Quick Overview This workflow runs weekly to search the public jGrants API for open Japanese subsidies, scores each subsidy’s fit for your company using Google Gemini, logs results to Google Sheets, and notifies a Slack channel (and drafts a Gmail kickoff email) for strong matches. How it works Runs weekly on a schedule and loads your company profile details (industry, headcount, prefecture, investment plan, and search keyword). Calls the public jGrants subsidies API to retrieve currently accepting programs sorted by newest first, and posts to Slack if the search fails. Processes each returned subsidy individually and asks Google Gemini to produce a fit score, verdict (strong/possible/no), reasons, next steps, and a short summary. Normalizes the Gemini response into consistent fields, and posts to Slack if scoring fails for a subsidy. Upserts each scored subsidy into a Google Sheets tracker (keyed by subsidy ID) to avoid duplicates across weekly runs. Routes results by verdict: sends a detailed Slack alert and creates a Gmail draft for strong matches, posts a lightweight Slack message for possible matches, and flags unclear verdicts in Slack. Setup Add credentials for Google Gemini

von Oka Hironobu
BCgmail
free

Monitor Japanese business partners for registry changes with gBizINFO and Gemini

Quick Overview This workflow runs weekly to check Japanese business partners listed in Google Sheets against the gBizINFO corporate registry API, uses Google Gemini to assess the risk impact of detected changes, updates the stored partner snapshot, and escalates findings to Slack and Gmail based on materiality. How it works Runs every week on a schedule. Reads the partner list (including corporate numbers and last-known name/address) from Google Sheets. Queries the gBizINFO corporate registry API for each partner and posts a Slack message if the lookup fails. Compares the latest registry data to the stored snapshot to detect name, address, or closure/dissolution changes and continues only when changes are found. Sends the detected changes to Google Gemini to classify materiality (high/medium/low) with a short summary and recommended action, and posts a Slack message if the assessment fails. Updates the Google Sheets partner snapshot with the latest registry details so the change is recorded. Routes by materiality to notify Slack (medium/other), and for high materiality also posts a Slack alert and creates a Gmail draft requesting a credit review. Setup Create a Google Sheets spread

von Oka Hironobu
AsheetshtmlW
free

Monitor competitor pricing page changes with OpenAI, Google Sheets and Slack

Quick overview This workflow checks competitor pricing pages each morning, compares the latest visible text to the previous snapshot stored in Google Sheets, and uses OpenAI to summarize meaningful changes before posting an alert to a Slack channel. How it works Runs every day at 08:00 on a schedule. Reads your configured list of competitor page URLs and processes each URL individually. Fetches each page’s HTML, extracts the visible body text, and trims it to a snapshot for comparison. Looks up the previous snapshot for the same URL in Google Sheets. If a previous snapshot exists and the content differs, OpenAI generates a 1–3 bullet summary of meaningful changes based on your watch criteria. Posts the change summary to Slack and then appends or updates the URL’s latest snapshot and “Last Checked” timestamp in Google Sheets. If no previous snapshot exists or no change is detected, it skips the Slack alert and only saves the current snapshot to Google Sheets. Setup Add credentials for Google Sheets, Slack, and OpenAI (Chat) and select the target Slack channel. Create or choose a Google Sheet with columns named URL, Content, and Last Checked, and set the Spreadsheet ID and sheet name

von Manik Chandra Dhor
BCgmail
free

Verify Japanese invoice registration numbers from Gmail using Gemini, NTA API, Sheets and Slack

Quick Overview This workflow monitors Gmail for unread invoice emails with PDF attachments, extracts invoice details with Google Gemini, verifies Japanese qualified invoice registration numbers against the National Tax Agency (NTA) Invoice Web-API, logs results to Google Sheets, and sends Slack alerts for invalid, missing, or inconclusive checks. How it works Polls Gmail hourly for unread emails matching “has:attachment invoice” and downloads the first attachment. Extracts text from the attached invoice PDF. Uses Google Gemini to parse the invoice text into structured fields such as the T-registration number, issuer name, invoice date, and amounts. Normalizes and validates the registration number to ensure it matches the required “T + 13 digits” format. If the format is valid, calls the NTA Invoice Web-API to verify the registration number and interprets the response as valid, invalid, or not found. Appends the invoice details and verification status to a Google Sheets worksheet. Routes the outcome by sending the appropriate Slack alert for invalid/not found/inconclusive results or marking the invoice email as read when the number is valid. Setup Connect your Gmail OAuth2 credentia

von Oka Hironobu
AWopenaichatmodel
free

Handle WhatsApp support text and voice messages with OpenAI GPT-5 Mini

Quick overview This workflow responds to incoming WhatsApp Business messages, handling both text and voice notes by transcribing audio with OpenAI and replying with an OpenAI chat agent that uses per-contact conversation memory and answers only from the business information you provide. How it works Triggers when a new WhatsApp message is received. Routes the incoming message by type, sending text messages directly to the support flow, audio messages to a voice-transcription flow, and other message types to a fallback reply. For voice notes, retrieves the WhatsApp media URL, downloads the audio file, and transcribes it to text with OpenAI. Sends the customer’s text (original or transcribed) to an OpenAI chat agent configured to answer only using your provided business information. Stores and reuses a per-contact conversation history keyed by the sender’s WhatsApp number to maintain context across messages. Sends the agent’s response back to the customer as a WhatsApp text message. Setup Connect WhatsApp Business Cloud credentials for both receiving messages (trigger) and sending replies, and ensure your WhatsApp webhook is configured to point to the trigger URL. Add OpenAI credenti

von Manik Chandra Dhor
ACW
free

Run a multimodal WhatsApp AI assistant with OpenAI for text, voice and images

Quick overview This workflow turns WhatsApp into a multimodal assistant that answers text, voice notes, images, and PDF documents using OpenAI, and can generate images with DALL·E on demand, replying back in WhatsApp with either text, audio, or an image. How it works Triggers when a new WhatsApp message is received. Detects whether the incoming message is text, a voice note, an image, a PDF document, or an unsupported type. For text messages, generates an image with OpenAI DALL·E when the message starts with the configured /image command, and sends the generated image back to the sender. For voice notes, fetches the WhatsApp media URL, downloads the audio, transcribes it with OpenAI, and forwards the transcript to the assistant. For images, fetches the WhatsApp media URL, downloads the image, describes it with OpenAI vision using the configured analysis prompt, and forwards the description (plus any caption) to the assistant. For PDF documents, downloads the file from WhatsApp, extracts the PDF text, and forwards the extracted content (plus any caption) to the assistant, while non-PDF files receive an error message. Uses an OpenAI chat model with per-contact short-term memory to ge

von Dr. Firas
ACgmailsheets
free

Screen LinkedIn jobs and send tailored applications with Apify and OpenAI

Quick overview This workflow collects your job preferences via an n8n form, uses Apify to scrape LinkedIn job listings, and has OpenAI screen and rank them. After you approve a shortlist by Gmail, it generates tailored resume and cover-letter PDFs with DocRaptor, emails them to you, and logs matches to Sheets How it works Receives your job preferences and resume text through an n8n form submission. Sends the preferences to Apify to scrape recent LinkedIn jobs, then removes duplicates and obvious mismatches (seniority, years of experience, and location). Uses OpenAI to score each job’s relevance and eligibility and returns a JSON verdict with a fit score and short reason. Keeps the top matches above the configured threshold and emails you a shortlist in Gmail with approve/decline buttons. If you approve, uses OpenAI to draft a job-specific resume and cover letter from only the provided profile text and generates HTML interview prep questions. Converts the resume and cover letter HTML into PDFs via DocRaptor, emails the tailored application package to you in Gmail, and appends the match details to a Google Sheets tracker. Setup Add credentials for OpenAI, Gmail OAuth2, Google Sheets

von Dr. Firas
BCW
free

Generate weekly student progress reports with Gemini, Supabase, and WhatsApp

Quick overview This workflow runs weekly to pull student attendance and score data from Supabase, uses Google Gemini to generate per-student performance summaries and attention flags, sends immediate WhatsApp alerts for flagged students, then compiles all summaries into a PDF report, uploads it, and shares it with the coach via WhatsApp. How it works Runs weekly on a schedule. Fetches all student weekly metrics (attendance and scores) from Supabase. Uses Google Gemini to write a short performance summary per student and determine whether the student should be flagged for attention based on attendance and score-drop rules. If a student is flagged, sends a WhatsApp message to the coach and inserts a flag record into Supabase. Aggregates all students’ summaries into a single HTML weekly report. Converts the HTML report to a PDF via an HTTP-based HTML-to-PDF API, uploads the PDF to a file-hosting API, and sends the PDF link/document to the coach via WhatsApp. Logs the report URL to Supabase for recordkeeping. Setup Add Supabase credentials and create the required tables/columns (weekly_student_data, attention_flags, and weekly_reports) referenced by the workflow. Add a Google Gemini (P

von Kanishka Shrivastava
ABC
free

Draft personalized cold emails from Google Sheets using Gemini and HubSpot

Quick overview This workflow batch-processes leads from Google Sheets, researches each person and company using Tavily plus Google Gemini, drafts a personalized cold email, then creates/updates the contact in HubSpot with a research note and a saved email draft before marking the lead as Done in the sheet. How it works Runs manually and sets a batch size that controls how many leads to process per run. Reads leads from Google Sheets, skips rows already marked as Done, and normalizes the selected batch into clean lead fields. Processes the batch one lead at a time and uses Tavily search (last 60 days) with Google Gemini to extract the most recent public activity, pain points, and a personalization hook. Cleans and parses the research JSON so it can be reused reliably downstream. Uses Google Gemini to draft a 90–120 word cold outreach email (subject and body) that incorporates the research and offers a free “Automated LinkedIn Post Creator” n8n workflow. Creates or reuses the HubSpot contact, logs a HubSpot note with the research and drafted email, and saves the email as a HubSpot engagement in DRAFT status. Updates the matching row in Google Sheets (by Email) to set Status to “Done

von Vyrazu Labs
CW
free

Create Zoho Books invoices from email attachments using OpenAI OCR

Quick overview This workflow monitors an IMAP inbox for emails with invoice attachments, uses OpenAI to OCR and extract structured invoice data, looks up customers and tax/currency settings in Zoho Books, and then creates a new Zoho Books invoice with the original attachment included. How it works Triggers when a new email arrives via IMAP. Filters for emails that contain attachments, then splits each attachment into its own item for processing. Normalizes each attachment’s binary data and routes it to OpenAI for OCR based on whether it is a PDF or an image. Fetches taxes, currencies, and active customer contacts from Zoho Books and prepares the data for matching and invoice creation. Sends the OCR text plus Zoho Books tax metadata to OpenAI to validate that the document is a sales invoice and to return invoice and customer details as JSON. Filters out non-invoice attachments, matches the extracted customer to an existing Zoho Books contact (with a configurable fallback), and posts a new invoice to Zoho Books using multipart upload to attach the original file. Setup Add IMAP credentials for the mailbox that receives invoice emails. Add Zoho Books OAuth2 credentials and ensure the c

von CRMOZ
AasanaCW
free

Report workflow errors to Asana tasks with Google Chat and Grok 4.5 analysis

Quick overview When a monitored workflow fails, this reads its Description field to find the owning client and assignee, looks them up in Asana, analyses the error with Grok 4.5, and creates an assigned task with a severity-based due date. Repeat failures comment on the existing task. How it works Any workflow that names this one as its error workflow triggers it on failure. There is no production trigger by design. The error payload only carries a workflow ID, so an HTTP Request calls the n8n API to read that workflow's own Description field, which holds a small JSON object naming the client and the assignee. Asana projects and users are fetched live and matched by name, so no GID is ever hardcoded. A failed match raises a warning that travels downstream instead of failing silently. Asana is searched for an open task covering the same workflow and node. If one exists, a comment carrying the new execution ID is added rather than a duplicate task. For a new error, Grok 4.5 via OpenRouter returns a root cause, a solution, concrete steps, a severity, and a category, held to a fixed shape by a structured output parser. Severity sets the due date: Critical today, High tomorrow, Medium i

von Aironauts AI
CWtelegram
free

Create Instagram carousels and TikTok slideshows with OpenAI and PostFast

Quick overview This workflow runs on a Mon/Wed/Fri schedule to generate an Instagram carousel or TikTok slideshow using OpenAI (GPT-4o-mini and gpt-image-1), sends the slides to Telegram for approval, and only then uploads the images and schedules the post via PostFast. How it works Runs every Monday, Wednesday, and Friday at 8am and loads your brand, topics, slide count, platform filter, and Telegram chat ID. Retrieves your connected social accounts from PostFast and keeps only accounts that are connected and match the selected platforms. Uses OpenAI (gpt-4o-mini) to write a carousel as strict JSON containing a caption and slide-by-slide headings, body text, and visual descriptions. Builds per-slide image prompts and uses OpenAI (gpt-image-1) to generate a 1024×1536 portrait image for each slide. Sends the generated slide images to Telegram and waits for you to approve or decline posting. If approved, requests per-account upload URLs from PostFast, uploads each slide image to the provided storage URLs, and schedules one PostFast social post per account with the slides in order and the generated caption. Setup Install and enable the PostFast community node (n8n-nodes-postfast) and

von Petar Georgiev
airtableBWopenrouterchatmodel
free

Send and track LinkedIn outreach with Airtable, Unipile, and OpenRouter

Quick overview This workflow automates LinkedIn outreach by using Airtable as a CRM, Unipile to fetch profiles and send connection requests/messages, and OpenRouter to generate personalized connection notes and follow-ups, while tracking accepts and replies via Unipile webhooks. How it works Runs every weekday at 09:00 to pull up to 15 Airtable leads with Connection Status set to New. For each lead, derives the LinkedIn public identifier, fetches the LinkedIn profile from Unipile, and uses OpenRouter to generate a personalized connection note capped at 300 characters. Sends the LinkedIn connection request via Unipile, updates the Airtable record with request details (note, timestamps, invitation ID), and waits 30–90 seconds between sends. Receives Unipile new_relation webhook events, matches the lead by Provider ID, and marks the Airtable record as Accepted with an Accepted At timestamp. Receives Unipile message_received webhook events, filters to inbound replies, finds the matching Airtable lead, and marks it Replied while stopping the campaign. Runs daily at 10:00 to find accepted, no-reply leads due for follow-up, uses OpenRouter to write follow-up #1 or #2, sends the DM via Uni

von Salman Mehboob
CsheetsW
free

Run LinkedIn outreach with Google Gemini, Apify, Google Sheets, and PhantomBuster

Quick overview This workflow collects a plain-English LinkedIn audience description via an n8n form, uses Google Gemini to generate a search URL, pulls matching leads from Apify, writes five personalized icebreakers to Google Sheets, and drip-launches a PhantomBuster agent every 15 minutes. How it works Receives a form submission with a plain-English description of your target LinkedIn audience. Uses Google Gemini to turn the audience description into a JSON response containing an Apollo-style search URL, then parses and extracts the searchUrl value. Calls the Apify API to run an actor and return up to 100 lead records matching the configured filters. Limits processing to the first five leads to control outreach volume. Uses Google Gemini to generate a short, unique connection-message icebreaker for each lead based on their profile fields. Appends or updates each lead in Google Sheets with contact details, LinkedIn URLs, and the generated icebreaker. Waits 15 minutes per lead and then triggers a PhantomBuster agent via HTTP request to start the outreach action. Setup Create and add credentials for Google Gemini (PaLM API) and update the model selection if needed. Add an Apify API t

von Prakash Software
Cgmailgoogledrive
free

Tailor ATS-ready resumes and cover letters with Gemini, Google Drive, Notion, and Gmail

Quick overview Transform any resume into a professional, ATS-compliant document with AI. Supports Global ATS, German, and Japanese resume formats, generates personalized cover letters, and automates PDF creation and delivery for every job application. How it works Receives an n8n form submission with the company name, job description, selected ATS type, and an optional request to generate a cover letter. Lists resume PDF files from a specified Google Drive folder, downloads each file, extracts the PDF text, and cleans it into a single plain-text resume input. Uses Google Gemini to rewrite the resume into pure-HTML output tailored to the job description, choosing Global ATS, German Lebenslauf, or Japanese Rirekisho formatting based on the selected ATS type. Converts the generated HTML resume into a PDF using the PDF.co HTML-to-PDF API and retrieves the resulting PDF from the returned URL. Uploads the generated resume PDF to a Google Drive output folder, then reads the existing Notion database entries to compute the next serial number and creates a new Notion database page linking to the uploaded file. If cover letter generation is requested, uses Google Gemini to write a localized c

von Blukaze Automations
ACW
free

Assess visa eligibility and send PDF checklists with Claude and SendGrid

Quick overview This workflow receives visa eligibility requests via webhook, uses Anthropic Claude to extract passport details and assess visa requirements, generates a purpose-specific document checklist, converts it to a PDF via PDFShift, logs each request to Google Sheets, and emails the PDF to the applicant using SendGrid. How it works Receives a webhook POST with applicant details, travel plan, and raw passport OCR text. Uses Anthropic Claude to extract and validate passport data (name, nationality, passport number, expiry) and scores whether the passport text is readable. If passport data is insufficient, immediately returns a webhook response asking the applicant to resubmit a clearer passport scan. If passport data is sufficient, waits briefly and uses Anthropic Claude again to determine whether a visa is required, the visa category, a recommended visa type, processing time, risks, and confidence. Builds a document checklist from a standard base list plus purpose-specific items and any AI-flagged eligibility risks, then renders it into HTML. Sends the HTML to PDFShift to generate a PDF, formats a summary row, and appends the application record to a Google Sheets tab. Emails

von Oneclick AI Squad
airtableCsheetsW
free

Extract and log Gmail admin tasks with OpenAI, Google Sheets and Airtable

Quick overview This workflow monitors Gmail for messages labeled “Admin”, redacts sensitive data, uses OpenAI to extract structured admin tasks and reminders, skips duplicates by checking Google Sheets and/or Airtable, sends optional Slack or Microsoft Teams alerts for urgent items, and logs the clean task details. How it works Triggers every minute when a new Gmail message matches the query label:Admin newer_than:7d. Loads configurable settings (log destination, alert channels, due-soon window, dedupe window, and redaction toggle) and normalizes the email into a clean text body. Redacts sensitive patterns (such as SSNs, card-like numbers, phone numbers, email addresses, and addresses) and generates an “admin hash” fingerprint for deduplication. Checks Google Sheets and/or Airtable for recent matching Message IDs or admin hashes and skips processing if the email appears to be a duplicate. Sends the redacted email content to OpenAI to classify whether it is an admin item and to extract fields like task title, summary, priority, due date/time, and recommended next step. If the item is valid, optionally posts an alert to Slack and/or Microsoft Teams for urgent/high-priority, due-soon,

von Precision Tech
airtableCsheetsW
free

Extract and log Gmail receipt expenses with OpenAI, Sheets and Airtable

Quick overview This workflow monitors a Gmail “Receipts” label, downloads attachments, uses OpenAI to extract expense data from receipt emails and images, skips duplicates and non-receipts, fails safely when extraction is unreadable, sends Slack/Teams alerts for high-value, warranty, or review-needed receipts, and logs valid receipts to Sheets or Airtable. How it works Triggers every minute when Gmail finds new emails matching the query label:Receipts newer_than:2d. Normalizes the email into consistent fields (message ID, subject, sender, received date, plain-text body) and generates a receipt hash for stable matching. Searches Airtable and/or Google Sheets for existing records matching the message ID or receipt hash and marks the email as a duplicate if it falls within the configured duplicate window. For new receipts, sends the email content to OpenAI to extract receipt details like merchant, total, category, line items, tax hints, and return/warranty dates. Evaluates the extraction to flag high-value, warranty/return-relevant, or needs-review receipts and formats alert messages. Posts alerts to Slack and/or Microsoft Teams when enabled and the receipt is not “standard.” Appends

von Precision Tech
BsheetsWopenaichatmodel
free

Scrape and score Amazon products with Apify, OpenAI, and Google Sheets

Quick overview This workflow manually scrapes product results from an Amazon search URL via the Apify Amazon Crawler actor, uses OpenAI to generate a structured product analysis (category, key feature, verdict, value score), and appends the enriched results to a Google Sheets spreadsheet. How it works Runs when you manually click “Test workflow” in n8n. Sends the configured Amazon search URL and scraping limits to the apify Amazon Crawler actor and retrieves the dataset items. Filters out any scraper items that are missing a title or contain an error. Uses OpenAI to analyze each product’s title, brand, price, rating, and review count and returns a structured category, key feature, buyer verdict, and 1–10 value score. Combines the scraped fields and AI analysis into a single row format and adds a timestamp. Appends each enriched product as a new row in Google Sheets. Setup Create an apify API token and add it as an HTTP Header Auth credential used by the Apify request. Add an OpenAI API key as an OpenAI credential and choose the model to use in the configuration. Connect a Google Sheets OAuth2 account and select the target spreadsheet, sheet tab, and columns for appending rows. Upda

von Dr. Firas
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

von Hanna Nosova
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

von Dr. Firas
sheetsWinformationextractoropenaichatmodel
free

Find YouTube creator emails with Apify, OpenAI and Google Sheets

Quick overview This workflow searches YouTube via Apify for videos matching a keyword, deduplicates the resulting channels, scrapes each channel’s About description, uses OpenAI to extract contact email addresses, and appends channels with emails to a Google Sheets tab. How it works Starts when you manually execute the workflow. Sends a keyword-based search request to the Apify YouTube Scraper to retrieve recent YouTube results and their channel URLs. Deduplicates the results so each channel URL is processed only once. Scrapes each channel’s About/description data using an Apify YouTube Scraper request. Uses OpenAI to extract and de-obfuscate any email addresses found in the channel description. Keeps only channels where at least one email address was extracted. Appends the channel name, channel URL, extracted emails, search query, and the current date to Google Sheets. Setup Add an Apify API token using an HTTP Header Auth credential (Authorization: Bearer ) and connect it to both Apify HTTP Request steps. Add an OpenAI API key credential and choose the model name you want to use in the Configuration values. Connect your Google Sheets OAuth credential, then set the target spreadsh

von Dr. Firas
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

von Oneclick AI Squad