How beneficial a literature survey article would be if it's about gender gap? I am an undergraduate in physics and I am doing a literature survey project that highlights the gender gap in some specific field of research. My professor asked me to visit google scholar and related sites(specific to that research field) where I get the research papers year-wise and do the survey on a number of male and female authors by name, year, and the country as well. Since I haven't done any survey work before, to go through each paper on a site and then copy-paste the names on excel and search their names and gender seems like an eternity of work. I am aware that it's an empowering project but still, I am alone at work, he gave me two months' time. I don't want to spend my time in something only to find it insignificant in future.
How beneficial would this literature survey article would be to my research career if it's about gender gap?  Considering I am Physics student.
And if anyone has done one such project, please tell some tools/tips which can make it a little easier, including one in excel. It would be a great help.
Google seems to have gone out of its way to make the results on google scholar difficult to access with a program.
That said, there are many tools that automate some of what you are painfully doing by hand. The results can be imported into excel.
Search for scrape google scholar.
You would certainly need this kind of literature search to think about the extent of a gender gap in the indexed publications. Making sense of the data would be hard. What reliable method might you use to determine the genders of authors?