Daily Brand Sentiment Digest in Slack with Infegy

PromptCreate

Build me an agent workflow that runs every weekday at 9am America/New_York on a cron trigger. The job is to deliver a daily brand sentiment digest based on what happened on social in the last 24 hours.

Inputs the user should configure once when setting up the workflow: (1) the Infegy Starscape query for the brand (a list of keywords / phrases / handles plus optional excludes is fine — the agent should turn this into a Starscape query body), (2) the Slack channel ID or name to post the digest into, and (3) the Google Sheets spreadsheet ID and tab name to append the KPI row to.

Each run, the agent should:

1. Use Infegy to look at brand mentions over the last 24 hours and the prior 24 hours (so we can compute day-over-day change). Call Infegy's Get Topics Analysis to get clustered themes with size and sentiment, and call Generate AI Summary to get a narrative recap of the conversation. Optionally use Download Post Records to grab a small sample of high-engagement posts so the digest can link out to interesting examples.

2. Compute KPIs from the Infegy responses: total mention count for the last 24h, percent change vs. the prior 24h, share of positive / neutral / negative sentiment, the top 3 themes by size, and any noteworthy spikes by source (e.g. a sudden surge on Reddit or X). Note when a single source is driving most of the change.

3. Post a formatted message to the configured Slack channel using Slack's Send a Message operation. The message should include: a one-paragraph narrative summary at the top (drawn from Infegy's AI Summary), then bullet highlights covering net sentiment, mention volume vs. yesterday, the top 3 themes (with a sentiment cue per theme), and any source spikes. When relevant, include 2–3 inline links to specific high-signal posts so a human can click through. Use Slack mrkdwn formatting and keep it skimmable.

4. Append one row to the configured Google Sheet using Google Sheets' Append Values operation. Columns, in order: date (YYYY-MM-DD), total mentions, change vs. prior day (signed integer), positive %, neutral %, negative %, theme 1, theme 2, theme 3. Use the same column order every day so the team can chart trends over time.

Edge cases: if mention volume is very low (say under 10 posts) skip the themes section in the Slack message and say so plainly, but still write the Sheets row so the longitudinal log stays continuous. If Infegy returns an error or rate limits, retry with backoff; if it still fails, post a brief failure note to Slack instead of silently skipping. If the Slack post succeeds but the Sheets append fails (or vice versa), surface the partial-success in the run log.

Keep everything to a single workflow — one cron trigger, one agent run per day, one Slack post, one Sheets row.

What does this prompt do?

Pulls the last 24 hours of brand mentions from Infegy and surfaces the dominant themes, net sentiment, and any spikes by source.
Posts a Slack digest with a short narrative summary, bullet highlights, and links out to the most interesting posts.
Appends a daily KPI row to a Google Sheets tracker so your team can chart sentiment, volume, and themes over time.
Runs automatically every weekday morning so the team starts the day with a shared read on brand health.

What do I need to use this?

An Infegy Starscape account with API access enabled.
A Slack workspace and a channel where the digest should land.
A Google account with edit access to the spreadsheet you want to log KPIs into.
Your brand keywords or query ready (the brand name, common misspellings, product names, official handles).

How can I customize it?

Change the schedule, for example to run every day instead of weekdays, or shift it to 8am local time.
Edit the brand query to add product lines, executives, campaign hashtags, or to exclude noisy sources.
Swap the Slack channel, route different brands to different channels, or send to a DM instead.
Adjust the Google Sheet columns, for example add share of voice, top sources, or a link back to the Slack message.

FAQs

Do I need a paid Infegy plan to run this?

Yes. Infegy Starscape is a paid platform and you need an active subscription with API access enabled. Your Infegy account manager can turn on API access if it isn't already.

How do I change which Slack channel the digest posts to?

Open the workflow after it's built and update the channel field. You can also point different brand workflows at different channels, or send a private DM to a single person instead.

Can I run this for more than one brand?

Yes. Duplicate the workflow per brand and give each one its own keyword set, Slack channel, and tab in your Google Sheet. The same template works for competitors and product lines too.

What goes into the Google Sheets log?

Each morning we add one row with the date, total mention count, change versus the prior day, the positive, neutral, and negative share, and the top three themes. You can chart any of those columns to spot drift over time.

What if there were very few mentions yesterday?

The digest will still post, but it will say so plainly and skip the themes section if there isn't enough data to cluster. The Sheets row still gets written so your trend line stays continuous.

Related templates

Review desk for portal forms your team still fills in by hand

Stage a batch of filings overnight, then approve each completed form from a screenshot before anything is ever submitted.

App

Partner tier review board for quarterly promotion calls

Work every partner tier decision from one board, with the revenue and commission numbers, clear promotion thresholds, and AI review briefs.

App

Reconcile partner commissions between HubSpot and Introw

Open one board at month end to find every closed deal missing a commission, every commission with no deal behind it, and every amount that does not add up.

App

Audit what Intercom's Fin AI actually resolved before you pay

Review every conversation Fin closed as resolved, judge which ones actually stuck, and see what the gap is worth against your bill.