Log every Hotmart sale and subscription event in Google Sheets

Every purchase, refund, and subscription change from Hotmart is automatically recorded in a spreadsheet.

How the work actually flows

It branches. Exactly one path is taken.

Pattern: Exclusive Choice (4) · Simple Merge (5)

flowchart TD trig>"Hotmart sale or subscription event"]:::trig s0["Identify event type"]:::task s1[("Write event to spreadsheet")]:::store trig --> s0 gx{"× which event type occurred"}:::gate s0 --> gx p00["Read buyer and product details"]:::task gx -->|"purchase"| p00 p10["Read refund details"]:::task gx -->|"refund"| p10 p20["Read cancellation details"]:::task gx -->|"cancellation"| p20 jn{"○ details merged"}:::gate p00 --> jn p10 --> jn p20 --> jn jn --> s1 out[/"sale or refund logged"/]:::out pay{{"always current sales record"}}:::pay s1 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database OpsAPI & Webhook Integration
Connects
HotmartGoogle Sheets

The problem it solves

Tracking sales, refunds, and subscription changes by hand means constantly switching between your sales platform and a spreadsheet, and it's easy to miss an update. Cart abandonments and cancellations are especially easy to lose track of.

Who it fits

A creator or business selling through Hotmart who needs a clear, always-current record of sales and subscription activity.

How it works

  1. Listens for events from Hotmart such as purchases, refunds, and cancellations
  2. Identifies the type of event that occurred
  3. Reads the buyer and product details for that event
  4. Writes the event to Google Sheets automatically
What you get

Sales events that land in your sheet automatically

Every Hotmart purchase, refund, and subscription change appears in your spreadsheet automatically, giving you a complete and current sales record.

What you get

An always up-to-date spreadsheet of every sale, refund, and subscription event.

What you need

A Hotmart account and a Google Sheets account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn RSS news into published Wordpress blog posts automatically

Reads RSS feeds, picks the best stories, writes full articles with AI, and publishes them to Wordpress.

Advanced

Score and route new leads automatically with AI and Slack alerts

Reads new leads from email or web forms, scores them with AI, updates your CRM, and alerts your team on Slack.

Advanced

Run A/B tested email campaigns tracked in Google Sheets

Sends A/B tested email campaigns from Gmail, tracks results in Google Sheets, and reports progress in Slack.

Advanced

Enrich your company list with AI-generated business details

Feeds your spreadsheet of companies through AI to fill in missing details like industry and description automatically.

Advanced
Back to the AI Playbook