# 11. Bulk uploading through Python
### Introduction to the Python script:
Click on the word [repository](https://gitlab.com/stidt/bulk-upload-python) 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.
### Steps to get the script working in half an hour:
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.**
1. Open your terminal and insert this, then press enter:
```
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
```
2. If asked, insert your computer's password. Then, insert this and press enter:
```
brew update
```
3. Now, this:
```
brew upgrade
```
4. You're now going to visit the Python website and download the corresponding installer for macOS:
5. If your installation was correct, you'll be able to verify that it worked with the following terminal command:
```
python --version
```
Here's how it should look like normally:
6. Now that Python is installed, install all of these one by one:
```
brew install chromedriver
```
```
pip install selenium
```
```
pip install colorama
```
7. Now move the *.csv* file you want to upload to Smartlead into the downloads folder, by first entering this command:
```
cd Downloads
```
8. Now if you type in the following command, you'll see that your file is there
```
ls
```
9. Copy the path of your *.csv* file by doing the following and pasting with "cd + (path)"
11. 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:
12. 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:
```
python sl-python.py
```
13. If you did everything correctly, it's going to start uploading your accounts to Smartlead and output something similar to this:
### Final notes:
* 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.
### Advice for Windows users:
* No need to install *brew*. Instead, you install Chromedriver directly from [this link](https://edgedl.me.gvt1.com/edgedl/chrome/chrome-for-testing/120.0.6099.109/win64/chromedriver-win64.zip) and move on with installing Python and *pip* modules.
* Here's how to copy your *.csv* file's path:
* Besides the aforementioned, the process is the same.
