Quick overview This workflow pulls unprocessed leads from Airtable, enriches them with LinkedIn profile, company, and post data via Apify, optionally scrapes the company website with Firecrawl, then uses Anthropic Claude to qualify leads and draft multi-step LinkedIn outreach messages, saving results back to Airtable. How it works Runs when you manually execute the workflow. Reads qualification and writing prompts from Airtable, then searches Airtable for leads where the “Réponse” and “Match” fields are empty. Iterates through each lead and uses Apify to fetch LinkedIn profile details, marking the Airtable record as “Likedin pas dispo” when the profile cannot be retrieved. For available profiles, uses Apify to fetch company details when a company LinkedIn URL exists and, if a website is available, uses Firecrawl to scrape the homepage and clean the returned markdown. Uses Apify to fetch recent LinkedIn posts for the lead and selects a relevant recent personal post URL to include in the enrichment dataset.
Tags
AirtableAnthropic Chat ModelCCodeWHTTP Request
Structured Output ParserRelated workflows
See all AI Automation→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
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
C
WExtract 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