ClickFunnels to Slack and Google Sheets: new sale alerts

PromptCreate

Every 15 minutes, check ClickFunnels for new paid orders and fan each one out to Slack and Google Sheets. This is a fully deterministic pipeline. Map each order's fields straight into the alert and the ledger row with no summarization or rewriting.

On each run, use ClickFunnels List Orders to pull the most recent orders sorted newest first (sort_order=desc). List Orders returns 20 records per page, so page back only as far as needed to reach orders you have already processed. Track a watermark of the last seen order id, which is a stable integer, and only act on orders with an id greater than the watermark. As a safety net, also de-duplicate by order id so a given order is never logged twice even across overlapping runs. Only treat orders that are actually paid as new sales.

If the optional minimum order value is set, skip any order whose total is below it so only meaningful sales fire an alert. If it is not set, act on every new paid order.

For each new qualifying order, send a Slack message to the channel I choose using Slack Send a Message. Format the alert to show the customer name and email, the product or products purchased, the order total, and the funnel the order came from. Keep the mapping literal by pulling each value directly from the order.

For that same order, append one row to my Google Sheet using Google Sheets Append Values, writing to the spreadsheet and tab I specify. The row should capture the same fields as the Slack alert, meaning customer name, customer email, product or products, order total, and the funnel, plus the order date, so the sheet becomes a running ledger of every sale. Keep the column order consistent so the ledger stays clean.

Let me configure the Slack channel, the target spreadsheet and tab, and an optional minimum order value. Run this on a cron every 15 minutes.

What does this prompt do?

Checks ClickFunnels for new paid orders every 15 minutes, around the clock
Posts a clean sales alert to your chosen Slack channel with the customer, products, order total, and funnel
Adds every sale to a Google Sheet as a new row, building a running ledger you can sort, filter, and total
Skips orders it has already logged, so nothing ever gets counted twice

What do I need to use this?

A ClickFunnels account with orders coming in
A Slack workspace and the channel where you want sales alerts to land
A Google account with the spreadsheet and tab you want to use as your sales ledger

How can I customize it?

Choose which Slack channel gets the sales alerts
Pick the Google spreadsheet and tab where every sale is logged
Set an optional minimum order value so only sales at or above that amount trigger an alert

FAQs

How quickly will I hear about a new sale?

The workflow checks ClickFunnels every 15 minutes, so a new paid order shows up in Slack and your spreadsheet within about a quarter of an hour.

Will the same order ever get logged twice?

No. The workflow remembers which orders it has already handled and skips anything it has seen before, so your Slack channel and spreadsheet stay clean.

Can I get alerts only for bigger sales?

Yes. You can set an optional minimum order value, and only sales at or above that amount will trigger a Slack alert and a new row in your sheet.

What details show up in the Slack message?

Each alert includes the customer's name and email, the product or products they bought, the order total, and the funnel the sale came from.

Do I need to set up the spreadsheet first?

Just have a Google Sheet and a tab ready. The workflow adds a new row for every sale with the customer, products, order total, funnel, and order date.

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.