**Every Friday at 5 PM PT, compile what the team shipped this week and share a summary in Slack.** 1. **Fetch completed Linear tickets** — Use to retrieve all issues completed (status = "Done" or "Completed") in the past 7 days. Collect each ticket's ID, title, assignee, completion date, and **URL**. 2. **Fetch merged GitHub PRs** — Use to retrieve all pull requests with state "closed" from the repository **autodex** (owner: **decisional**). Filter to only PRs that were actually merged in the past 7 days. Collect each PR's number, title, author, merge date, and **URL**. 3. **Check if anything shipped** — If both the completed tickets list and merged PRs list are empty, skip the Google Doc and Google Sheet creation (steps 4–5). Instead, go directly to step 6 and post a short notice to Slack with a playful joke about nothing shipping. 4. **Create the Google Doc report** — Use to create a new Google Doc titled "Weekly Shipping Report — [date range]". The document should contain: - A heading with the report date range - A **Completed Tickets** section with a bulleted list — each ticket's **ID is a clickable link** to the Linear ticket URL (e.g., `[DEC-123](url)`), followed by the title and assignee - A **Merged Pull Requests** section with a bulleted list — each **PR number is a clickable link** to the GitHub PR URL (e.g., `[#42](url)`), followed by the title and author 5. **Create the Google Sheet** — Use to create a new spreadsheet titled "Weekly Shipping Report — [date range]". Then use to populate it with: - **Sheet 1 ("Linear Issues Completed")**: columns for Ticket ID, Title, Assignee, Completion Date — the **Ticket ID cell should be a HYPERLINK** to the Linear ticket URL (no separate "Link" column) - **Sheet 2 ("Merged PRs")**: columns for PR Number, Title, Author, Merge Date — the **PR Number cell should be a HYPERLINK** to the GitHub PR URL (no separate "Link" column) Use to add the second sheet. 6. **Post to Slack** — Use to send a message to the **#engineering** channel (channel ID: **C06HANWJSFL**) with: - A summary line (e.g., "Weekly Shipping Report — X tickets completed, Y PRs merged") - Links to the Google Doc and Google Sheet - A brief bulleted recap of the top items — each **ticket ID and PR number should be a clickable Slack link** to the original Linear/GitHub URL

Weekly Shipping Report Agent

Weekly Shipping Report Agent

Ready to Automate?