News search tool

Hello, I am trying to get a tool working to be able to get the names of journalists covering a specific topic, keyword or phrase. I need software that can produce lists containing the following fields for variable search terms queried on large news aggregators like Google News or Bing News: 1. Author first name 2. Author last name 3. Name of the publisher (blog name, newspaper name, magazine name, etc.) 4. Title of the article 5. Description of the article 6. URL of the article This does not need to be running continuously or integrated into any other software, so a script or a set of scripts that I can run on my Mac would be great. I am not too particular about which programming language to use, but I have been trying to get something to work using Python. Output should be a .csv that I can import directly into Google Sheets. Outputs should be limited to 500 entries per search term. Here are some resources: 1. [login to view URL] This is what I am trying to do so it's a good place to begin, special attention to step #2 & step #3 2. [login to view URL] I found this API but it doesn't seem to be returning the names of the authors which is very important for my use case. 3. [login to view URL] Here is another API that I found that does return author names but I couldn't really get it to work, it seemed to also limit search results to a very small amount. If you have any additional questions please feel free to reach out to me.