Weekly LeadsForge outbound digest to Sheets and Slack

Build me a deterministic code workflow that runs every Monday at 8am local time and produces a weekly outbound performance digest for my LeadsForge workspace. The pipeline is fetch, format, log, notify. No judgement steps or free-text summarization, just structured metrics moved between systems.

Trigger: cron, every Monday at 8:00 in the workspace's local time zone. Expose the schedule and time zone as editable configuration.

Step 1. Compute the 7 day window ending at the run time (previous Monday 00:00 through Sunday 23:59, inclusive). Call LeadsForge Get Workspace Sequence Metrics for that date range and capture workspace-level totals for opens, clicks, replies, positive replies, bounces, and unsubscribes. Include the total emails sent if the endpoint returns it.

Step 2. Call LeadsForge List Sequences to enumerate active sequences in the workspace. For each active sequence, call LeadsForge Get Sequence Analytics for the same 7 day window and capture the sequence id, sequence name, emails sent, open rate, click rate, and reply rate. Handle pagination on List Sequences and skip paused or archived sequences by default.

Step 3. Append rows to a Google Sheet using Google Sheets Append Values. The sheet id, tab name, and column layout should be configuration. Write one workspace summary row per run (columns: run_date, window_start, window_end, emails_sent, opens, clicks, replies, positive_replies, bounces, unsubscribes) followed by one row per active sequence (columns: run_date, window_start, window_end, sequence_id, sequence_name, emails_sent, open_rate, click_rate, reply_rate). This sheet is a rolling weekly log used for trend tracking, so we always append, never overwrite.

Step 4. Post to Slack via Slack Send a Message to a configured channel (default #outbound). The message should include: the date window, workspace totals with rates computed from the totals (open rate, click rate, reply rate, bounce rate), the top 3 sequences by reply rate with sends and reply rate, the bottom 3 sequences by reply rate (only among sequences with a minimum sends threshold, default 25, to avoid noise from brand new sequences), and a direct link to the Google Sheet. Format cleanly with Slack markdown.

Configuration to expose at the top of the workflow: cron schedule and time zone, LeadsForge workspace id, Google Sheet id and tab names for the workspace log and the sequence log, Slack channel, and the minimum sends threshold for the bottom 3 ranking.

Error handling: if List Sequences returns zero active sequences, still append the workspace summary row and post a Slack message that says there were no active sequences last week. If a single Get Sequence Analytics call fails, log the sequence id and continue with the rest rather than failing the whole run.