Quick overview
This workflow collects client intake via an n8n Form, uses Anthropic to analyze requirements and draft emails, stores onboarding data in Supabase, creates a Google Drive folder, and sends Gmail and Slack notifications, then follows up until a Supabase checklist is complete.
How it works
- Receives a new submission from an n8n Form with the client’s company, contact details, requested service, and requirements.
- Normalizes and cleans the submitted fields (for example, trimming text, formatting the website URL, and standardizing the email address).
- Uses Anthropic to summarize the request, infer priority, and list any missing information needed to start.
- If required fields are missing, sends the client a Gmail message requesting the missing details and stops the onboarding flow.
- If the submission is complete, creates a client record and an onboarding checklist in Supabase, creates a client folder in Google Drive, and uses Anthropic to generate a personalized welcome email.
- Sends the welcome email via Gmail, posts the new onboarding summary to a Slack channel, and updates the client status in Supabase.
- Waits for the configured delay, checks the Supabase onboarding checklist, and either marks the client as completed and notifies Slack or emails a Gmail reminder listing the remaining checklist items.
Setup
- Connect Supabase credentials and create/configure the
clients and onboarding_checklists tables with the fields used by the workflow.
- Connect Anthropic credentials (via the Anthropic chat model) for requirement analysis and welcome-email drafting.
- Connect Gmail OAuth2 credentials for sending the welcome and reminder emails.
- Connect Slack OAuth2 credentials and set the target channel (default is
client-onboarding).
- Connect Google Drive OAuth2 credentials and update the parent “Clients” folder ID used to create each client folder.
- Set your agency name in the data-cleaning step and adjust the wait duration/checklist items to match your onboarding process.