Weekly vendor watchlist tracker with Slack alerts
Every Monday at 7am ET, log adoption and growth metrics for your vendor watchlist into Google Sheets and ping Slack only when something material changes.
Ramp Data
Google Sheets
SlackOperationsFinanceResearch & MonitoringNotifications & AlertsData SyncBuild me a code workflow that maintains a weekly vendor watchlist in Google Sheets and pings Slack only when something material changes.
Trigger: cron, every Monday at 7:00am America/New_York.
Inputs (configurable on the workflow): a list of Ramp Rate vendor slugs to watch (e.g. ["salesforce", "hubspot", "notion"]), the Google Sheets spreadsheet ID and tab name to write into, the Slack channel ID for alerts, and a numeric week-over-week growth threshold (default 5 percentage points).
For each vendor slug, call the ramp-data Get Ramp Rate Vendor Profile operation. Ramp Data is a public, no-auth API, so no credential is needed for it. Read the vendor's primary category, adoption rate, year-over-year growth, new adopter share, competitor switch rate, and rank within its primary category from the response. Handle empty/404 responses gracefully (log and skip that vendor for the week, do not fail the whole run).
Then, for each vendor, append exactly one row to the configured Google Sheet using the google-sheets Append Values operation. Columns, in order: run_date (ISO date in ET), vendor_slug, primary_category, adoption_rate, yoy_growth, new_adopter_share, competitor_switch_rate, category_rank. Use USER_ENTERED value input so dates and percentages format cleanly.
After the sheet write, use google-sheets Get Values (or Batch Get Values) to read the same tab back, find the most recent prior row for each vendor (the row with the largest run_date strictly before today's run_date), and compare against this week's numbers. Flag a vendor if any of: yoy_growth flipped from non-negative to negative, abs(yoy_growth_this_week - yoy_growth_last_week) > threshold (default 5 percentage points), or category_rank changed. Skip vendors with no prior row (first run, or new addition).
If at least one vendor is flagged, send a single Slack message via the slack Send a Message operation to the configured channel. Format it as a short header line (e.g. "Vendor watchlist alerts for {date}") followed by one bullet per flagged vendor naming the vendor, the specific change(s) detected, and the before/after numbers. If nothing is flagged, do not send a message.
This is a deterministic pipeline (fixed list, fixed columns, fixed thresholds), so ship it as a code workflow with discrete nodes, not an agent. Keep retries and error handling defensive: a failure on one vendor should not block the others, and rate-limit/5xx responses from Ramp Data should retry with backoff.
What does this prompt do?
- Pulls fresh adoption, growth, and category-rank metrics from Ramp Rate for every vendor on your watchlist, every Monday morning.
- Appends one tidy row per vendor to a Google Sheet so you build a weekly history without ever opening another tab.
- Compares this week's numbers against last week's row in the same sheet and flags vendors whose growth flipped negative, swung more than 5 points week-over-week, or changed category rank.
- Sends a single Slack message naming each flagged vendor and the change, so you only get pinged when something is actually worth a meeting.
What do I need to use this?
- A Google account with edit access to the spreadsheet you want to track vendors in.
- A Slack workspace and a channel where the alert messages should land.
- A short list of vendor slugs to watch (your portfolio companies, top competitors, or key SaaS vendors). Ramp Rate data is public, so no Ramp account is required.
How can I customize it?
- Swap the vendor list for whoever you actually care about: portfolio companies, the competitive set, your renewal-heavy SaaS vendors.
- Change the schedule (it ships at Monday 7am ET, but daily, biweekly, or first-of-the-month works too).
- Tune the alert thresholds. Five points week-over-week is a reasonable default, but research and finance teams often raise or lower it.
- Pick the columns that go in the sheet. The default set covers run date, vendor, category, adoption, year-over-year growth, new adopter share, and competitor switch rate.
FAQs
Do I need a Ramp account to use this?
What if a vendor on my list isn't tracked by Ramp Rate?
Can I change which Slack channel the alerts go to?
What counts as a material change worth alerting on?
Will old rows get overwritten?
Related templates
Stop buying stale lists. Reps run a saved search, work the results like an inbox, and only the accounts they approve ever reach your CRM.
Drag creators through Sourced to Wrapped on a board grouped by campaign, with audience stats on every card and a one-click brief for each creator.
Search creators for free, shortlist the best with your team, and spend an audit credit only when you decide someone is worth a closer look.
Pick a repricing rule, send an assistant out to check competitor pages, then approve the new prices that clear your margin floor.
See the projected bounce rate for any outbound send before it goes out, and keep the launch button locked until the list is clean enough to be safe.
One screen showing invited, completed, and shortlisted counts for every open role, plus the stalled invites that have quietly gone nowhere.
Stop spot-checking vendors in a dozen browser tabs.
Connect Google Sheets and Slack once, and Geni runs your vendor watchlist every Monday at 7am ET.