ThriveCart to Google Sheets and Slack: log sales and post alerts

PromptCreate

Build me a deterministic code workflow that runs every time a new sale happens in ThriveCart, logs the order to a Google Sheet, and posts a real-time alert to a Slack channel.

Trigger: a webhook from ThriveCart for order.success events. On first install, the workflow should call ThriveCart's Create Event Subscription operation to subscribe the workflow's webhook URL to the order.success event so I don't have to set up the subscription by hand.

Steps:

1. Parse the ThriveCart webhook payload and extract: customer name, customer email, product name, order amount (in cents), affiliate name (if any), order ID, and customer country. Convert the amount from cents to dollars (divide by 100, format to 2 decimal places) since ThriveCart returns monetary values in cents.

2. Call Google Sheets Append Values to add a new row to a configurable spreadsheet and tab (default tab name: "Sales Log"). Columns, in order: Date (the order timestamp), Customer, Email, Product, Amount (formatted dollars), Affiliate, Order ID.

3. Call Slack Send a Message to a configurable channel with a tidy summary like: "New sale: $49.99 for Starter Course by Jane Doe (jane@example.com). Order ID: 12345." Include the affiliate name in the message if one is present.

Configuration inputs the user should be able to set: the Google Sheet ID, the tab name, and the Slack channel. Defaults are fine for the tab name.

This is a fixed mapping with no judgement calls, so keep it as a straight-through code workflow with no LLM steps. Handle missing optional fields (like affiliate or country) gracefully so the row and the Slack message still post cleanly.

What does this prompt do?

Adds a new row to your sales spreadsheet for every successful ThriveCart order, with date, customer, email, product, amount, affiliate, and order ID.
Posts a real-time alert to the Slack channel of your choice so the team sees each sale as it happens.
Converts ThriveCart's raw amount into clean dollars so the sheet and the Slack message are ready to read.
Replaces the two-Zap stack most ThriveCart sellers stitch together to track orders and notify their team.

What do I need to use this?

A ThriveCart account where you can create an API key.
A Google account with access to the Google Sheet you want to log sales in.
A Slack workspace and a channel where the sale alerts should appear.

How can I customize it?

Pick which Slack channel gets the alerts, and tweak the message wording or emoji to match your team's style.
Change which spreadsheet and tab the row gets appended to, or add columns like coupon code, currency, or order bump.
Filter the alerts so only sales above a certain amount, or for a specific product, get posted to Slack.

FAQs

Does it fire on every ThriveCart product, or can I pick one?

By default it logs every successful order. If you only want certain products, add a filter for the product name or ID and the workflow will skip the others.

What columns end up in the Google Sheet?

Date, customer name, email, product, amount in dollars, affiliate, and order ID. You can add or remove columns by editing the workflow's mapping step.

Will the dollar amount be correct?

Yes. ThriveCart returns amounts in cents, and the workflow converts them to dollars before writing the row and sending the Slack message.

Can I send the alert to more than one Slack channel?

Yes. Duplicate the Slack step and point each copy at a different channel, for example one for the sales team and one for founders.

What happens if Google Sheets or Slack is down when an order comes in?

The workflow retries automatically. If a step keeps failing you'll see the run in your General Input history so you can replay it once the service is back.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.