I need a grabber which grabs school names from a website. Than the Grabber should search for the contact mail and list everything in a spreadsheet.
I need to do an outreach to all German schools via mail.
You get the school names from this website: [url removed, login to view]
Here it should open all 16 German states at the beginning,
If we open for example the first one ([url removed, login to view]) and you move your mouse over the first letter A you get all cities in this state with A. When you then click on the first City ([url removed, login to view]), you get the school names for this city.
The grabber should grab all school names from every city A-Z in all 16 states.
If there are school names more than once it should delete the double entries.
Now we need the mail address for every school name. For this, at the beginning, we need the school website.
Mostly if you enter the school name on [url removed, login to view] the first result is the schools website. But not all the time, maybe you have a better solution than always taking the first result.
To get the mail the tool should always open [url removed, login to view] or /kontakt and searches for the first @ address. The emails that were not found this way I will enter them at [url removed, login to view] and find them by myself.
The best would be if the program works on my mac if there is no other option we can also use windows.
Please write in your proposal how you would fix the issue with finding the website.
Also, write how long you need and which coding language you will use.