RSS Feed from Google Sheet

[Laurie Nason]

Hi all,

I know that I can use a google sheet as an RSS feed consumer.... but that's not what I want to do.

I have some cells on a sheet that I want to publish to an RSS feed - essentially theres a script that puts the latest results into a cell/range regularly which I then want to pull into a live stream as an RSS feed.

I have looked at a few sites like 

• here - which sort of go into a way of doing it, but this was 2017
• or here which looks promising as I can then pull out some text from one cell or range - but I don't know how to make it public - I get a permission_denied error calling the link from a URL 

Anyone done anything recently on how to do this or can point me in the right direction.

Thanks,

Laurie

[Tanaike]

In the current stage, Sheets API v4 cannot be used without the API key and the access token even when the Spreadsheet is publicly shared. It seems that this is the current specification. And also, the method of spreadsheets.values.get doesn't return the XML data. And also, even when the Spreadsheet is published as Web, the XML data cannot be returned, while the values can be retrieved by HTML request without the API key and the access token.

From these situations, as a workaround, when you want to return the XML data by HTML request, how about using Web Apps? I thought that when Web Apps created by Google Apps Script is used, the XML data can be returned.

If this method is not the direction you expect, I apologize.

[Ryan Watkins]

If you don't mind using something outside of GAS, you could also use kill-the-newsletter.com (or set up your server to do the same using the open source code from Github). You could then use GAS triggers to send emails with cell data from Sheets to the kill-the-newsletter email address, and they will go to your personal kill-the-newsletter RSS feed.  It is not elegant, but it should get the job done.  

Ryan

[Clark Lind]

Laurie, 
Check this post on SO.  Tanaike's response from 2014 may still be effective, which I believe he is referring to in his second sentence above. :)

Clark

[Martin Hawksey]

You can actually create a RSS feed by formatting the data in a Google Sheet with the required XML then 'publish the sheet to the web' as a .tsv

For example some RSS data in this Google Sheet https://docs.google.com/spreadsheets/d/1k2c7k0wouFCJJL0B_LJi_MLWrm0zWsigJec4_RNGONE/edit#gid=0

Published to web as .tsv https://docs.google.com/spreadsheets/d/e/2PACX-1vRb8U7NrGoXyekswC-ZBjxcKck6k2g2irqfmx4WiN9ago3mX_X5EiMXpfYH1d5SpL2EicfgGeSiCttO/pub?gid=0&single=true&output=tsv

And validated https://validator.w3.org/feed/check.cgi?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2Fe%2F2PACX-1vRb8U7NrGoXyekswC-ZBjxcKck6k2g2irqfmx4WiN9ago3mX_X5EiMXpfYH1d5SpL2EicfgGeSiCttO%2Fpub%3Fgid%3D0%26single%3Dtrue%26output%3Dtsv

[Laurie Nason]

Hi all,

Thank you for your suggestions - there's lots to look at and some hope out there for workarounds. However, as this is for one event per year... I'll have to give it a miss for this year as the work involved will be a bit much. Maybe if I have some time between now and the event, I'll take a shot.

Thanks again for the help guys! Really appreciate it.

Laurie

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/8e556fee-5868-41db-9706-a4858bb4db4cn%40googlegroups.com.