Weekly competitor intelligence brief from X to Gmail

Build me a weekly competitor intelligence brief that lands in my inbox every Friday at 9am.

Trigger: cron, weekly on Friday at 9am in my local timezone.

Inputs the workflow should expose as configurable variables: (1) a list of competitor X handles to track (start with a placeholder list I can edit), (2) a list of recipient email addresses for the brief, (3) the lookback window in days (default 7), and (4) an optional engagement threshold for highlighting tweets.

Each run, iterate over the competitor handle list. For every handle:

1. Call TwitterAPI.io "Get User Last Tweets" with a sinceTime filter covering the past 7 days so we only get this week's posts. Paginate through the cursor until there are no more tweets in the window. Capture text, link, createdAt, like count, retweet count, reply count, quote count, and view count for each tweet.

2. Call TwitterAPI.io "Get User Info" to grab the current display name, profile picture, follower count, and following count.

Use the workflow's run state to remember each competitor's follower count from the previous Friday. On every run, read the prior count from state, compute the week-over-week delta (absolute and percentage), then write the new count back to state for next week. If there is no prior count yet (first run for that handle), just record the current count and skip the delta for that competitor this week.

Once all competitor data is collected, reason across the full set:

- Cluster the week's tweets into themes such as product launches, hiring, customer wins, PR moments, exec commentary, and memes. Keep the theme list flexible, add or merge themes based on what actually showed up this week.

- For each competitor, identify the single highest-engagement tweet of the week (use a combined like + retweet + reply score, but prefer view count when available) and include the direct link and engagement counts.

- Flag anything that looks like a launch announcement, pricing change, major hire, fundraising news, or competitive callout. Be explicit about why each flagged item matters.

- Build a closing "watch list" of 3-5 accounts that are gaining velocity this week, based on follower growth rate, tweet volume spike, or a single breakout post.

Render a polished HTML email designed to be skimmable in 90 seconds, with this structure:

1. Top-level "What changed this week" section, 3-5 bullets that summarize the most important moves across the whole competitor set.

2. Per-competitor section. For each handle: name and handle, follower count with week-over-week delta (green for gains, red for losses), the themes they hit this week, and their top tweet with link and engagement numbers.

3. Flagged items section listing any launch announcements, pricing changes, or other high-signal posts.

4. Watch list section at the bottom with the accounts gaining velocity and a one-line reason for each.

Use clean inline-styled HTML, a readable email-safe font, and clear section dividers. Subject line should be something like "Competitor brief, week of {date}".

Delivery: call Gmail "Create a Draft" with the rendered HTML, the configured recipient list in the To field, and the subject line. Then call Gmail "Send a Draft" with the draft id returned from the create step. Send from my connected Gmail account.

If any single competitor's TwitterAPI.io calls fail, do not abort the whole run, just note that competitor as "data unavailable this week" in the email and continue with the rest.