End-to-End UGC Creator Management System

End-to-End UGC Creator Management System — Slack & Google Sheets

Managing UGC creators manually tracking applications, approvals, and rejections gets messy fast. This system handles the entire pipeline automatically.

Built two connected Make.com automations for a full UGC workflow. When a creator submits an application form, a webhook captures the data, structures it through variable-setting steps, and posts a formatted notification directly to the team's Slack channel for review. From there, when a team member reacts to the Slack message, the second automation fires — detecting the reaction type, parsing the pattern, and routing accordingly. A checkmark approval searches the Google Sheets roster and updates the creator's status. An X rejection does the same, marking them as declined. Both paths keep the sheet clean and current without anyone touching it manually.

Apply. Review in Slack. One emoji. Done.

Stack: Webhooks · Make.com · Tools · Slack · Text Parser · Google Sheets