728x90
TL;DR
RSS 트릭을 사용해서 가져온 정보의 형식은 XML이지만, 바로 사용할 수 없다.
URL을 바로 추출할 수 없으며 약간의 트릭이 필요하다.
여러가지 방법 중 Power Automate의 정규식 이용 방법에 대해 설명한다.
구글 뉴스 RSS의 문제점
앞에서 구글 뉴스 rss로 저장한 파일은 XML 형식을 따르지만, 웹브라우저로 열어보면 다음과 같은 에러 메시지를 볼 수 있다. 따라서, 이것을 그대로 쓸 수 없으며 약간의 가공이 필요하다.
구글 뉴스 RSS는 특수 문자를 XML 규칙에 맞지 않게 출력하는데, 정확한 xml 형식으로 변경하는 것보다는 원하는 정보를 추출해 내는 것이 더 빠르다고 판단하였다.
아래를 누르면 전체가 보입니다.
This XML file does not appear to have any style information associated with it. The document tree is shown below. <rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
<channel>
<generator>NFE/5.0</generator>
<title>"미스터블루 after:2025-04-16 before:2025-04-18" - Google 뉴스</title>
<link>https://news.google.com/search?q=%EB%AF%B8%EC%8A%A4%ED%84%B0%EB%B8%94%EB%A3%A8+after:2025-04-16+before:2025-04-18&hl=ko&gl=KR&ceid=KR:ko</link>
<language>ko</language>
<webMaster>news-webmaster@google.com</webMaster>
<copyright>Copyright © 2025 Google. All rights reserved. This XML feed is made available solely for the purpose of rendering Google News results within a personal feed reader for personal, non-commercial use. Any other use of the feed is expressly prohibited. By accessing this feed or using these results in any manner whatsoever, you agree to be bound by the foregoing restrictions.</copyright>
<lastBuildDate>Thu, 17 Apr 2025 12:35:19 GMT</lastBuildDate>
<image>
<title>Google 뉴스</title>
<url>https://lh3.googleusercontent.com/-DR60l-K8vnyi99NZovm9HlXyZwQ85GMDxiwJWzoasZYCUrPuUM_P_4Rb7ei03j-0nRs0c4F=w256</url>
<link>https://news.google.com/</link>
<height>256</height>
<width>256</width>
</image>
<description>Google 뉴스</description>
<item>
<title>오후 이슈 [웹툰] : 미스터블루, 핑거스토리, 키다리스튜디오, 와이랩, 탑코미디어 - 파이낸셜뉴스</title>
<link>https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5</link>
<guid isPermaLink="false">CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw</guid>
<pubDate>Thu, 17 Apr 2025 06:05:27 GMT</pubDate>
<description><a href="https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5" target="_blank">오후 이슈 [웹툰] : 미스터블루, 핑거스토리, 키다리스튜디오, 와이랩, 탑코미디어</a> <font color="#6f6f6f">파이낸셜뉴스</font></description>
<source url="https://www.fnnews.com">파이낸셜뉴스</source>
</item>
<item>
정규식을 이용한 URL 추출
우리가 필요한 정보는 URL이고 여기에는 https://news.google.com/rss/articles로 시작한다는 공통점이 있다.
<link>https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5</link>
다음과 같은 정규 표현식을 사용하면 우리가 원하는 URL을 찾아낼 수 있다.
https://news\.google\.com/rss/articles/[^<\s"]+
- https://news\.google\.com/rss/articles/: URL의 고정된 앞부분
- [^<\s"]+: URL 끝까지의 내용을 의미하며, '<', 공백, 큰따옴표가 아닌 모든 문자를 포함한다는 뜻이다.
Power Automate를 이용한 자동화
Power Automate에서 정규 표현식을 이용해서 구문을 찾아내기 위해서는 텍스트 구문 분석 기능을 이용한다. 다음과 같이 입력하자. 여기서, Positions는 위치를 나타내고 Matches는 Position에 해당하는 값을 반환한다.
이렇게 추출해낸 텍스틀 살펴보면 아래와 같이 같은 값이 두번씩 반복되는 것을 확인 할 수 있다. 우리는 하나만 필요하므로 중복되는 값을 제거하는 과정이 필요하다.
1. https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5
2. https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5
3. https://news.google.com/rss/articles/CBMib0FVX3lxTFBmaF9OS3M0WUF2LU9aQ3JBaXFLQVRaTU1oY3R0WlRnRkI3SVZEUVJQOTFjeDlhUy1SNm91TjdmU01ON0RFUnAwUTR6RGM1V0RBNVhQZkFKcXk0QUJpQ05CWkdOek9SLVdSZmtkUGVFNA?oc=5 4. https://news.google.com/rss/articles/CBMib0FVX3lxTFBmaF9OS3M0WUF2LU9aQ3JBaXFLQVRaTU1oY3R0WlRnRkI3SVZEUVJQOTFjeDlhUy1SNm91TjdmU01ON0RFUnAwUTR6RGM1V0RBNVhQZkFKcXk0QUJpQ05CWkdOek9SLVdSZmtkUGVFNA?oc=5 5. https://news.google.com/rss/articles/CBMibEFVX3lxTFB4S2dQWDMyeWRJWEZPRjRyTDlPSWN5QzJvZy1ySi05RkM2bUwyQUdlNmZjU21GTHFZdFRKZzk4Njh0d21COGZZSElBR2t2Y1pFSFdoODljSXFvY3Eycy00ZWFPMVhWSUpIRS1pMg?oc=5 6. https://news.google.com/rss/articles/CBMibEFVX3lxTFB4S2dQWDMyeWRJWEZPRjRyTDlPSWN5QzJvZy1ySi05RkM2bUwyQUdlNmZjU21GTHFZdFRKZzk4Njh0d21COGZZSElBR2t2Y1pFSFdoODljSXFvY3Eycy00ZWFPMVhWSUpIRS1pMg?oc=5 7. https://news.google.com/rss/articles/CBMia0FVX3lxTE9WV3d4eEJOaVV2UkRpSkNLTl9XYmJuQ0FuMVhHbHktcDBYd3JZaWprNkMyckRmLTZuaU1xZTJpMTNfRUFfeGJJRU96dFlKLVpzZTZaOUtNWXpmci1hZmFWV0pVV2c2dlN5a0JN?oc=5 8. https://news.google.com/rss/articles/CBMia0FVX3lxTE9WV3d4eEJOaVV2UkRpSkNLTl9XYmJuQ0FuMVhHbHktcDBYd3JZaWprNkMyckRmLTZuaU1xZTJpMTNfRUFfeGJJRU96dFlKLVpzZTZaOUtNWXpmci1hZmFWV0pVV2c2dlN5a0JN?oc=5 9. https://news.google.com/rss/articles/CBMiVkFVX3lxTE9ZTjFFM29EMzFJYzNDdkRJdHhGcFkzRzJVMDdGbmNLNlgwZ05HaWpMb3hwWXBzM1hGV0FvbVlqdnpsR2hwd0RRQnB4UzN6cjdGNnNwMVpB?oc=5 10. https://news.google.com/rss/articles/CBMiVkFVX3lxTE9ZTjFFM29EMzFJYzNDdkRJdHhGcFkzRzJVMDdGbmNLNlgwZ05HaWpMb3hwWXBzM1hGV0FvbVlqdnpsR2hwd0RRQnB4UzN6cjdGNnNwMVpB?oc=5
최종적인 흐름은 아래와 같으며, 결과는 중복되지 않은 URL만 깔끔하게 추출되었다.
결과 보기(아래를 누르면 전체 결과가 보입니다)
1. https://news.google.com/rss/articles/CBMiWkFVX3lxTE1XWGxLbEdROTdQT1Naei1WUzVfNFBieUNQQ3JWRFVOd2VPRENPd01IOGl6Q05EMkVVRG5Obm9CTnFzXy05NXdGR1JRcy1hbWxmcjNiTzl5NmVQdw?oc=5
2. https://news.google.com/rss/articles/CBMib0FVX3lxTFBmaF9OS3M0WUF2LU9aQ3JBaXFLQVRaTU1oY3R0WlRnRkI3SVZEUVJQOTFjeDlhUy1SNm91TjdmU01ON0RFUnAwUTR6RGM1V0RBNVhQZkFKcXk0QUJpQ05CWkdOek9SLVdSZmtkUGVFNA?oc=5 3. https://news.google.com/rss/articles/CBMibEFVX3lxTFB4S2dQWDMyeWRJWEZPRjRyTDlPSWN5QzJvZy1ySi05RkM2bUwyQUdlNmZjU21GTHFZdFRKZzk4Njh0d21COGZZSElBR2t2Y1pFSFdoODljSXFvY3Eycy00ZWFPMVhWSUpIRS1pMg?oc=5 4. https://news.google.com/rss/articles/CBMia0FVX3lxTE9WV3d4eEJOaVV2UkRpSkNLTl9XYmJuQ0FuMVhHbHktcDBYd3JZaWprNkMyckRmLTZuaU1xZTJpMTNfRUFfeGJJRU96dFlKLVpzZTZaOUtNWXpmci1hZmFWV0pVV2c2dlN5a0JN?oc=5 5. https://news.google.com/rss/articles/CBMiVkFVX3lxTE9ZTjFFM29EMzFJYzNDdkRJdHhGcFkzRzJVMDdGbmNLNlgwZ05HaWpMb3hwWXBzM1hGV0FvbVlqdnpsR2hwd0RRQnB4UzN6cjdGNnNwMVpB?oc=5 6. https://news.google.com/rss/articles/CBMigwFBVV95cUxNVS1nVDcwS1J1ZHNxTGptOE5mZ2w4X19uS3dyTTQ4cTYzZWZzVlI2bmREbElGNWRMa3I5VHoxTWZteWlPcnV2UU9WVDduYmp3d3lzNHp2bW9POHRTRWhwdTJReEFXLUl4aUJ2dnJGYjVnQTZEaGstY0QyZUVjSklUcGhEY9IBlwFBVV95cUxNQUFhSWVjb2VqWmhLcDkxMmJobjV1OUVTRURXSmF4aHg2S3loV0wxazRPM3Y0Y2hjaW1xTkI5cGxkZ3RWdkRDdnp2MTZVTEVtdDZBNDBJTllsOThJb0J4U0NQSnJINmN5cHlyeVA0d1dhbFNPQ2dpdFRreGgtWTVoSFNpYlluSk5CRU5jVEloUTVsNGhITmow?oc=5 7. https://news.google.com/rss/articles/CBMibkFVX3lxTFAzNVlEWEFja0ZfWm4wc1YxblNObFRXeUMwZGRFeXpIZnhKMWRzNnFPYzItQnI3TmRnR3RLUm80QnpKaVdaV2ZKV25pRm92Qkc1bG03V1YwS3lRTURDV1hKSDBVZEY5WFVJY0k3TGF3?oc=5 8. https://news.google.com/rss/articles/CBMiU0FVX3lxTE5HZ3VhMzZyWk0wQlhzY1RhNmlwRUxyMVg5ampHWGdEdmtSNC1ZRndEVnZSRkVpUGF4YlZyMldITjBsQ0R5c1lsMWZkcFljRG1qQmRF?oc=5 9. https://news.google.com/rss/articles/CBMiakFVX3lxTE9fcDhRSlRPV242M0RPMVRxYXF5X0lnUzBFT0JFWFBNTC0tUXRCRGY5eG1Hbk5OaXkxMnIzYkhCZDI5bnlMX1dNSmVvelhWbUNhaDBqdElCbUw4YzB4a2xYd1FKQ3hpenUzdEE?oc=5 10. https://news.google.com/rss/articles/CBMibEFVX3lxTE9zMUZXZzBDVTNNbGxoWTNlX0VwZkJIc1JqUnkxa25ELVN4NDBqcGJjaGxab3pqSVFYR3BfLXlHU1VDbkxmNXpuN1JrSXJNd3hBbFlzQ2pNZVlYVTN2T1JVUGdHajlsVVZ2ZWI2Ug?oc=5 11. https://news.google.com/rss/articles/CBMimgJBVV95cUxNMFh5QkNjYTJFdkQzSy1JUVlBZjB4SFVQZmkwWGtSOHUtN0FsQnZSNkhGTkJyTFJmcUluNnEyby1EM0xkQ0xjelQzRmozOFJCVW1XQUh1MkRCdVc0MlZyM1VERGJ5bzF0a25NM291YVBybjk1aEdrdmw0Sjl2ZThIWUF2b1poV0Y4QVRkbWZhd2ttY3NoeVMySkxjeHRadnluSDJxQXoySE94Qk1wcUd5LW0xZzNVMmI4MTVGdll6SlkyYnJUMkdoTXB4QkdiTGxZTGY3ai1rem1CeURYSmFjbHlDNkFTZldRdjY2ZmhIREt2QWFOcVdqVmNjdlNlaWdqeUo4Ujl3eGpsc1ZEcDVxUU5aaHp6NkJTdkE?oc=5 12. https://news.google.com/rss/articles/CBMiYEFVX3lxTE5LMklGWG81YVFCM2ZNVmRHSkl2QnhNUEJhRzdHOGtxRXpWOWdTTVNwUnJraGxRQmlYelJFVzItSk9LbUtIT3VRQTVYWUN0Q2tsSFlxUHJOVmhTcFdTMGdILdIBeEFVX3lxTE1JS3Nvd0QxeDIwRl9FSTFZbUdwS0FvejV5M1Y4LXFNVGFtb092Tk85cG1JcmZILUJ5T2ZpMHlUUTdsVVI5WDF6R2VoQUxEXzBMZ0JFNzZzQ3VnNWM4MU1ncDF2b2tYTlI5azZqY2tvTEFfaldNcWxpMg?oc=5 13. https://news.google.com/rss/articles/CBMiU0FVX3lxTE1sUmtFY3d5SWk0Y1VSLXR1dlFDOXk4b0FRSlhtSjhUeUg1RlIxNmN1T2JXQWZ0SjV6NGlXRTVkcnZJOWtLQkloMm5fYnFjRXA0TktN?oc=5 14. https://news.google.com/rss/articles/CBMiUkFVX3lxTE0yb0lYc2pnNFdwcDBFLV9uVVliMU45dDdYTHRXLWdUTkNiRUE4QVJJekZRU1ZqNEJSdTR3ZnFHdFA3emRfTlZyQVRVeGFjV1VjU0E?oc=5 15. https://news.google.com/rss/articles/CBMiUEFVX3lxTE16Y0xtd0xVN2JOcGd2WlhYQUFvU2xzME5yUzM1eUpvTHRyRXJHZnJsQk44c2xRZE83TEdVT0M0c2hrWmRHM0MydFF1YjBJdkg0?oc=5 16. https://news.google.com/rss/articles/CBMibEFVX3lxTE1GX0RBRi1sN1ZVMDFUWF9vVktvZ3hmQUZzcHdfMXFqRUZpSFZKLWZSZUlTLURlVWN5STREazBuN2xOSDVhcEE0b2JIa202NzZTbTJ3ckVDc3FyaUpqQVhvcG82NUozb25KMUlrVw?oc=5 17. https://news.google.com/rss/articles/CBMiaEFVX3lxTE5KSkI3NmNpS2FUNjJIQjI0bTZpOGs1WnJDRzJDUEhKUWJvTDJiNFVsSHREXzlhOGsxSlVxWDcyQUFuTEkxeU9CeGtubU04aUd5Wk1vRDRnTnY0dEpYU2MzZ1VaYUVuZ2JL?oc=5 18. https://news.google.com/rss/articles/CBMiW0FVX3lxTE1wbEpLWU9nNElpVE84Q2NVMkpSNEtOeTJPcHRRSnNhYWdLLWdHaHBsV2ZWVXZyVXRaWVdCajVRNG5nR1dJM29LQkpaWE9zdS01UWRTNTNFSGhUMWfSAWBBVV95cUxOVE5pamNUaVo2RW52M1I2V29VdGJXRE5paWRNdm5FakVsM3hTZEtzMjNWVjFVbTlLSVJCQjkzUTN2MGxrbXNJMXBZSnVydlNUX1NGVm9ORDlVNkFDdzRSRno?oc=5 19. https://news.google.com/rss/articles/CBMiVEFVX3lxTFBkU255bjh2TEVlSDhsYkFLdzBGaDY3eENrck1hOXE3S2VaQVo0Z3BQMGtwWm5sd3kzQmJKNWhpZEFmVVcxTmxMVlJKTWRUMjRkWC10Tw?oc=5 20. https://news.google.com/rss/articles/CBMiYEFVX3lxTE9haXJfSjVvLXBIa2hKdDloUUVMaS1IeFAtd2FaTldqRzRYemVuLXRoTklzWkJtSUlVbEhMSWpnTWlWUHNLbzVhRllEdnFWZlItQ2l5QTNYTllQRjE3czVqStIBeEFVX3lxTE0xRDhsQXdaQW4zc2lXV3pGOTJoLXBvTmFUSFlndzhESWtieWtkY2FQQ0xVVUdubHZzRThXT2s1YjYtaTVvLU5NcEppaDFrU0ttTzFVOUJ0T1Jqa2JZM3JwT3J0LXVCd0plYllBSTFqR2kyN2hud0k2cA?oc=5 21. https://news.google.com/rss/articles/CBMiYEFVX3lxTFA1QXdfMUFOcWM2THlzX1d0YzZ2bW9ETlFqYi1rVFNaWWQ4ZXZ5ZkF0UTRSU1dxX0JSS3I4SDQ3ZFlrYWhtUnh3dk15M3hQdVNhdktTaGRHTGdoVUo5SmJYUg?oc=5 22. https://news.google.com/rss/articles/CBMiWkFVX3lxTE9IRFZIQ00tWm9jZ1p4MmFOOHpTTTVnM3RUQkdGbjFILVM3ZTlzZUJUb0swbGFMS3NxWDVJaUVkc1JkRU90T1FYcy0ycVFBUkdtM295S2YtSTVFd9IBVEFVX3lxTE9GeTZZNVNCOVhQZVRwNzlNU29pSnFVVzQtdWJkNjM1TU1QNFpZVDRXY1pWUWFCWGNIdmFIU1dQRmJ4dlNZM3hIQUhyZW92dEJQeDQzcQ?oc=5 23. https://news.google.com/rss/articles/CBMiYEFVX3lxTE1fNXRlM0tHcElIQTdnbUlkRVFRTVVPNWx4Z3hTR2lybVRQTjdqRlZzaW5Ucm1QM3pDM1VZaGlXczMtRmdhTnlwcUFXN0NqdXJZMFY1RnZWTllibFRkTTZWZg?oc=5 24. https://news.google.com/rss/articles/CBMiYEFVX3lxTE1zM3hMQ1l0RFRqc0h6dGI0YnROYlZMX3N3UlRrNFZHc01nZjViR0xVclkwU0kzTUtaNTRRdGM4R1RuczUzSnItUHFvSnZ3YjVOclhKLWlYVWRIVkp1Zm8xWQ?oc=5 25. https://news.google.com/rss/articles/CBMigwFBVV95cUxPeHJ6WFBVNzFPTlBxSHl3MlpQdWVRcmlBUEp4b2JvYUlzOHNSbjJkb01LSjlEelZYVUJUNXM0WU1PeFBhejE5dm5oWjkxcHM5RWhJTlFEZ3FkbzZ3R3NJNTd6cUR2Tlk4NGthN2ZSX2RlMVg2eWJybzBDWnNwLXZtWEEzTdIBlwFBVV95cUxQbWE2cmZwWjg0YzZBdFIwekFjWXVqVVpteEhvcHdVRG9STjNmRXVobjhpck9HbU0yUm9SY1BlNW11MWF3b3dxYjFNcm5jczc0ZEQzdlB3LVlZdFZPR25fOXNqVzFQSWRKbHdjVGRvZ0dWV0FmQlc3RW9ZZkh2Z0tBU0tVZDJZeXVSN1dKRlZOZVlqVk9rOXE0?oc=5 26. https://news.google.com/rss/articles/CBMigAFBVV95cUxOOTgyVE5hbUJmTVB3bldNTTc1bkZpYWdsbGpBQXRIYll2RzBVVGhRS01iNW4ydEwxblFMdE55S0xBQUR5ZXZuaEFDVzhES0c3ZHp0SVJOSW93VVZLNDhwZzlORzVSZDFhbGpHRWNzdk45bXlpOEtLSnZ3X01sTzhpSw?oc=5 27. https://news.google.com/rss/articles/CBMiU0FVX3lxTFBCMGtWNk1oMWNQZ2dxVVNDa2ZhdWZNTkRCUnQzQW54QVA5Vkt6RUdnR1NYeGFOeUwwbElBQ29OQ1NaX012WXYta0lxWjhURWJIaWFV?oc=5 28. https://news.google.com/rss/articles/CBMiU0FVX3lxTE45bEF3aWxfTUI5OEl1eC12alJLTkphSnZXYmk4LUR3VVdjQkNmSnd5RFctU0dHLWFHLVk1eDMtYmMzc3RUQnRabW5EOTZXT0Iycjdr?oc=5 29. https://news.google.com/rss/articles/CBMiU0FVX3lxTE9tbHFjZUpqa0lWb0RtU29NMnVQTmp6SVZBbHdzUWlDREJpYmVWSG9CYjE2RUZRSktQUGNpQ002X1BDOEVSYVIwWWo5YnVZSkY2eldn?oc=5 30. https://news.google.com/rss/articles/CBMiaEFVX3lxTE0tYnl2SXhTWV9RZUdDTVVVRmtZN0ZMM2pWREVWNGVEM1AtMjUyZDIyU01wMk1ndVI0N3A4RGdaQ290cTE5T3Ytdnk4MDFNQmVobDlCX1h1blZqT0U2Y1hhd0ZiajhsTFhk?oc=5 31. https://news.google.com/rss/articles/CBMiaEFVX3lxTE5ZUFFkcmJSa0ZfdW5lVGp2bzhzb1VfTkpJelVhcHhDMGZVOGpDWm84VkVWak5YS2dxcFM4QnFxVlpEbE1TdjhZVFVFYm45SmQzQXV3VXpIRndDMGlLRlRNYkx2MFFQU3lN?oc=5 32. https://news.google.com/rss/articles/CBMiaEFVX3lxTE05bEN4cnVCOHhGZEU2aUw1TFY2OEdOOGFmOUg0VUI2SnRVbTVMVEdaSkd4YmZjd3lNajhEN1VJdWRlTU10NlpMUURHekw0cnZJRU5yblVrcUt0QkRhLVctdktUODdQbVRq?oc=5
마치며
이 과정을 마치면 이제 남은 것은 각각의 URL에 접속해서 기사 본문을 가져와서 정제하는 일만 남았다. 이는 앞서 설명한 바가 있으므로 다음에는 이 모든 과정을 한번에 통합하는 방법을 다뤄보고자 한다.
728x90