Retrieve a list of Slack user groups after a manual trigger and add records to Google Sheets

■Overview

Regularly retrieving Slack user group information is essential for checking and managing members, but doing so manually can be time-consuming. The more groups and members you have, the greater the risk of transcription errors and omissions.
With this workflow, you can automatically retrieve Slack user group member information with a single click and output it as a list to a specified Google Spreadsheet, eliminating the burden of these manual tasks.

■Who Should Use This Template

• Anyone who manually manages Slack user groups and wants to streamline the process of retrieving information
• Anyone who regularly reviews user group members by project or department
• Administrators who want to prevent transcription errors and missed checks when creating member lists manually

■Benefits of Using This Template

• Automatically retrieve Slack user group information with a manual trigger, reducing the time previously spent creating member lists
• Eliminate the need to transfer information manually, helping prevent human errors such as copy-and-paste mistakes and missed checks for more accurate information management

■Flowbot Steps

1. First, connect Google Spreadsheets and Slack to Yoom
2. Next, select “Manually trigger the Flowbot” as the trigger
3. Next, configure Slack’s “Retrieve a list of users in a user group” operation and specify the target user group
4. Next, configure the “Repeat the same process” operation and set the retrieved user list as the target for loop processing
5. Finally, configure Google Spreadsheets’ “Add a record” operation within the loop to add each user’s information to the specified sheet, one row at a time

※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.

■Customization Options

• When configuring the action to add a record in Google Spreadsheets, set the spreadsheet ID and tab name where you want to output the user list

■Notes

• ‍‍Connect Slack and Google Spreadsheets to Yoom.
• Actions between “Repeat the same process” operations are available only on the Team and Success Plans. On the Free and Mini Plans, the configured Flowbot operations and data connections will result in errors.
• Paid plans, such as the Team and Success Plans, include a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.