AppSheet development · Workflow automation · UI/UX

No-code systems that look and work like premium software.

I'm a software developer in Nigeria who builds on AppSheet: data modeling, automation and interface design, end to end. Below is King's Presence, a church attendance and engagement platform I designed and built from scratch.

View the case study Get in touch

Available for remote AppSheet projects worldwide

28attendance sessions run (27 closed, 1 live)

16members tracked live in a single session

12souls logged by the top follow-up leader

7connected modules, one data backbone

What I do

Three things, usually in combination.

AppSheet App Development

Data models, security filters, actions, bots and formulas, built to hold up once real people use the app every day.

Workflow Automation

Bots, scheduled reports and status locks that remove the manual steps people were doing by hand before.

UI/UX for No-Code

Custom theming, layout and information hierarchy that take an app past the default AppSheet look.

Case study

King's Presence

An attendance and member-engagement platform for churches, built end to end on AppSheet, from the data model to the branded interface.

Platform: AppSheet + Google Sheets Role: Solo developer & designer ● Live, in active use

The problem

Churches, and most member-based organizations, track attendance on paper registers or scattered spreadsheets. There is no visibility into trends, no structured way to welcome and follow up with first-time visitors, and reporting means someone manually compiling numbers after every service.

The system

King's Presence turns that into one app: session-based attendance capture, a visitor follow-up pipeline, live analytics and automated PDF reporting, designed as a proper branded product rather than AppSheet's default styling.

Mobile view

On the phone

The app as staff use it on a service day. Tap any screen to enlarge it. A desktop view of the same app follows below.

Live dashboards & analytics

The home screen surfaces quick actions and per-ministry live status at a glance. Attendance percentage, weekly trendlines and a gamified "Soul Winners" leaderboard are computed through virtual columns and rendered as chart images, with no separate analytics database to maintain.

Home dashboard with greeting banner, quick actions and ministry dashboard — Home dashboard & quick actions

Top Soul Winners podium showing three leaders — Gamified follow-up leaderboard

Weekly attendance line chart with a trendline — Weekly attendance trend

Attendance sessions

Each service is a session: open it, mark who is present, close it. A session-lock automation blocks new entries once a session closes, and present, absent and attendance-percentage figures recompute live as records come in.

Record Attendance form with session name, date and an Open or Closed status switch — Open / close a session

Session list with an open service and closed services — Session list, grouped by status

Session summary with attendance gauge and present, absent and total counts — Live session summary

Member management

Every member has a structured record with cell group, PCF, contact details and an address geocoded for outreach planning. Absentees surface automatically per session, so follow-up never depends on memory.

Session screen listing absent members — Automatic absentee list

Structured member profile

Map with a pin on a member's geocoded address — Geocoded addresses

Visitor pipeline & reporting

First-time visitors are captured with who invited them, then routed into a follow-up pipeline. A report bot compiles each session into a branded PDF, ready to send without anyone building it by hand.

Register First Timer form — First-timer registration

Attendance Report record with report type, ministry and a PDF preview — Auto-generated PDF report

Desktop view

On a desktop browser

One AppSheet build serves both screens. On a wide display the same data opens as a workspace, with lists on the left and live detail beside them. Tap any screen to enlarge it.

Home dashboard on desktop with live summary gauge, quick actions, weekly attendance chart, Soul Winners and ministry dashboard — Home dashboard: live summary, quick actions, weekly trend, Soul Winners and per-ministry status side by side.

Session list beside the open service's attendance gauge and present member list — The open service: 11 present out of 16, with the present-member list beside the session list.

Closed special service with a 60 percent average attendance gauge — A closed service with its attendance gauge, present, absent and total counts.

Member directory with the full profile open: cell, PCF, role, contact details and total sessions.

Sessions grouped into one open and 27 closed, shown as cards — Sessions grouped by status: 1 open, 27 closed.

Demonstrated in this build

What's actually under the hood.

Virtual columns & formulas Security filters & user roles Bots & session-lock automation Google Sheets data architecture Custom brand theming Geolocation integration Chart-based data visualization Automated PDF reporting Google Apps Script Automated email

Proof of build

How it's built, and that it runs

Screenshots from the live King's Presence app, its Google Sheets database and its Apps Script automation. Tap any image to enlarge it.

Client data protected. These come from the live production app, so the records are left unchanged. Email addresses, file IDs and the church's name are blurred, and those images are marked "Data blurred".

Data model

Tables for members, sessions, attendance, first timers, reports, PCFs and cells reference one another. Slices filter the data for each ministry and role.

AppSheet relationship graph showing tables, slices and views connected by references — AppSheet's relationship graph: tables (squares), slices (diamonds) and views (circles) connected by references.

AppSheet expression that selects ministry members with no attendance record for the session — Absentee logic: members of the session's ministry who have no attendance record for that session.

AppSheet Members table with 53 columns and formula columns such as Total Sessions, Session Attended and Soul Count — Members table, 53 columns. Formula columns such as Total Sessions, Session Attended, Members Attendance % and Soul Count are computed from related attendance and first-timer rows.

Database records

Google Sheets is the database. Each table is a sheet that the app reads and writes directly.

Google Sheet of generated reports with report type, ministry, session, timestamp and PDF path; email and file ID columns blurred — Reports sheet: one row per generated report, with type, ministry, session, time and PDF path. Generator emails and Drive file IDs are blurred.

Google Sheet of attendance sessions with status, final attendance percentage and a line chart — Attendance Session sheet: 28 sessions with status, final attendance % and open and close times, plus a trend chart drawn from the same rows.

Automation

A Google Apps Script finds each generated report PDF in Drive and saves its file ID against the report row, so the app can open the file. First-time visitors get a branded welcome email.

Google Apps Script function updateReportFileIDs reading the Reports sheet and searching Drive for each PDF — updateReportFileIDs in Apps Script: reads the Reports sheet, skips rows that already have a file ID, and looks up the PDF in Drive by file name.

Apps Script dashboard showing a 0.09 percent error rate and 9,763 executions in 7 days — Apps Script dashboard for the last 7 days: 9,763 executions with a 0.09% error rate.

Dark branded welcome email thanking a first-time visitor and describing next steps — Welcome email sent automatically to a first-time visitor. The church name is blurred.

Data visualization

Charts and cards are built from formulas inside the app, so there is no separate analytics tool to maintain.

AppSheet expression that builds a chart image URL for a line chart — Chart image built by an expression: AppSheet assembles a QuickChart URL and shows the result as an image column.

AppSheet expression that draws an animated SVG leaderboard card with a member's name and attendance percentage — Leaderboard card drawn as an animated SVG inside an expression, filled with each member's name and attendance percentage.

For clients & agencies

Where I can plug into client work.

New AppSheet builds

From a spec or a rough brief to a working app: data model, actions, security and automations.

UI/UX overhauls

Taking an existing app out of default AppSheet styling into something that reads as a real product.

Workflow automation

Bots, scheduled reports and status locks that take repetitive manual steps off a client's plate.

Dashboards & reporting

Live analytics layers and auto-generated reports built on top of data a client already has.

Why work with me

Ships full systems, not fragments: data model through to polished interface.
Thinks like a product owner. King's Presence shipped with its own roadmap and pricing strategy, not just a one-off build.
Comfortable owning a build end to end, or slotting into an agency's existing workflow.
Based in Nigeria, remote-ready, working with clients worldwide and flexible across time zones.

Let's build something together.

Available for AppSheet projects with clients and agencies worldwide: new builds, UI/UX overhauls, automation and reporting. Send a short description of what you need.

partnerovie@gmail.com