This is a Collection of Articles of a given Category using ext:joomla.model.articles rendered here as HTML. But it can also been rendered as json, rss or csv!

If you choose CSV you could even display directly the data in a Google Sheet by using =IMPORTDATA("https://pages.joomlacustomfields.org/webservice.csv")

Note: csv is more tricky then json, it doesn't support nesting. That is why (Custom) Fields are not displayed in csv format. To go further, see this: https://github.com/bradjasper/ImportJSON

json: http://example.com/foo.json?fields=title,date,fields or via the front matter: state: fields: [title, date, fields]

For more information about "Webservice features offered by Pages" and "Differences with Joomla 4", see https://github.com/joomlatools/joomlatools-pages/discussions/675

Example herafter taken from https://github.com/joomlatools/joomlatools-pages/tree/master/contrib/sites/blog/pages/blog