Daily Federal Grant Digest to Slack & Google Sheets (n8n)

Get new federal grant leads in Slack every morning—automatically

This n8n workflow checks SpecStream for open federal grants every day at 7:00, logs newly found opportunities into Google Sheets, and posts a single, neatly formatted Slack message with links, funders, and deadlines—so you never miss a new funding opportunity.

What this workflow does

• Scheduled run: Triggers daily at 7:00.
• Reads your parameters & existing log: Loads your configured search parameters and reads the existing grant log from Google Sheets to decide how to query.
• Efficient SpecStream querying: On the first run, SpecStream starts with your initial search request. On later runs, it reopens the most recent results list so only new grants are returned.
• Quote + spend control: Requests a SpecStream price quote for the run and stops with an error if the maximum cost exceeds your configured spending limit.
• Approves and monitors the run: Approves the quote so SpecStream starts, then checks every 30 seconds until the run finishes.
• Normalize, log, and notify: Fetches all result rows, normalizes them into one item per grant (including the official source link and list ID), appends to Google Sheets, and sends one Slack message with a bullet per new grant.

Use cases

• Grant research teams who want daily federal grant alerts without manual searching.
• SaaS operators tracking funding eligibility by field—keeping a structured grant log in Google Sheets.
• Automation engineers building reliable workflows with cost limits, retries, and controlled notifications to Slack.

Technical details

• SpecStream via n8n HTTP Request using Bearer Auth (API key required).
• Google Sheets for reading the existing log and appending new grants.
• Slack to post a single consolidated message to your chosen channel.
• Uses workflow logic nodes such as if, set, code, wait, plus supporting steps (including Slack formatting and sticky notes).