Automations: Collect information using a simple form
Automations: Collect information using a simple form
What you'll learn in 10 minutes or less: How to create a simple form to collect ideas, feedback, or requests from coworkers in Slack. Plus, keep responses organized by automatically adding them to a Google Sheet!
Go for it!
Step 1: Start with a workflow template
From your desktop, hover over More in the tab bar.
Select Automations.
Click Templates, then select the Collect information template.
Click the Use Template button.
Step 2: Edit your form
Click the pencil icon next to Collect info in a form.
Give your form a title.
Click the pencil icon beside each question to edit or delete it. Click Add Question to add to your form. Use the up and down arrows to change the order. If you’d like, click Preview Form to see how it'll look.
Click Save.
Step 3: Share responses automatically
The template's set up to send an automated message to the channel where the workflow was used. The message mentions the person who filled out the form and includes their response. You can customize this message if you'd like.
To customize the message, click the pencil icon next to Send a message to...
Click the dropdown menu if you'd like to send the message to a different channel.
Click the message field to edit the message. Select Insert a variable below the message field to add information to the message such as responses to additional questions you may have added to the form.
Click Save.
Optional (but useful) step: Add responses to a Google Sheet
Responses that are collected using the form can be automatically sent to a Google Sheet. This is useful if you want to organize information collected from the form using a spreadsheet.
Click Add Step near the bottom of the window to open the step library.
Select Google Sheets from the list.
Select Add to spreadsheet and follow the prompts to connect your Google account if you haven’t already.
Click the dropdown to select an existing spreadsheet or create a new one, then map the values to columns in the spreadsheet.
Click Save.
Step 4: Finish up
Click Finish up, then give your workflow a name and click Next.
Add workflow managers and edit permissions if you’d like, then click Publish.
Click Copy Link.
Your workflow is ready to use! Share the workflow link so people can access your form. To learn more about workflows and to find help, click the question mark icon in Slack.
