Client Onboarding Automation (Airtable Form)
by Noel Maniraguha on January, 2025
This automation makes it easy for you to create, onboard, and manage new clients using Airtable forms.
This automation has 3 components.
1. Creating a new client record when an Airtable form is completed: duplicate the workspace here.
2. Adding the newly created client within Smartlead as a client
3. Creating a Google Drive folder (this serves as an idea, you can further expand on the capabilities)
I use a version of this to create Stripe customers, Slack channels, and more. Feel free to combine this automation with these automations: Clay client onboarding SOPs, Smartlead client onboarding SOPs
Insert the blueprint in make (new scenario)
Manual Changes
Smartlead API Key
For the documented APIs, we'll use the regular key. Find it here and replace {API_KEY} with your Smartlead API key
Create a webhook
Create a webhook then copy the URL.
Add ?record_id={record_id} to the end of the URL. ex: https://hook.us1.make.com/1234464547
Would become: https://hook.us1.make.com/1234464547?record_id={record_id}
Go to the Airtable form and look for this section. Switch this with the URL you created.
Publish the form > then do a test run within make > then submit the form. You should get a message that looks something like this.
If this is done correctly, the make automation with get the data. If not, you may need to refresh the new page, as the make automation is set to run.
Disclaimer: this is one of MANY ways to accomplish the same task, if you want to change the trigger, then that's fine.
Expand The Automation
You may implement the Smartlead or Clay onboarding SOPs suggested here. You may also add other integrations such as Slack, Clickup, etc.
Set a schedule
I recommend choosing an "immediate" occurrence for this automation
- Top 10 Automations ⌵
- Honorable Mentions ⌵
- Campaign monitoring and database
- High bounce and low leads (alternatives)
- Make.com scenario backups
- Automated weekly reports (alternatives)
- Smartlead client database
- Automate responses to OOO emails
- Smartlead calendar sync (alternatives)
- Sync HubSpot and Smartlead properties
- Send Smartlead emails from Slack
- Auto-add DKIM, DMARC & open tracking
- Airtable Workspace ⌵
- Duplicate Airtable workspace
- Log campaign analytics trends in Airtable
- Create top-level campaign analytics in Airtable
- Create a Smartlead client database in Airtable
- Client Onboarding Automation (Airtable Form)
- Notification for Smartlead replies (Airtable Database)
- Store OLD engaged leads in Airtable
- Add OLD email accounts to Airtable
- Add NEW email accounts in Airtable
- Clickup Workspace ⌵
- Real Time Notifications ⌵
- Smartlead External Scripts ⌵
- Hubspot Dealmaker ⌵
- Automations with Clay ⌵
- Duplicate master campaign table in Clay
- Research new clients across the internet
- Validate and replace Smartlead API key overnight
- Create a research-based meeting recap
- Duplicate Clay table and move to client folder
- Export Clay table data to Google Sheets
- Clay client onboarding SOPs
- Enrich Smartlead contacts using Clay
- Automate responses to OOO emails
- Beyond The Basics ⌵
- Export all Smartlead positive replies to Sheets
- Retroactively assign SDRs to Smartlead contacts
- Export existing Smartlead users to Google Sheets
- Add and remove users from Smatlead with the API
- Smartlead client onboarding SOPs
- Clay client onboarding SOPs
- Campaign backups & restore
- Duplicate subsequence in Smartlead
- Add client dropdown field to Hubspot
- Add BCC address & custom tracking
- Create tasks for calendar events
- Hubspot 2-way sync (lead category)
- Auto-categorize leads with AI