- Hourly: $25.00 - $52.00
- Intermediate
- Est. time: More than 6 months, 30+ hrs/week
I'm an AI automation expert with a growing roster of clients, and I'm bringing on a skilled freelancer to help handle the smaller projects so I can keep up with demand. This isn't a new or one-off operation. I work with many clients already, and bring on new ones every week. I'm looking for someone reliable I can hand work to consistently, not just for a single project. You should be comfortable building AI automations independently and delivering clean, working solutions for client-facing work. To apply, please: - Send a short Loom introducing yourself - Share examples of your previous automation work I review every application personally, so a quick, genuine intro goes a long way. If we're a good fit, there's steady, ongoing work here.
- Hourly: $30.00 - $50.00
- Intermediate
- Est. time: 1 to 3 months, Less than 30 hrs/week
We are a small estate planning law firm in Texas looking for a Lawcus CRM + Zapier/Make consultant to help with a controlled workflow cleanup and implementation project. We already have internal project-management support and a draft cleanup framework. We are not looking for a general operations consultant or someone to redesign everything from scratch. We are looking for someone with CRM automation experience who can help verify what is currently live, troubleshoot Lawcus/Zapier/Make issues, and execute narrow approved technical tasks. This is a law firm environment, so confidentiality and careful change control are very important. Initial Project The initial engagement will be a small paid test project of approximately three to five hours. The goal of the test project is to review one limited part of our Lawcus/Zapier setup, identify what is live, flag risks or issues, and recommend or complete only approved changes. Possible systems involved include: * Lawcus CRM; * Zapier or Make; * DecisionVault; * OpenPhone; * Google Drive; * Dropbox Sign; * ClickUp; * scheduling tools; * Missive or Gmail. Initial work may include: 1. Reviewing our existing Lawcus Inventory Sheet and Matter Hygiene/Cleanup Handoff; 2. Verifying selected items against the live Lawcus setup; 3. Identifying which stages, task templates, automations, fields, tags, and integrations are currently live; 4. Flagging anything outdated, duplicative, unclear, risky, or dependent on a former team member; 5. Reviewing Lawcus/Zapier/Make automations for reliability or broken connections; 6. Helping implement only specific approved changes; 7. Documenting all changes made; 8. Providing a short written summary and, if helpful, a Loom/video walkthrough. What This Project Is Not This is not: * a broad operations role; * client communication; * legal judgment; * a full CRM rebuild; * bulk editing without approval; * deleting or changing live automations without approval; * independent decision-making about client matters. No broad live changes should be made without written approval. Required Experience Please apply only if you have experience with at least some of the following: * Lawcus CRM; * Zapier or Make; * CRM pipeline/stage cleanup; * workflow automation mapping; * law firm CRMs or professional-services CRMs; * intake workflows; * task/template cleanup; * Google Sheets or Excel-based audit tracking; * clear documentation of system changes. Lawcus experience is strongly preferred. If you do not have Lawcus experience but have strong CRM + Zapier/Make experience, please explain why your experience transfers well. Ideal Candidate The ideal person is: * detail-oriented; * careful with confidential information; * comfortable documenting every change; * willing to work from an existing plan; * able to say “this needs approval before changing”; * not someone who makes broad changes first and explains later; * good at translating messy CRM workflows into clear technical next steps. Budget / Structure This will be hourly. I would like to start with a small paid test project capped at three to five hours unless additional time is approved in writing. If the test project goes well, there may be additional implementation work. Questions for Applicants Please answer these in your proposal: 1. Have you worked directly in Lawcus before? If yes, what did you do? 2. Have you built or reviewed Zapier/Make automations connected to a CRM? 3. Have you worked with a law firm or another confidential professional-services business? 4. How would you approach this project without making risky live changes? 5. What would you want to review first: pipelines, task templates, automations, fields/tags, or integrations? Why? 6. Are you comfortable documenting every change and providing a short written summary or Loom walkthrough? 7. What is your hourly rate, and how many hours would you suggest for an initial review/test project? Deliverable for Initial Test Project At the end of the initial project, I want: * a verified list of what is currently live in the selected Lawcus/Zapier workflow; * recommended keep/revise/delete/defer items; * a list of risks or unknowns; * a list of changes made, if any; * a list of changes that require approval before implementation; * and a recommended next implementation step.
- Hourly: $20.00 - $40.00
- Intermediate
- Est. time: 1 to 3 months, Less than 30 hrs/week
We are seeking a skilled freelancer to create and manage Zapier zaps and automations for our construction company. The ideal candidate will have experience with QuickBooks Online and JobTread, and be able to streamline our workflows by automating tasks. Responsibilities include setting up new zaps, troubleshooting existing ones, and optimizing automation processes to enhance efficiency. If you have a strong understanding of construction-related workflows and can effectively use Zapier to improve our operations, we would love to hear from you.
- Fixed price
- Expert
- Est. budget: $2,000.00
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.
- Hourly: $35.00 - $70.00
- Intermediate
- Est. time: 1 to 3 months, Less than 30 hrs/week
# Zapier & AI Automation Specialist for Growing Coffee Catering Company ## Overview Pretty Good Coffee Company is a premium mobile coffee catering company based in Raleigh, NC. We serve corporate events, employee appreciation events, universities, weddings, brand activations, and private events throughout North Carolina. We're looking for an experienced automation specialist to help us build practical systems using Zapier, AI tools, Gmail, and our existing software stack. Our goal is not simply to automate tasks. We want to create systems that improve client experience, increase sales conversion, reduce administrative workload, and help us scale operations without sacrificing hospitality. ## Primary Project: Quote Follow-Up Automation Our highest priority is building an automated quote follow-up system. Current workflow: * Lead submits inquiry * Quote is created and sent through booking platform * Follow-up is currently handled manually Desired workflow: * Detect when a quote is sent * Extract relevant quote details * Use AI (Google AI Studio/Gemini) to generate personalized follow-up emails * Create Gmail drafts (not auto-send) * Trigger additional follow-ups after specific time periods * Maintain a natural, human, hospitality-focused tone We have already begun building this workflow but need an expert to finish and optimize it. ## Future Automation Opportunities After the initial project, we'd like help building additional automations such as: ### Sales * Lead response automation * Quote follow-up sequences * Lead scoring and prioritization * Client re-engagement campaigns * CRM updates and pipeline tracking ### Operations * Automatic event briefs * Staff communication workflows * Event assignment notifications * Calendar and scheduling automations * Inventory forecasting ### Marketing * Review request automation * Testimonial collection * Client nurture campaigns * Social media/content workflows * Monthly reporting dashboards ### Executive Reporting * Weekly business summaries * Lead tracking * Conversion reporting * Revenue dashboards * Operational KPI reporting ## Current Tech Stack * Flashquotes * Zapier * Gmail / Google Workspace * Google AI Studio (Gemini) * Google Sheets * Google Drive Additional platform recommendations are welcome if they simplify operations. ## What We're Looking For * Strong Zapier experience * Experience with AI integrations (Gemini, OpenAI, Claude, etc.) * Experience troubleshooting API and webhook workflows * Ability to think through business processes, not just build automations * Clear communication and documentation * Ability to recommend simpler solutions when appropriate ## To Apply Please include: 1. Examples of similar automation projects you've built. 2. Your approach to quote follow-up and sales automation. 3. Your preferred hourly rate or fixed-price estimate for the initial project. 4. Any recommendations you would make based on the information above. We're looking for a long-term automation partner, not just a one-time freelancer.
- Hourly: $90.00 - $110.00
- Expert
- Est. time: More than 6 months, 30+ hrs/week
Univium (small-business consultancy) is hiring a part-time Consulting Lead to own client problems end-to-end: lead discovery calls, scope and design solutions, write dev briefs (Jira), review deliverables, and draft proposals. Start 5 hrs/week, scale to 10 then 20. Hire needed within 3–4 weeks. Hours & Rate - Start: 5 hrs/week; scale to 10 → 20 as proven - Rate: $90–$110/hr (final rate based on experience/fit) - Location: US-based only (required) - Timeline: must be available to start within 3–4 weeks Key responsibilities - Lead or co-lead 1–3 client discovery/consultation calls weekly - Scope client problems, design fit‑for‑purpose solutions, write clear Jira cards/dev briefs - Review dev output, manage handoffs, and communicate results to clients - Draft proposals with hourly estimates and confidence levels for owner review - Self-onboard to new clients by mining notes, recordings, existing systems - Flag high-risk/low-confidence work proactively What this role is NOT - Not responsible for writing production code (in-house devs implement) - Not responsible for owning sales or managing other consultants initially Success outcomes (first 6 months) - Help scale active clients from 3 → 5–6 without increasing owner hours - Independently move 1–2 projects/week from scope → dev handoff or run 2–3 consultations/proposals weekly - Owner spends time on risk-review/high‑stakes oversight, not solution generation - Minimal hand‑holding required for onboarding; interactions are net relief for owner - Documented process to onboard a second consultant by month 6–9 Required qualifications - US-based with flexible scheduling for client calls - 5+ years working with small businesses (SMB experience required) - Hands-on familiarity with at least 4 of: Airtable, Notion, Zapier / N8N / Make, Google Apps Script, Lovable / Replit - Strong client-facing experience (leading discovery, managing expectations) - Proven portfolio of end-to-end SMB projects (scoping → solution → handoff) - Excellent at writing dev briefs / Jira tickets and delegating execution - Strong strategic problem-solving and calibrated risk awareness - Available to ramp to 10 hrs/week on 1–2 weeks' notice Screening filters (what we’ll prioritize) - Clear portfolio of solved SMB problems, ability to justify tool choices - Evidence of self-directed initiative and minimal ramp-time hires - Comfortable working via Upwork (time tracker), available within 3–4 weeks - NOT a pure executor, enterprise-only consultant, or non-US-based How to apply Submit via Upwork with: - Relevant hourly rate expectation within $90–$120/hr - Short cover note (1–2 paragraphs) summarizing why you fit this role - 2–3 portfolio examples of SMB problems you’ve solved end-to-end (links or brief case studies) - Your earliest availability to start - We’ll screen on Upwork, present finalists to the owner. Owner will interview top candidates (30–45 min). Selected candidate starts at 5 hrs/week. Owner note to candidates: We need someone who makes the owner’s life easier from week one — minimal hand‑holding, strong judgment, clear communication. If that sounds like you, please apply.