3 scripts with steps:
- The first script will take input from input.xls and will generate the output file output-1.xls
- The second script will take input from input.xls and will generate the output file output-2.xls
- Then merge output-1.xls and output-2.xls to one file >> output-3.xls
- The third script will take output-3.xls and will generate the output file output-4.xls
Youtube link: https://youtu.be/wS5VYGrA1i4
################################################
- Install Python and firefox browser on your windows system
- Link download Python: https://www.python.org/downloads/, please choose new version 3.9.x
- Link download Firefox browser: https://www.mozilla.org/en-US/firefox/new/
################################################
- Install package for your projects
- Open Command Line: Hold down Shift and right click on your project folder => Click to choose "Open PowerShell window here"
- Install package: Copy "pip install -r requirements.txt" and paste to your command line => Press Enter
################################################
- Config settings file
- Open settings.py file in your folder project and choose edit with your editor.
- Fill your Ahrefs account
- Fill others (optional)
################################################
- Run your script
- Open Command Line: Hold down Shift and right click on your project folder => Click to choose "Open PowerShell window here"
- Run script 1: Copy "python script_1.py" and paste to your command line => Press Enter
- After complete script 1, run script 2: Copy "python script_2.py" and paste to your command line => Press Enter
- After complete script 2, run script 3: Copy "python script_3.py" and paste to your command line => Press Enter
PS: If you completed steps above, you don't need to repeat it.
- Run script 1 need to have file "input.xlsx"
- Run script 2 need to have file "input.xlsx" and "output-1.xlsx"
- Run script 3 need to have file "output-3.xlsx" and "blacklist keywords.txt"