See llms.txt for all machine-readable content.

Back to Templates

Log daily Grants.gov AI opportunities to Google Sheets and send Gmail digests

Created by

Created by: Ben Barazandeh || dedicatedcrest
Ben Barazandeh

Last update

Last update 9 hours ago

Categories

Quick overview

This workflow runs daily, fetches newly posted Grants.gov opportunities via an Apify actor, appends the results to Google Sheets, and emails a plain-text digest of the new listings via Gmail.

How it works

  1. Runs every day at 07:00 using a cron schedule.
  2. Calls the Apify grants-gov-opportunity-finder actor with a keyword search for “artificial intelligence” limited to opportunities posted within the last day.
  3. Appends each returned opportunity (title, agency, number, dates, funding fields, and URL) as a new row in a specified Google Sheets spreadsheet.
  4. Aggregates all fetched opportunities into a single list.
  5. Sends a Gmail email to the configured recipient with a digest listing each opportunity and a subject line showing the total count.

Setup

  1. Create an Apify token and add it as HTTP Header Auth (Authorization: Bearer <token>) for the Apify request.
  2. Connect your Google Sheets OAuth2 credentials and replace YOUR_SHEET_ID with your target spreadsheet (and ensure Sheet1 has the expected columns).
  3. Connect your Gmail OAuth2 credentials and set the recipient email address for the digest.