Connectors

/

HubSpot

/

Complete HubSpot collection tasks for paid Stripe invoices
Write
Cross-Connector

Close HubSpot collection tasks once Stripe shows payment

For finance and collections teams who track Stripe invoices as HubSpot tasks, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Complete HubSpot collection tasks for paid Stripe invoices
Which of my open Collect Stripe invoice tasks in HubSpot are already paid? Close those out.
7 of 12 open collection tasks have a paid Stripe invoice. - Paid: 7 tasks, including INV-1042 for Northwind Traders, 2,400.00 USD - Closed without payment: 1, INV-1037 void, left open for you - Still open: 4, largest INV-1051 with 980.00 USD remaining, 12 days past due - Check: the INV-1044 task email differs from the Stripe customer email Shall I complete the 7 paid tasks?
HubSpot
Sample figures. Your results come from your own account.
hubspot-get-tasks
stripe-get-invoice
hubspot-update-task

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

HubSpot

HubSpot
Run it on your own HubSpot data.

Connect HubSpot, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Reps keep chasing invoices customers already paid

Collection tasks in HubSpot stay open long after the customer pays in Stripe, so reps chase settled invoices. Checking means taking the invoice number from each task, looking it up in Stripe and closing the task by hand.

Without PopdockAI

  • Read each collection task for its invoice number
  • Look the invoice up in Stripe
  • Close paid tasks one at a time
  • Keep chasing the ones you did not get to

With PopdockAI

  • Invoice numbers are taken from open task titles
  • Each invoice is checked in Stripe and grouped by status
  • Mismatched or unreadable tasks are flagged and left alone
  • Only paid tasks you approve are completed, and each is checked

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find open HubSpot tasks whose title contains `{title-text}` (default "Collect Stripe invoice", at most `{max-records}` tasks, default 50) and, after the user confirms, mark completed the ones whose Stripe invoice is now paid.

**Step 1: Read open collection tasks from HubSpot**

Call `hubspot-get-tasks` with `task-title.contains` set to `{title-text}` ("Collect Stripe invoice" if empty) and `max-records` set to `{max-records}` (50 if empty). Keep tasks whose `task-status` is not completed, with `record-id`, `task-title`, `contact-email` and `due-date`. Take the invoice number from the end of `task-title`. Tasks with no number in the title are listed as unreadable and left alone.

**Step 2: Read each invoice in Stripe**

The join is the invoice number in the task title against the Stripe invoice `number`. Call `stripe-get-invoice` with `number` set to it and keep `status`, `amount-paid`, `amount-remaining`, `currency` and `customer-email`. If nothing comes back, list the task as unmatched and leave it open.

Classify each task:

* Paid: `status` is paid, or `amount-remaining` is zero. The task is done.
* Closed without payment: `status` is void or uncollectible. Leave the task open for the user to decide.
* Still open: show amount remaining and how many days past `due-date` the task is.

Note any task whose `contact-email` differs from the invoice `customer-email`, so the user can check it is the right invoice.

**Step 3: Confirm**

Show the three groups with invoice number, customer, status and amounts (minor units divided by 100). Ask for an explicit yes to complete the Paid group and offer to exclude rows. Do not continue without a yes.

**Step 4: Write and verify**

For each confirmed task, call `hubspot-update-task` once with `id` set to the task `record-id` and `status` set to COMPLETED, changing no other field. Then call `hubspot-get-tasks` with `task-title.contains` set to each invoice number and confirm the status. Report completed, failed and skipped tasks.

**Rules & Guidelines:**

* `stripe-get-invoice` is on the stripe server; `hubspot-get-tasks` and `hubspot-update-task` are on the hubspot server.
* The only write tool allowed is `hubspot-update-task`, once per confirmed task, only to set `status` to COMPLETED, and only after the confirmation in Step 3. Call no other hubspot-add, hubspot-update, hubspot-rename, hubspot-remove, hubspot-subscribe, hubspot-unsubscribe or hubspot-import tool.
* The stripe server has no write tools; only the stripe read tools named here are used, and nothing is charged, refunded or sent to the customer.

**Validation:**

* If no open task matches, say so and stop.
* If the user declines or does not answer, stop with nothing written.
* If an invoice number matches more than one Stripe invoice, list them and leave the task open.

Who it's for

One answer, three teams that use it

Collections specialists

Stop chasing paid invoices

Clear the collection tasks for invoices Stripe shows as paid, so your list only holds real work.

Check my open Collect invoice tasks in HubSpot against Stripe and close the paid ones.

Accounts receivable

See which invoices are still open

Get the remaining amount and days overdue for each task still unpaid, and the ones voided without payment.

Which HubSpot collection tasks are for Stripe invoices that are still unpaid, and how much is left on each?

Finance managers

Keep CRM and billing in step

Tasks whose contact does not match the invoice customer are flagged, so the right customer is chased.

Are any HubSpot collection tasks linked to a contact who is not the Stripe invoice customer?

How it works

What PopdockAI does when you ask

Your AI assistant reads the open HubSpot collection tasks and checks each invoice in Stripe. Only the paid tasks you approve are completed, and Stripe is only read.

01

Read

It reads open HubSpot collection tasks and takes the invoice number from each title.

Your AI tool

02

Check

It looks up each invoice in Stripe and groups tasks as paid, closed without payment or still open.

stripe-get-invoice

03

Confirm

You review the groups and approve the paid tasks.

No items found.

04

Complete

It marks those tasks completed and checks each status.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.

get-data

hubspot-get-tasks

Returns tasks in HubSpot, with title, status, priority, type, due date, assignee and related contact from the HubSpot connector. Filter by assigned to, is overdue, due date, task title, task status, task type, contact email, priority.
get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
run-action

hubspot-update-task

Updates a task in HubSpot. Only the fields you pass are changed. Required: Task ID. Optional: Subject, Notes, Due date, Status, Priority, Type, Owner ID. Writes to HubSpot.
Read only.Nothing in HubSpot Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Collection tasks close as soon as payment lands

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation