11. Bulk uploading through Python
Last updated
Last updated
Click on the word to be taken where the script is so you can download it.
This script has the following useful features:
It doesn't spam the screen with Chrome windows while it works. It does everything in the terminal window.
Has basic error checking and retrying for the same address in the .csv file until it's properly integrated to Smartlead.
Will skip any addresses that already exist in your Smartlead account based on your API key's retrievable information.
Counts progress per address so you can know when it's going to be done more or less.
For this tutorial we are going to assume you're a macOS user. If you're on Windows, read until the end before doing anything.
Open your terminal and insert this, then press enter:
If asked, insert your computer's password. Then, insert this and press enter:
Now, this:
You're now going to visit the Python website and download the corresponding installer for macOS:
If your installation was correct, you'll be able to verify that it worked with the following terminal command:
Here's how it should look like normally:
Now that Python is installed, install all of these one by one:
Now move the .csv file you want to upload to Smartlead into the downloads folder, by first entering this command:
Now if you type in the following command, you'll see that your file is there
Copy the path of your .csv file by doing the following and pasting with "cd + (path)"
You will be asked the following things before the script starts:
API key: You get this from your Smartlead account's settings.
.csv path: See above.
Microsoft OAuth link: Below is shown how to get it.
Whatever link you see in the Microsoft screen that follows, you must copy into the script:
Here's how the Python window should look after you type in the following command (You must make sure the script is also in the downloads folder) and insert the information from step 11:
If you did everything correctly, it's going to start uploading your accounts to Smartlead and output something similar to this:
It takes around one hour and thirty minutes to complete. Better than most VAs, but you should dedicate an entire day to running this script before officially sending emails, especially if you have more than five.
If it outputs errors but it's still going, let it run and don't halt the process.
Make sure all your accounts exist in Smartlead after it's done.
Here's how to copy your .csv file's path:
Besides the aforementioned, the process is the same.
No need to install brew. Instead, you install Chromedriver directly from and move on with installing Python and pip modules.