We currently have a sales team entering data and insights on a slack form which then is added to a slack channel as a kind of live feed of insights for the org.
I would like to take said forms and feed them directly into a few seperate coda pages - so we are keeping this information in an an organised manner
Theres a category for each slack form, so ideally i would like to have a page for each category - ie every insight on X goes to the X insight page and every insight on Y goes to the Y insight page
a) is this possible?
b) how would i go about doing it!?
We’ve made a Proof Of Concept for at team with something very similar. I can tell you it’s very possible!
Currently, the workflow looks kind of like the following:
Create a slack workflow in your slack workspace or a channel that is triggered by a link
Then, have the contents of the form sent to a google sheet
Connect a Apps Script to that sheet which will send the contents of the newly added row to a Coda Webhook Invoked Automation
Put a trigger on the apps script which triggers From Spreadsheet > On Change
Configure your webhook invoked automation to populate a row in a Coda table with the information from the google sheet row which is correspondingly the information from the slack form
Configure the doc with different pages that contain different views of the table depending on the information from the filled out form
