Automation project · June 2026

Client Onboarding
Pipeline

A fully automated workflow that fires the moment a new client submits a form — creating a Drive folder, logging to Sheets, building a Trello card, sending a personalized welcome email, and alerting the team in Slack. Zero manual steps.

⚡ Built in Zapier No-code 22 steps 4 parallel paths Full Package tier
22
Zap steps
4
Parallel paths
0
Manual steps
📋
Typeform trigger
Filter rules
🕐
Date formatter
📁
Drive folder
📊
Sheets row
🔀
Path split
🃏
Trello card created
✉️
Welcome email sent
💬
Slack alert fired

How it works

Trigger
New Typeform entry

A client completes the intake form. The Zap fires instantly — no waiting, no polling delay.

Filter + Format
Validate & clean

Filter by Zapier checks conditions so only qualified submissions proceed. A date formatter standardizes the start date field.

Storage
Drive folder + Sheets log

A named project folder is created in Google Drive. A structured row is appended to the onboarding tracker spreadsheet.

Delivery
3 outputs in parallel

Paths by Zapier routes to Trello (project card), Gmail (welcome email), and Slack (team alert) — all simultaneously.

22-step Zapier workflow, successfully executed

Multi-path automation with a Typeform trigger, Filter by Zapier, Formatter (Date/Time), Google Drive folder creation, Google Sheets row, and a 4-way Paths split — each path independently running Trello, Gmail, and Slack steps.

Steps 1–6: Trigger → Filter → Format → Drive → Sheets → Split
Path A–C: Condition rules (did not run — tier filter)
Path D (Copy 2: Path B): All 3 outputs fired successfully
Zapier workflow screenshot
📊
Client Onboarding Pipeline — live spreadsheet tracker

Every submission auto-populates a structured row in Google Sheets with all client data and a status of "Onboarding".

Columns: Timestamp, Client Name, Email, Service, Start Date, Drive Folder Link, Status
Client: Mark Bayucot · mkb@gmail.com · Full Package · 2026-06-30
Drive Folder Link auto-populated from previous step output
Status set to "Onboarding" automatically
Google Sheets log screenshot
✉️
Personalized welcome email sent via Gmail

Subject: "Welcome aboard, Mark Bayucot! Here's what happens next 🎉" — sent automatically with a fully personalized body.

Project Details: Name, Company, Service, Budget, Start Date
Direct link to their Google Drive project folder
4-step next-steps checklist included
Budget field: $3,000+ (pulled from Typeform response)
Gmail welcome email screenshot
🃏
Trello card auto-created in "New Clients" column

The Client Onboarding Trello board now has a card for Mark Bayucot — ready to be moved through the pipeline stages.

Board: Client Onboarding Trello
Columns: New Clients → In Progress → Kick-off Scheduled → Onboarded → On Hold
3 cards created from 3 Zap test runs (all for Mark Bayucot)
Card includes client label color-coding
Trello board screenshot
💬
Structured Slack alert in #client-onboarding channel

The team is notified instantly with a rich message containing all client details and a priority action prompt.

Channel: #client-onboarding · Workspace: Marky
Name, Company, Email, Budget, Start Date, Project Details
Drive Folder link embedded in message
Action prompt: "Assign a dedicated team member and schedule kick-off call ASAP!"
Slack alert screenshot

Tools used

Zapier
Typeform
Google Drive
Google Sheets
Trello
Gmail
Slack

Want a system like this?

I build no-code automations that eliminate manual work and scale your operations.

Get in touch →