Google Workspace Automation & Operations System Developer (Google Sheets, Google Forms & Apps Script)

Job Description
About ClearPath Community Services

ClearPath Community Services is a Virginia-based provider supporting youth and adolescents with intellectual and developmental disabilities through Sponsored Residential services.

We're building our internal operational systems from the ground up and are looking for someone who enjoys creating organized, intuitive workflow systems using Google Workspace.

This is not simply a spreadsheet project—we're building an internal operations workspace that will become the central hub for our Sponsor Coordinator. This system will become the primary workspace used by our Sponsor Coordinator. Rather than simply tracking Sponsors, it should guide the Coordinator through each stage of our Sponsor Intake Process by presenting the appropriate information, tasks, checklists, and next steps based on the Sponsor's current stage.

Project Overview

We are looking for an experienced Google Workspace developer to build a custom Sponsor Workspace using Google Sheets, Google Forms, Google Drive, and Google Apps Script.

The system will manage prospective Sponsor Residential Providers through our Sponsor Intake Process, from their initial inquiry through final approval.

Our goal is to create a workspace where a Sponsor Coordinator can manage the entire Sponsor journey without constantly switching between multiple documents.

Core Workflow

The system will follow our 10-stage Sponsor Intake Process:

Lead Received
Discovery Call
Sponsor Interest Questionnaire
In-Person Sponsor Qualification Meeting
Sponsor Application
Screening Interview
Home Assessment
Document Collection
Sponsor Training
Executive Review & Approval

The current stage should drive what the Coordinator sees and works on.

Version 1 Features

We're intentionally starting with a lean Version 1.

Features include:

Sponsor Workspace

A dynamic workspace where the Coordinator selects a Sponsor and can view:

Contact Information
Current Stage
Stage Progression
Stage Checklist
Next Action
Next Meeting
Meeting Notes
Document Status
Google Drive Folder Link
General Notes
New Lead Intake
Connect to existing Google Form
New submissions enter a New Leads queue
Duplicate detection
Manual review
Promote approved Sponsors into the Master Tracker
Master Sponsor Tracker

Track all Sponsors including:

Sponsor ID
Contact Information
Current Stage
Current Status
Assigned Coordinator
Last Contact
Next Action
Next Meeting
Task Management

When a Sponsor enters a stage, display the standard checklist for that stage.

Allow Coordinators to:

Complete tasks
Add custom tasks
Track progress
Executive Dashboard

A simple dashboard showing:

New Leads
Active Sponsors
Current Stage for each Sponsor
Overdue Follow-Ups
Sponsors Waiting for Executive Review
What We're Looking For

Someone with experience building:

Google Workspace systems
Google Apps Script
Google Sheets automation
Internal workflow systems
CRM-style databases
Operational dashboards

Experience with Airtable, Notion, ClickUp, or similar workflow platforms is a plus.

Ideal Candidate

We're looking for someone who:

Thinks about workflow and user experience.
Makes recommendations when appropriate.
Builds clean and organized systems.
Writes maintainable Google Apps Script.
Communicates well.
Can explain their approach.
Future Opportunities

This project is only the beginning.

As our company grows, we plan to build additional internal systems for:

Employee onboarding
Compliance tracking
Client management
I ---------- reporting
Training management
Quality assurance
Operations dashboards

We're looking for someone who could become a long-term development partner if the first project goes well.