Weekly vendor tracker: Ramp Rate to Google Sheets and Slack

PromptCreate

Build 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?

No. Ramp Rate is a public dataset. You only need a Google account for the sheet and a Slack workspace for alerts.

What if a vendor on my list isn't tracked by Ramp Rate?

The workflow will log the run date and skip that vendor for the week instead of failing. You can either remove it from your list or keep it and check back later as Ramp's coverage grows.

Can I change which Slack channel the alerts go to?

Yes. The channel is a setting on the workflow. Point it at a private research channel, a public competitive intel channel, or a DM to yourself.

What counts as a material change worth alerting on?

By default: year-over-year growth flipping negative, week-over-week growth swinging more than 5 percentage points in either direction, or the vendor's rank inside its primary category changing. All three are easy to adjust.

Will old rows get overwritten?

No. Each run appends a new row, so the sheet becomes a weekly history you can chart, pivot, or share with the team.

Related templates

Auto-fix your calendar when a flight slips, and flag what's at risk

When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.

Agentic Task

Trace phishing emails to the sending IP and report abuse

Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.

Agentic Task

Weekly Amazon S3 bucket security audit posted to Slack

Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.

Agentic Task

Turn procurement portal tenders into CRM deals each morning

Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.