Export existing Smartlead users to Google Sheets
by Noel Maniraguha on December, 2024
This automation makes it easy for you to manage existing SDRs, and assign leads to them.
This automation has 1 component.
1. Adding existing users from Smartlead to Google Sheets. Copy the sheets file here.
This automation serves as a pre-requisite for any inbox assignment automations.
Insert the blueprint in make (new scenario)
Manual Changes
Undocumented Smartlead API
Smartlead doesn't have these APIs on their docs, so we'll need to use a workaround. Login by using your username and password.
Duplicate Sheets File
Make a copy of the sheets file here. The database of Smartlead users will be stored in Sheets. You can modify the modules to a different app (ex: your HCM software).
Google Sheets Connection
If you make a copy of the Gsheets document and then make changes to the title or sheet name, you may get an error. To avoid this: ensure that the "Spreadsheet ID" and "Sheet Name" are spelled correctly.
IMPORTANT: If you get a "Runtime error" - check the spelling as described above!
Set a schedule
I recommend choosing an "on-demand" occurrence. This automation doesn't need to run again, unless new users are added to Smartlead.
- 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