Get a Project Status Snapshot from Slack and Drive
Pull scattered updates from Slack and Google Drive into one scannable project status summary.
Overview
Project updates live in Slack threads, Google Drive docs, and meeting notes that nobody has time to read. This template connects Slack, Google Drive, and Google Docs so your AI assistant can pull all of it together into one scannable snapshot: what the project is, and what moved recently. Point it at the right channels and folders, and it produces a summary you can paste into Slack, email, or a status doc.
How it works
Name the project or initiative you want a snapshot of. The AI searches your connected Slack channels for recent messages, scans Google Drive folders for updated docs, and synthesizes everything into a structured summary: a 2-3 sentence overview of what the project is, followed by a numbered list of major updates from the past 1-2 weeks. It cites sources so readers can dig deeper, and saves the snapshot to a Google Doc.
Who this is for
Project leads, managers, and stakeholders who need to stay current on initiatives without reading every Slack thread. Also useful for cross-functional updates, executive briefings, and handoff situations where someone new needs to get up to speed fast.
Suggested prompt
Give me a project snapshot for [project name]. Check the [#channel-name] Slack channel and [folder name or link] in Google Drive. Focus on the last 2 weeks. Give me a 2-3 sentence overview of what this project is, then a numbered list of major updates. Save it to a Google Doc and format a version I can paste into Slack.
Frequently asked questions
What sources does it search?
Slack channels (messages and threads) and Google Drive (docs, sheets, notes). If you also use Coda or Jira, it can search those too when connected.
How far back does it look?
Default is the last 1-2 weeks. You can specify any time range: last month, since a specific date, or last quarter. Just mention it in your prompt.
Can I use this for a project I am not directly involved in?
Yes, as long as you have access to the relevant Slack channels and Drive folders. The AI searches based on your permissions.
What format does the output come in?
A structured summary with an overview section and numbered updates. Formatted for Slack by default (with bold labels and links), but you can ask for email or doc format instead.