app.py

import requests
from xml.dom.minidom import parseString
import pandas as pd


def get_google_news_result(term, count):
    results = []
    obj = parseString(
        requests.get('http://news.google.com/news?q=%s&output=rss' %
                     term).text)
    items = obj.getElementsByTagName('item')
    # Storing the Titles and Links
    titles = list()
    links = list()
    for item in items[:count]:
        title, link = '', ''
        for node in item.childNodes:
            if node.nodeName == 'title':
                title = node.childNodes[0].data
            elif node.nodeName == 'link':
                link = node.childNodes[0].data
        titles.append(title)
        links.append(link)

    return titles, links


if __name__ == '__main__':
    titleName = input("Enter the news title keyword: ")
    articleCount = int(input('Enter the number of article count: '))
    titles, links = get_google_news_result(titleName, articleCount)

    news = {'title': titles, 'links': links}
    df = pd.DataFrame(news, columns=['title', 'links'])
    df.to_excel('{}_news_scrapper.xlsx'.format(titleName))