We have a custom object called 'Insights' where various members of our team capture pieces of intelligence about our clients / market, which is associated to companies and contacts.
Data structure is like: Insight Name -> Date -> Source -> Synposis -> Keywords -> [then some other properties with structured data...]
I have a simple report that acts as a digest of the last week's 'Insights' but it's horrible to navigate because of the number of properties and format.
Simply, I'd like to transpose the report as more of a feed, so it comes out like:
(Insight 1): Our Client told us this
Date: 24 March
Synopsis: Fusce eget tellus non est blandit rutrum sit amet eget felis. Aliquam quis felis tortor. Quisque viverra mollis dolor vel laoreet. Ut molestie justo eu ex varius accumsan. Nulla facilisi. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
(Insight 2): Another Client told us this
Date: 23 March
Synopsis: etc etc etc
I can see a number of routes to achieving this via a workflow - e.g. workflow to send data to sheets, zap to create a google doc, etc...
But I'm wondering if anyone has dealt with something similar and has an easier solution? Anyone used a suitable app in the marketplace - was wondering about some of the document integration ones? Or maybe we can do something sneaky like using the new CMS API to post to a subscription-only blog?