I'm building a Zapier workflow that automates tracking form submissions and related Slack discussions. Here’s the current setup:
- Trigger: A new submission is received in Jotform.
- Slack Notification: A message is sent to a Slack channel to notify the team.
- Data Logging: A new row is created in Google Sheets to store submission details.
- Delay: The workflow waits for a specified time using Delay by Zapier.
- Retrieving Responses: The workflow fetches thread messages from the original Slack notification.
- Formatting Data: Formatter by Zapier processes text from the Slack thread.
- Finding Records: A lookup action in Google Sheets finds the related submission.
- Updating Records: The spreadsheet row is updated with the latest details.
where I am getting stuck is retrieving responses in slack. I can get the zap to fill in the right row in google with a thread message, my question is how to I keep in up to date.
do I need a new zap that where the trigger is a new thread or I read somewhere about using an emoji as a trigger.
My goal is to create a google sheet repository of all the Q&A that happens in that channel to build out an FAQ and use it as a searchable resource in the future.
thanks