Airtable Workflows
634 Ergebnisse — 181 herunterladbare Workflow-Dateien, 453 quellenverknüpfte n8n-Referenzen
Screen resumes and route hiring decisions with Airtable, DeepSeek, and gotoHuman
Quick overview This workflow collects job applications via Gmail, deduplicates candidates in Airtable, extracts resume text with LlamaParse, scores candidates against an Airtable role rubric using a DeepSeek chat model, and routes results to gotoHuman for approve/reject decisions that update the candidate’s stage. How it works Receives a job application submission from Gmail, including the applicant’s name, email, role, and resume file. Searches Airtable Candidates by email to detect duplicates and either creates a new candidate record or updates the existing record. Extracts text from the uploaded resume with LlamaParse and runs a basic quality check to detect likely mis-parsed or incomplete text. If parsing looks poor, updates the candidate in Airtable to “Needs Manual Review” with a “poor” parse quality flag. If parsing looks good, fetches the role-specific scoring rubric from the Airtable Roles table, sanitizes the resume text, and sends both to a DeepSeek chat model (via LangChain) to produce a structured JSON scorecard. Validates and normalizes the AI’s JSON output, saves the score, reasoning, confidence, red flags, and recommendation back to Airtable, and submits the scoreca
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,
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
Route insurance quote leads with OpenAI, Airtable, Sheets, Teams, Slack and Twilio
Quick overview This workflow receives insurance quote submissions via a webhook, normalizes and deduplicates them against Airtable and/or Google Sheets, uses OpenAI to score and classify the lead, then routes hot/warm leads to Microsoft Teams and/or Slack (plus Twilio SMS for hot leads) and logs the quote. How it works Receives an insurance quote request through a webhook endpoint. Applies configurable settings (log destination, notification channels, thresholds) and normalizes the incoming form payload into a standard quote format. Checks Airtable and/or Google Sheets for recent matching email/phone/hash entries to detect duplicate submissions. If the quote is new and has contact details, sends the quote data to OpenAI to generate a lead score, priority, underwriting flags, missing info, and recommended next steps. Routes the quote as hot, warm, or cold based on the score/priority and prepares formatted alert messages for Microsoft Teams and Slack. Posts hot/warm alerts to Microsoft Teams and/or Slack, and sends a Twilio SMS to an agent for hot leads. Creates a quote log record in Airtable and/or appends a row to Google Sheets, then returns a JSON response with logging and notific
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
Run AI voice outreach from Airtable with Bolna, Groq, Brevo and AiSensy
Quick overview This workflow runs daily and pulls outreach contacts from Airtable, calls each coordinator using Bolna.ai, and analyzes the call transcript with Groq. Based on the outcome, it sends tailored follow-up emails via Brevo and updates call status, last-called date, and attempt count back in Airtable. How it works Runs every day at 11 AM IST on a schedule. Searches Airtable for contact records that have a coordinator phone number and processes them one by one. Skips contacts that were called in the last 3 days or are already marked Interested, Not Interested, or Dead Contact. Places an outbound AI voice call through Bolna.ai, waits 180 seconds, and then fetches the call status and transcript from Bolna. If the call is answered (a transcript exists), sends the transcript to Groq (Llama 3.3) to classify the outcome as Interested or Not Interested. Sends the matching follow-up email via Brevo and updates the Airtable record with the outcome, last-called date, and incremented call attempts. If the call is not answered, sends a “No Answer” email via Brevo and updates Airtable on the first attempt, or sends a final “Dead Contact” email and marks the record Dead Contact on the se
Sync Monday.com board groups and tasks to Airtable using a sub-workflow
Quick Overview This workflow manually fetches all Monday.com boards, retrieves each board’s groups and tasks, and syncs the task details into Airtable using a delegated sub-workflow pattern. How it works Starts manually to initiate the sync. Fetches all boards from Monday.com and iterates through them in batches. For each board, pulls all board groups from Monday.com and enriches each group with board context (ID, name, state, owners, and metadata). Sends the group list to an execute-workflow trigger as a sub-workflow and waits for it to finish processing. In the sub-workflow, flattens the incoming groups into individual group records and iterates through them. For each group, fetches all Monday.com items in that group, formats key fields (owner, status, type, and story points), and upserts them into an Airtable table using “Monday Task ID” as the unique key. Returns a success message to the parent workflow and aggregates per-board sub-workflow results into a combined output. Setup Add Monday.com API credentials with permission to read boards, groups, and items. Add an Airtable Personal Access Token and select the target base and table for upserts. Ensure your Airtable table has fi
Handle LinkedIn inbox RAG replies with Unipile, Claude, Pinecone, and Airtable
Quick overview Automatically ingest your knowledge base, monitor your LinkedIn company page inbox, and reply to leads and customers with AI-drafted, source-grounded answers. Classifies every message, checks for spam, drafts replies using Claude and Pinecone RAG, and lets you auto-send or review each reply in Airtable. How it works A Google Drive trigger watches a folder for new or updated documents, downloading each file automatically as it's added. Each document is split into chunks, embedded, and upserted into a Pinecone vector index, building a searchable company knowledge base. A webhook receives every new LinkedIn message sent to your company page via Unipile, filtering out messages you sent yourself. The last few messages in the conversation are fetched and formatted into a chronological transcript for context. An AI agent classifies the message's intent (lead, support, partnership, recruiting, spam, or other) using shared conversation memory. A second AI agent drafts a reply, searching the Pinecone knowledge base for relevant facts before answering, and saves the draft to Airtable. Depending on a configurable auto-send toggle, the reply is sent immediately via Unipile, or he
Manage IT asset requests and inventory with Airtable and a webhook
Quick Overview This workflow receives IT asset requests via a webhook, logs each request to Airtable, checks stock in an Airtable inventory table, and either approves the request while decrementing inventory or creates an exception record for insufficient stock before returning a JSON response. How it works Receives an IT asset request via a POST webhook. Generates a unique request ID and stores the incoming request body for downstream steps. Creates a new record in Airtable (IT Asset Management base) in the Asset Requests table with the request details and a default Pending status. Searches the Airtable Inventory table for the requested asset type and compares the available quantity to the requested quantity. If stock is sufficient, updates the inventory quantity and updates the Airtable request record to Approved. If stock is insufficient, creates an exception record in Airtable with the reason Insufficient Stock and a Pending Review status. Returns a JSON webhook response indicating either approval or out-of-stock handling. Setup Create or select an Airtable base with tables for Asset Requests, Inventory (including Asset Type and Available Quantity fields), and an Exceptions tab
Log Airtable worklogs to Tempo with Jira and Slack notifications
Quick overview This workflow runs nightly to pull time entries from Airtable, converts Jira issue keys to issue IDs, logs the time to Tempo via its REST API, archives the processed entries back to Airtable, and sends a confirmation message to a Slack user. How it works Runs on a schedule. Fetches all records from the Airtable “Daily Worklog” table. Looks up each entry’s Jira issue by Issue Key to retrieve the issue ID. Builds a Tempo worklog payload (authorAccountId, issueId, start date/time, description, and time spent calculated from start/end times). Sends each worklog to the Tempo to create the worklog entry. Archives each submitted entry into the Airtable “Worklog History” table and deletes the original record from “Daily Worklog”. Aggregates the processed records and sends a direct message in Slack confirming the upload. Setup Connect Airtable credentials and update the base ID and table IDs for “Daily Worklog” and “Worklog History” to match your Airtable setup. Connect Jira Software Cloud credentials with access to the projects/issues referenced by the Airtable Issue Key field. Connect an HTTP Bearer credential using your Tempo API token, and replace YOUR_TEMPO_AUTHOR_ID in
Track Amazon best seller ranks in Airtable with ScraperAPI and Slack
Quick overview This workflow runs daily at 8am to read an ASIN watchlist from Airtable, fetch each Amazon product’s Best Sellers Rank via ScraperAPI, store rank history back in Airtable, and post a consolidated Slack alert when a product’s rank change exceeds a configured threshold. How it works Runs every morning at 8am on a schedule. Searches Airtable for active watchlist items and processes them one at a time. Fetches each product’s Amazon data from ScraperAPI using the ASIN. Parses the Best Sellers Rank text into a numeric rank, calculates the change versus the previous saved rank, and flags items that exceed the watchlist threshold. Creates a new rank-history record in Airtable and updates the watchlist item with the latest rank and check time. Searches Airtable for today’s flagged rank-history records, builds a single digest message, and posts it to a Slack channel if any alerts exist. Setup Add Airtable credentials and select the Base/Table for both the watchlist search, the rank-history create step, the watchlist update step, and the “today’s alerts” search. Ensure your Airtable schema includes a Watchlist table with fields like active, asin, label, rank_threshold, last_ran
Log multi-platform ad spend from Meta, Google, TikTok, and Taboola to Airtable
Quick overview This workflow runs hourly to collect campaign spend, clicks, and impressions from Meta (Facebook), Google Ads, TikTok Ads, and Taboola, then upserts the metrics into Airtable and creates a time-stamped snapshot record for Meta campaigns. Get Implementation help via https://nocode.expert How it works Runs every 60 minutes on a schedule. Builds today’s date values (including a sheet-friendly format and PST-adjusted dates) for use in API queries and Airtable filters. Pulls ACTIVE and PAUSED campaign lists from up to four Meta ad accounts and searches Airtable for existing rows matching today’s date. Matches Meta campaigns to Airtable records by Campaign ID, fetches Meta Insights for each campaign for today, and keeps only campaigns with non-zero spend. Upserts the Meta campaign metrics into the Airtable “Daily Ad Spend” table and creates a separate time-slot snapshot row in a second Airtable table. Retrieves today’s performance data from Taboola (via OAuth token), Google Ads (GAQL query), and TikTok Ads (integrated report), then normalizes the results into a single campaign list. Filters out non-spending campaigns and upserts the remaining Google, Taboola, and TikTok ca
Score and advance job applicants with Airtable, Google Workspace and GPT-4o
Quick Overview This workflow collects job applications via an n8n form, stores CVs in Google Drive, logs applicants in Airtable, and uses OpenAI to score CV-to-role fit. Shortlisted candidates receive an AI-generated questionnaire, a personalized Gmail outreach, an auto-booked Google Calendar phone screen, and saved screening questions. How it works Receives a job application through an n8n form submission, including applicant details and a PDF CV upload. Uploads the CV to Google Drive, builds a normalized applicant record (name, email, phone, experience, CV link), and creates an applicant entry in Airtable. Downloads the stored CV from Google Drive, extracts text from the PDF, and uses an OpenAI-powered agent to score the CV against the job description pulled from Airtable. Updates the applicant’s Airtable record as either “Interviewing” (score ≥ 0.7) or “No hire” (score < 0.7), including the numeric score and short reasoning. For shortlisted candidates, generates five interview questions with OpenAI, presents them in a follow-up n8n form, and saves the candidate’s responses back to Airtable. Uses OpenAI plus Airtable job/candidate context to draft a personalized outreach email, s
Eventbrite Events to Airtable
Manually fetches Eventbrite events via HTTP and stores them in Airtable.
Export Calendar Events To Airtable
On a new Google Calendar event, converts the details to CSV and creates a record in Airtable.
Gmail Emails To Airtable And MySQL
On a new Gmail email, maps the fields and saves the record to both Airtable and MySQL.
Calendar Events To Airtable And Xero
On a new Google Calendar event, converts details to CSV, logs the record in Airtable, and creates a Xero entry.
Sync Calendar Events To Airtable
On a new Google Calendar event, maps the details and creates a record in Airtable.
Webhook To Sheets And Airtable
On an incoming webhook, appends the payload to Google Sheets and creates an Airtable record.
Gmail To Airtable And Sheets
On a new Gmail email, creates an Airtable record and logs it to Google Sheets.
Gmail To Postgres And Airtable
On a new Gmail email, saves the data to Postgres and creates a matching record in Airtable.
Email Alerts To Slack And Airtable
On a new Gmail email, posts an alert to Slack and logs the record in Airtable.
Webhook Calendar Event To Airtable
On a webhook request, creates a Google Calendar event and logs the booking details in Airtable.
Calendar Event To Slack, Email, Airtable
On a new Google Calendar event, posts to Slack, sends a Gmail email, and logs a record in Airtable.