AppScript code to fetch RSS and post to Google Chat Room via Webhook
- Copy the script into appscript, update the variables at the top (link to your google sheet, and tab name)
- Enter details into your google sheet for each RSS feed, Chat room webhook etc
- Run the script from appscript, and it will prompt for permissions the first time
- Set it to run on a schedule (every 1 min or 5 mins etc depending on your preference)
- Watch in Google Chat Rooms as the notifications come in