Zapier+ChatGPT workflow: auto-post daily summaries to Slack
I receive dozens of customer support tickets daily and want a Zapier automation that pulls ChatGPT summaries and posts concise digests to a Slack channel each morning. Looking for trigger/config steps, rate limits, and how to keep PII out of prompts.
Best tools for this use case
Based on the workflow in this discussion, these tools are useful starting points to review.
Zapier
Best general-purpose automation layer for connecting tools and processes quickly.
Make
Powerful automation builder for advanced visual flow design and multi-step operations.
n8n
Technical automation platform with strong flexibility, control and AI workflow potential.
Answers
Approved replies, operator insight, and tactical follow-up from the community.
Use Zapier’s Schedule trigger (daily 07:00) → Search tickets (last 24h) → Formatter: remove PII with regex (emails/phones/names → [REDACTED]; hash IDs) → Aggregate ticket texts into one batch (keep prompt ≤ ~3k tokens) → Call ChatGPT once to produce a 5–8 bullet digest (top issues, counts, urgent items) → Post to Slack. If you must call per-ticket, throttle to ≤60 req/min and add exponential backoff.