Job Title Freelance Airtable Specialist — AI Media Placement Platform (Automations, AI Prompts, Complex Base) — U.S.-Based Job Description Grassroots Media operates Mosaic Connect — an AI-powered advertising placement platform connecting advertisers with 600+ ethnic and community media outlets across 25+ communities and 40+ languages nationwide. The platform's operational core is a complex Airtable base (36 tables, 818 fields) that drives AI-powered media plan generation, campaign management, insertion order automation, and media outlets profiling. We are seeking a U.S.-based Airtable specialist to join our platform on an ongoing basis — to refine our AI matching logic, optimize automations, and support platform growth as our outlet network and advertiser portfolio expand. This is a senior role for someone who can step into a sophisticated environment and add value from day one.

Seeking an expert to set up tracking details for a nonprofit organization's 45-day Facebook/Instagram campaign using Airtable.com. Responsibilities include creating a tracking sheet, setting up campaign metrics, and ensuring data accuracy. The ideal candidate will have experience in campaign tracking and data management.

We are seeking an experienced Airtable builder to help us implement forms, automations, interfaces, and linked records to optimize our workflow. The ideal candidate will have a strong understanding of Airtable's features and capabilities, allowing for efficient project management and data organization. If you're skilled in creating user-friendly interfaces and automating processes within Airtable, we want to hear from you! Please provide examples of previous projects you've completed in Airtable.

Title: Airtable Expert Needed to Build Content & Marketing Asset Database I’m looking for an Airtable expert and systems-minded operator to build a searchable content database for an established digital education company. This is NOT a social media manager role. This is NOT a content creation role. I need someone who can design and build a system that organizes years of content, marketing assets, automations, emails, and business resources into one searchable Airtable database. The goal is to create a system where content and assets can be easily located, filtered, and reused. Responsibilities: • Design Airtable structure and database architecture • Build dashboards, views, and filtering systems • Create relationships between content, assets, automations, and business resources • Develop a scalable system that can continue growing over time • Import and organize existing assets • Recommend improvements to organization and workflow Requirements: • Advanced Airtable experience • Strong organizational and systems-thinking skills • Experience building databases, knowledge bases, content libraries, or business operating systems • Ability to work independently and make thoughtful organizational decisions • Excellent attention to detail When applying, please include: 1. Examples of Airtable databases you have personally built 2. Any experience organizing content libraries, knowledge bases, digital assets, or creator businesses 3. A brief explanation of how you would organize hundreds of pieces of content, multiple automations, email sequences, and marketing assets inside Airtable This project will begin as a fixed-price project focused on designing the system and organizing core assets.

I’m the owner of a waste paper and scrap commodities brokerage. I need an experienced no-code developer to audit, clean up, and significantly expand my existing Airtable + Softr + DocuPotion system into a professional operations platform. Project Scope: • Review and fix current setup (broken flows, redundancies, etc.) • Build a full trading workflow (Buy/Sell matching, PO/SO, shipments, inventory by grade) • Document generation (Invoices, Packing Lists, Booking Sheets, etc.) • AP/AR, claims, commissions tracking • Professional dashboards and reports • Proper user permissions • Make it clean, scalable, and easy to use Budget: $1,800 – $2,200 fixed price (depending on exact scope and experience) Timeline: Looking for clear milestones and completion within 4–8 weeks. Required Skills: • Strong expertise in Airtable + Softr • Make.com / Zapier automations • DocuPotion or similar document tools • Experience with trading, inventory, or brokerage systems is a big plus Please apply with: • Examples of similar Airtable/Softr projects (especially trading or operations systems) • Your approach and estimated timeline • Any questions about the current setup Serious, professional freelancers only. Prefer someone who communicates clearly and delivers high-quality work.

We're a talent partnerships agency looking for an experienced Airtable and automation expert for an ongoing, flexible retainer role. We need a true problem-solver who looks at our entire business and workflow and designs smart, simplified solutions, not someone who just builds exactly what's asked without considering the bigger picture. We have a high-volume database (300k+ records) with multiple datasets that aren't perfectly connected, and we're running a multi-phase plan to enrich, connect, and automate across all of it. *Immediate project (starting now): Integrating two third-party data APIs into Airtable: - Apollo: ongoing contact enrichment using job-change detection to push updates into staging columns automatically, plus enrichment on new contacts. The more straightforward of the two. - Winmo: pulling verified brand, contact, and agency-to-brand relationship data, matched to our existing records via stored IDs. More involved, since it requires linking incoming data to the correct existing records (some as linked records) rather than creating duplicates. Both feed into staging columns alongside our existing data, with a review-and-approve step before anything updates our live records (non-destructive enrichment). Larger phased plan (where the long-term role goes): The APIs are just the start. From there we're building toward AI-powered data enrichment across our full database, an automated outreach and follow-up system modeled on one we already run, and ongoing automation and workflow optimization across the board. We want someone who can own this roadmap with us, bring expertise we don't have in-house, and simplify a complex system rather than add to it. What we're looking for: - Strong Airtable expertise: analysis, troubleshooting, architecture, and workflow strategy, not just automation building - Strong Make (Integromat) and Zapier experience (required) - Third-party API integration experience (required) - Experience with AI/LLM API integration (OpenAI or similar) and structured data workflows (strongly preferred) - Webflow experience (a plus) - Someone who delivers polished, end-to-end solutions and thinks about the whole workflow, so we're not stuck making endless adjustments down the line - A genuine collaborator who brings ideas and expertise, rather than relying on us to design the solution and just executing it Important on pricing: We're looking for someone who quotes a flat fee per project upfront, based on your own hourly rate and time estimate, rather than billing open-ended hourly. For ongoing support we'd set up a retainer. This structure matters to us, so please confirm you're comfortable working this way. This is a reliable, long-term relationship for the right person, with steady work across data enrichment, AI, and automation. Please share relevant experience with similar Airtable, API, and automation projects, and how you typically structure project versus retainer pricing.

Hi, We're looking for a sharp, tech-savy Airtable Designer/Architect to develop and support operational bases for exciting companies. Must Have: * Experience developing and supporting Airtable bases * Solid understanding of database object modeling * Form creation * Automations * Integration with external systems. * excellent follow through and meeting deadlines.

Project Overview: We are a fast-paced law firm looking to optimize our entire case pipeline from client intake to matter closure. We use Bridge Legal for marketing intake, Clio for our Core Case Management System (CMS), Jubilee for our bankruptcy practice section, Google Calendar for scheduling court events, and Microsoft 365 (SharePoint/OneDrive) for document storage. Instead of building an expensive custom platform from scratch, we want to leverage a low-code automation system (n8n preferred, or Zapier) coupled with advanced AI APIs (such as Anthropic Claude or OpenAI) to handle data mapping, automated drafting, calendar triggers, and text alerts. Airtable will serve as the primary human control panel for our 17 staff members. Mandatory Legal Compliance & Insurance Prerequisites: Due to strict State Bar legal ethics regulations regarding the absolute confidentiality of client proprietary records, data safety is our highest priority. Do not apply if you cannot meet these criteria: 1. NDA: The selected contractor must sign a comprehensive Non-Disclosure Agreement (NDA) prior to receiving system access. 2. Liability Insurance: You must provide verifiable proof of active Professional Liability Insurance (Errors & Omissions) and Cyber Liability Insurance before contract execution. 3. Data Silo Constraints: All workflows must utilize commercial API tiers providing Zero Data Retention (ZDR). Client documents and pleadings must never be used to train public AI models. Key Scope of Automation Tasks: 1. Airtable Control Center: Build out the primary user interface directly inside Airtable, which is already utilized by our 17 staff members. All automated steps (Intake, Pleading Drafting, SMS triggers, and Case Closures) must be launched via Airtable button triggers, attachment fields, and status fields. The automation must capture the Airtable user metadata to maintain an internal audit trail before passing data to Clio. 2. Lead to Retainer: Catch webhook data from Bridge Legal, prompt an LLM to parse raw intake notes for names and deadlines inside Airtable, and automatically trigger a dynamic e-sign contract template (DocuSign/Gavel/HelloSign). 3. Payment to Clio/Jubilee Creation: Listen for payment webhooks (Stripe/LawPay) and use the Clio API to programmatically open the Account, Contact, and Matter. Our bankruptcy section uses Jubilee which is natively connected to Clio via a live sync. The candidate must ensure cases routed through our bankruptcy pipeline are cleanly initiated in Clio so that the native Clio-to-Jubilee data bridge operates smoothly without synchronization lag. 4. AI Answer Generation via SharePoint: Set up an automated folder monitor in Microsoft SharePoint. When a Plaintiff's Complaint PDF is uploaded, the automation must extract the text, run it through Claude 3.5 Sonnet to draft paragraph-by-paragraph denials, append a baseline library of Affirmative Defenses, and save a formatted .docx back to SharePoint and Airtable. 5. Google Calendar to Twilio Reminders: Check our synced Google Calendar daily for court appearances, look up the corresponding client phone numbers using Clio's API, and schedule automated text reminders via Twilio at 30, 7, and 1-day intervals. Implement protective logic (idempotency) to ensure a client is never double-texted. 6. Accounting & Case Closure: Read settlement figures from Airtable fields, query the Clio Expenses API to subtract advanced costs, calculate our firm split using formulas, and automatically execute a Clio API update to switch the matter status to "Closed." Airtable Schema Requirements: The candidate will design a relational, multi-view database structure in Airtable. This database will serve as the primary operational hub, containing tables for: • Table 1: Matters & Intake (Master ledger for lead parsing, case categorization, and user audit stamps). • Table 2: Automation Control Center (Action buttons for contract deployment, e-sign status webhooks, and the AI file drop zones). • Table 3: Settlement Ledger (Calculated currency tracking fields for Gross Settlement, Firm Fee %, Advanced Clio Costs, Medical Liens, and Net Client Payout). The backend code must interact directly with Airtable fields to manage state progression, receive user tracking data, deposit AI-generated documents, and pull transaction balances. Required Experience & Technical Proficiencies: • Proven track record building multi-step automations inside n8n or Zapier. • Experience authenticating and mapping data variables natively via the Clio API (v4), Google Calendar API, and Microsoft Graph / SharePoint API. • Demonstrated experience handling structured JSON payloads and dealing with API rate limits. • Strong understanding of AI prompt design for accurate textual parsing and document structural layout.

We are seeking a skilled freelancer to develop an API integration between HouseCanary and Airtable. The project involves creating a seamless connection to enhance data management and automation. The ideal candidate will have experience in API development and real estate data integration. This is a part-time engagement with a short-term duration.

We are seeking a highly organized Marketing Operations & Campaign Coordinator to support recruiting, retention, and growth marketing initiatives. This is a hands-on execution role focused on campaign management, marketing automation, CRM administration, reporting, and operational excellence. The ideal candidate is comfortable working across multiple systems, building campaigns, troubleshooting workflows, managing project timelines, and ensuring marketing programs launch successfully from start to finish. This is not a social media coordinator position. We are looking for someone who understands marketing operations, campaign execution, automation, and performance tracking. Responsibilities • Build and execute email campaigns in ActiveCampaign • Create and maintain automations, nurture sequences, and audience segmentation • Manage webinar, event, recruiting, and retention campaigns • Build and update landing pages, forms, and campaign assets • Maintain CRM records and workflows within Follow Up Boss • Coordinate campaign deliverables with internal teams and external vendors • Manage Airtable project plans and campaign timelines • QA forms, automations, lead routing, and conversion tracking • Pull and organize campaign performance reports • Assist with lead management, tagging, segmentation, and pipeline reporting • Support ongoing optimization efforts across marketing channels Required Experience • ActiveCampaign (required) • Marketing automation • Email marketing • CRM management • Campaign execution and project coordination • Analytics and reporting • Landing page management • Canva • Strong attention to detail and follow-through Preferred Experience • Follow Up Boss • Airtable • GA4 • Zapier • Looker Studio • Real estate, recruiting, or sales-focused organizations What Success Looks Like • Campaigns launch on time with minimal oversight • Marketing automations are maintained and optimized • Lead data is clean and actionable • Reporting provides visibility into campaign performance and pipeline impact • Recruiting and retention initiatives are supported through consistent execution • Marketing systems operate efficiently and scale with business growth Application Instructions Please provide: 1. Examples of ActiveCampaign automations you have built 2. CRM platforms you have managed 3. Examples of campaigns you personally executed from start to finish 4. Experience with Follow Up Boss, Airtable, Zapier, or reporting tools 5. Your hourly rate and availability Candidates with strong ActiveCampaign experience and marketing operations backgrounds will be prioritized.