Artist Career Management Agency: Airtable Restructure and Client Portal

Airtable for Agencies: Restructuring an Artist Career Management Agency

This Airtable for agencies case study follows an artist career management agency that helps visual artists grow their careers. The team researches opportunities like open calls and residencies, prepares and submits applications, writes on artists’ behalf, and runs their social media content and newsletters. When the agency came to me, its Airtable, a shared database that works like a spreadsheet with connections between its lists, had grown one client at a time, until every change to the system had to be made 23 times over. I audited it, brought everything into one base, and built the client portal, team workspaces, automations, and forms that the team and its artists use every month.

Airtable for agencies: results at a glance

• Service: Done-For-You Airtable Setup
• 23 separate client bases, each with around 10 tables, consolidated into one base with 13 linked tables
• An estimated $700 a month in software costs saved, from a monthly Airtable bill of around $800
• 37 live automations for approvals, reminders, assignments, and digests as of October 2026
• 12 interfaces for clients, team members, and the owner, replacing 23 separate client portals
• 4,400+ client projects tracked, including 1,900+ opportunity and submission projects

Service Provided

Done-For-You Airtable Setup with custom interfaces and dashboards

About the Business

The agency works with visual artists on two kinds of plans. Retainer clients get ongoing support every month, while à la carte clients request specific projects only in the months they need help. Either way, each month starts with the artist telling the team what they want to focus on: which opportunities to apply for, which writing or email projects they need, and what they want to post on social media.

A small team then researches, drafts, reviews, and submits that work on the artist’s behalf. Different people handle research, submissions, writing, newsletters, websites, social media, and one-on-one consultations, so a single artist’s month can pass through several hands. The agency was also moving away from a model built around a few contractors and needed systems that could carry a bigger team.

The Problem

Before I came in, the agency ran each artist from a separate Airtable base. There were 23 of them, one per client, and each held around ten tables of its own for projects, contacts, support tickets, and more. The setup had grown out of an earlier system in Notion that could not show each artist only their own information, so giving every client their own base was the workaround that kept client access private.

That held up until the agency needed to change anything. Adding a field, fixing a status, or improving a process meant making the same change 23 times, by hand, in 23 places. There was no single view of everything in progress across clients, so seeing who was doing what meant opening base after base. And because artists needed to edit their own content and update statuses, each of them needed a paid seat, which pushed the monthly Airtable bill to around $800.

Monthly requests came in different ways, and assignments were handed out by hand. Every new artist added another base to maintain, and every new team member made it harder to keep track of who was responsible for what.

What I Built

An audit, then one base

I started by auditing the existing bases to see what each table held and how the team actually used it. Since every client’s base held the same kinds of lists, the clearest path was to bring all of them into one base and connect each record, meaning each row of information, to the artist it belongs to. From then on, one change would update the system for every client at once.

In the new structure, every artist has one record that is connected to their projects, monthly check-ins, social media posts, support tickets, uploaded files, and call notes. I put every type of work into a single projects table, from opportunity research and submissions to writing, direct email, newsletters, websites, and consultations, so the agency can report across all of it instead of piecing numbers together from different places.

We rolled the system out in two parts. The social media content system came first, and the opportunity and submission work was layered in next. The agency chose to hold the launch until both were ready, so artists would step into one complete system instead of two half-finished ones.

Private client access without paying for extra seats

The biggest design decision was how artists would get in. Airtable interfaces are custom screens built on top of the base, and they can be set to show each person only the records connected to them. That meant 23 separate client portals could become one shared portal where each artist sees only their own work.

The remaining problem was editing, because Airtable’s built-in forms can only create new records and cannot change existing ones. I used Fillout, a form tool that connects to Airtable and can update a record that already exists, so artists can approve a post, request edits, or update their profile through a form while keeping a free, view-only account. When we reviewed the finished content system together, the estimated savings came to about $700 a month, from removing paid editor seats for clients and team members and moving the agency’s social media scheduling onto a single account.

A monthly check-in that drives the work

Each month, artists tell the team what they want through a check-in form. They pick the opportunities they want to apply for, choose their writing and email projects, select their posts, and can ask for a one-on-one call. The base sends the reminders on a set schedule: an invitation on the 23rd, a reminder on the 28th to anyone who has not responded, and a last call on the 3rd of the following month. À la carte clients get their own invitation and reminder, since they only request work in the months they choose.

When a check-in comes in, the base turns it into work. Research the artist decided to pursue becomes a submission project, a deadline is filled in wherever one is missing, the people who handle submissions and social content are notified, and new projects are assigned to the right team member based on the type of work. If the artist asked for a consultation, they get a message with a link to book time with the right person.

Automations for assignments, approvals, and reminders

Automations are rules that run on their own when something changes in the base, and they carry most of the hand-offs between people. When a writer finishes a social media post, it goes to an internal reviewer. If the reviewer asks for changes, the post goes back to the writer, and if it is ready, it goes to the artist for approval. Submissions follow a similar path from setup, to drafting, to review, to finalizing and submitting, and each time a project moves forward, the next person in line is told what to do and where to do it.

Reminders now do the chasing that used to fall on the team. Artists get a reminder twelve days before a submission deadline if their draft is not finalized yet, and a weekly last call for any posts scheduled for the following week that they have not approved, because the agency never posts anything without the artist’s approval. When an application is submitted, the artist gets a message letting them know.

Digests pull everything into one message instead of dozens. Each artist receives one daily message listing the posts waiting for their review, the content team gets a morning summary of everything artists approved or sent back for edits, and a weekly digest lists the posts that still need to be written. Artists can also ask to swap a scheduled post for a different one using a form that only shows posts at least two business days away, which gives the team time to make the change.

Interfaces for clients, the team, and the owner

Artists use one client portal where their posts and projects are color coded by status, so it is easy to see what is waiting on them. Once a post is approved, the option to review it disappears, which prevents last-minute edits to content that is already scheduled. For the team, the base combines each caption and its hashtags into one block of text they can copy and paste straight into their scheduling tool.

Team members each have a workspace that shows only the artists and projects assigned to them, and they update their own profiles through a form. Contract writers have their own portal, and the owner has an executive view of every artist, project, and opportunity across the agency. In total there are 12 interfaces, each set up so people see what they need and nothing else, and access is organized so the agency does not pay for seats it does not need.

Handoff and training

Before launch, the team tested the system and we made changes from their review, such as renaming the client form to “Review Content” so its purpose was obvious and adding a separate box for general revision notes. The team also got walkthrough videos and onboarding so they could run the system day to day without me.

The Results

The agency now runs every client from one base. A change to the system is made once instead of 23 times, the monthly check-in turns straight into assigned work, and artists review and approve their own content through a portal and forms without needing paid seats. As of October 2026, the base holds more than 4,400 client projects, including more than 1,900 opportunity and submission projects, with 37 automations running behind them.

• One base for every client, project, and post, in place of 23
• Monthly check-ins turn into assigned work automatically
• Clients review, approve, and update their own work through a portal and forms
• The team sees what is due through digests and reminders instead of chasing updates
• Access is organized by role, with an estimated $700 a month saved on seats and software

Frequently asked questions

Can Airtable run a client portal for an agency?

Yes. This agency’s artists use an Airtable interface to review and approve their work, and forms to update their own records, without needing paid access to the base itself. Each artist sees only their own posts and projects, even though every client lives in the same base.

Related case studies and reading

• Case study: Live Wilder Studio: an Airtable dashboard fed by Dubsado
• Read: Airtable: A database in a spreadsheet
• Read: The Ultimate Tool for Managing Your Business and Life

Has your Airtable grown piece by piece?

I audit and restructure Airtable systems so they work for your clients and your team. Start with Airtable setup or a Done-For-You Airtable Setup.