New ClickFunnels sales to Slack and a Google Sheets ledger

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.