Log every ThriveCart sale to Google Sheets and Slack

By General Input

Every new ThriveCart order lands as a row in your sales sheet and a tidy heads-up in Slack, the moment the payment goes through.

Integrations

  • ThriveCart
  • Google Sheets
  • Slack

Type

Deterministic Code

Categories

  • Sales
  • Operations

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.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seats