Job Description: We are a dental office serving as a VA (Veteran’s Affairs) Community Care provider. We are seeking an experienced Microsoft 365 and Power Automate expert to design and deploy a secure, HIPAA-compliant referral tracking system. Our current workflow receives critical, password-protected incoming patient referral emails. We need to automate the extraction of this data and feed it into a centralized tracking dashboard. Key Scope of Work: 1. Automated Extraction: Create a Power Automate flow that monitors a shared inbox, handles/decrypts incoming password-protected referral notifications, and extracts key patient metadata. 2. Database & Dashboard Setup: Build a secure tracking system using Microsoft Lists (or Excel Online) configured with distinct operational phases: -Intake Data: Veteran Name, Date Received, Authorization #, Auth Expiration Date, and Approved Treatment lines. -Scheduling Logs: Contact Status dropdowns, Contact Dates, Scheduled Appointment Dates, and VA Notification Checkboxes. -Clinical Follow-up: Tracking for post-exam Pre-Authorizations (Submission Date, Status, Expiration). 3. Security Compliance: Ensure all flows and data storage operate strictly within our secure Microsoft 365 cloud environment to maintain strict HIPAA compliance. Required Qualifications: -Proven track record building enterprise-grade workflows using Microsoft Power Automate and Microsoft Lists/SharePoint. -Experience working within HIPAA-compliant infrastructure or handling sensitive/encrypted data. -Ability to provide a short training documentation or training video for our front-office staff and Doctor. Please share examples of similar automated tracking workflows you have built when applying.

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'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.

We are seeking a skilled freelancer to automate two Excel sheets so they can feed data to each other. The ideal candidate will have experience in creating interactive Excel systems and be proficient in Visual Basic for Applications. This project requires attention to detail and the ability to deliver a seamless data exchange between the sheets. If you have a strong background in Excel automation, we would love to hear from you!

I'm building "Autopilot My Brand" a multi-client SaaS platform that automates personal branding by scheduling and auto-posting content to social media for multiple users/clients. Looking for an experienced developer with real multi-tenant SaaS experience. I want to launch in phases: a lean Phase 1 MVP first, then expand. Phase 1 (target: 1-3 months) core MVP: -User signup/login and per-client dashboard (basic multi-tenant setup isolated accounts/data) -Connect social accounts via OAuth, starting with 1-2 platforms (Instagram + TikTok, or your recommendation) -Upload/input content (text, image, video) and schedule posts -Auto-posting engine that publishes on schedule via the platform API(s) -Basic paid signup/access (simple Stripe integration doesn't need to be a full billing system yet) Phase 2 (later, scope/timeline TBD based on Phase 1 results): -Additional platforms (LinkedIn, X) -Full subscription/billing system with plans, upgrades, cancellations -Admin panel for me to oversee all client accounts -Expanded analytics per client What I'd like from you in your proposal: -Your experience building multi-tenant SaaS products (not just single-user apps) please share examples -Relevant experience with social media API integrations (Meta/Instagram Graph API, TikTok API), since platform approval/rate limits are often the biggest bottleneck -Experience integrating Stripe or similar payment systems -Your recommended approach (framework/stack) and why -Your estimated timeline and cost for Phase 1 specifically, quality and the right experience matter

We're a 30-year, family-owned home improvement company in Michigan. We run a modern but disconnected software stack and we're looking for a developer to connect the pieces, automate manual work, and build reporting that actually gets used. This is project-based contract work to start, with steady ongoing work for the right person. Not a full-time role. What you'd be working on: Our tools don't talk to each other and too much still runs on manual data entry and spreadsheets. We want someone who can look at a workflow, find the bottleneck, and build the fix. Examples of projects on our list: Replace an antiquated Google Sheets scheduling system with something modern and connected Build and maintain integrations between our core tools (CRM, call tracking, phone, accounting) Build BI and reporting dashboards that pull from multiple sources into one clear view Automate manual data entry, lead routing, and reporting tasks Set up AI-assisted tooling where it makes sense (call summaries, automated reporting, data cleanup) Our stack: JobNimbus (CRM, system of record) CallRail (call tracking, ~50 numbers) RingCentral (phone) Rilla (sales conversation analysis) QuickBooks (accounting) Google Ads and Facebook Ads Google Sheets / Google Workspace You should have: Strong experience with API integrations and connecting SaaS tools (Zapier/Make is fine for some of it, but we want someone who can write custom code when the no-code tools fall short) Experience building reporting dashboards or BI tools Comfort with one or more CRM platforms (JobNimbus experience is a big plus) Ability to scope a problem, propose a solution, and ship it without heavy hand-holding Clear written communication and the ability to explain technical work to non-technical people Nice to have: Experience with JobNimbus, CallRail, RingCentral, or QuickBooks specifically Experience building AI-assisted workflows (LLM-based summaries, data extraction, etc.) Experience in home services, construction, or contracting businesses

I need an expert on Co pilot studio with a specific focus on agent optimization workflows. I have a handful of agents I need to work in parallel with one another and funnel up through a hierarchy to the master agents above. Looking to consult an expert to make this flow seamless, fast, and accurate for a project. Thanks!

Deliverable Requested from Developer Build a Google Workspace solution that: 1. Monitors incoming emails in slab-sewer@, rough@, and trim@ 2. Uses AI (Gemini, OpenAI, or similar) to classify severity and category 3. Automatically applies Gmail labels 4. Marks RED items as important 5. Runs automatically every few minutes 6. Requires no action from Project Coordinators Success Metric: A Project Coordinator can open their inbox and instantly identify which emails require immediate action versus which can wait until later in the day, without manually reading and sorting every message.

We are a mid-size wholesale furniture distributor that recently went live on NetSuite, migrating from a legacy ERP. The implementation is stable and transaction volume is high — heavy EDI order flow (Orderful integration), a WMS integration for warehouse operations, and thousands of orders per month across wholesale, e-commerce, and drop-ship channels. We're looking for a senior NetSuite consultant to provide ongoing post-go-live support and to lead the redesign of several accounting-side processes that were implemented quickly during the project and now need to be done right. What you'd be working on: Commissions — Our current commission process is largely manual and needs a proper design: paid-date-based calculations, multiple channel types (warehouse, direct/drop-ship, parts), and clean reporting. This is the first major redesign project. Freight and truckload costing — We ship significant truckload volume. Freight cost estimation vs. actuals, landed cost handling, and margin visibility need rework. Invoicing and billing workflow — Billing today depends on manual gates and review steps. We want to streamline the shipped-to-invoiced pipeline and reduce lag without losing controls. General ticket support — A steady stream of production issues: script errors, SuiteTax edge cases, EDI transaction failures, integration hiccups. You'd triage, root-cause, and fix. Required skills: Deep NetSuite accounting knowledge (billing, AR, costing, commissions, SuiteTax) SuiteScript 2.x (User Event, Map/Reduce, Scheduled) — you can read and debug existing scripts, not just write new ones SuiteQL and saved search fluency REST/SOAP web services experience Wholesale distribution industry experience strongly preferred EDI familiarity a plus