Connectors

/

Ramp

/

Draft a Ramp bill from a Procore requisition
Write
Cross-Connector

Draft a Ramp bill from an approved Procore requisition

For accounts payable teams who want a draft bill in Ramp created from an approved Procore requisition, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Draft a Ramp bill from a Procore requisition
Draft a Ramp bill for Fabrikam Concrete invoice INV-2207 on the Riverside Tower project.
Requisition INV-2207 is Approved and Ramp has no bill or draft for it, so this will be a new draft. - Vendor: Fabrikam Concrete (one match in Ramp) - Entity: Contoso Construction US - Invoice number: INV-2207 - Amount due: 18,400.00, billing date 28 February Shall I create the draft bill in Ramp?
Ramp
Sample figures. Your results come from your own account.
procore-get-requisitions
ramp-get-bill
ramp-get-bill-draft
ramp-get-vendor
ramp-get-entity
ramp-bill-draft-add
ramp-bill-draft-add-line-item

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Ramp

Ramp
Run it on your own Ramp data.

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

Try PopdockAI free

The problem

An approved requisition is retyped into Ramp

When an approved Procore requisition has no bill in Ramp, someone retypes the vendor, amount and dates into a new one. The same invoice is keyed twice or with the wrong amount.

Without PopdockAI

  • Open the requisition in Procore and note the amounts
  • Search Ramp bills and drafts for the invoice
  • Find the vendor and business entity in Ramp
  • Key the bill and its line item by hand

With PopdockAI

  • The requisition must be Approved or the job stops
  • Ramp bills and drafts are checked for a duplicate first
  • The vendor must match exactly one Ramp vendor and is never created
  • You confirm first, and only a draft bill is created, never submitted or approved

The prompt

Use this prompt

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

Prompt
**Objective:** Create a draft bill in Ramp for the Procore requisition with vendor invoice number `{vendor-invoice-number}` on project `{project-name}`, but only after confirming no bill already exists and the user agrees. Use `{ramp-entity-name}` as the Ramp business entity (default: the only entity, if there is just one).

**Step 1: Read the requisition from Procore**

Call `procore-get-requisitions` (Procore server) with `vendor-invoice-number` set to `{vendor-invoice-number}` and `project-name.contains` set to `{project-name}`. If it returns more than one row, list them and stop. Keep `vendor`, `current-payment-due`, `billing-date`, `invoice-number` and `status`. If `status` is not Approved, stop and report it.

**Step 2: Check Ramp for an existing bill**

Call `ramp-get-bill` (Ramp server) with `vendor-name.contains` set to the `vendor`, and `amount.min` and `amount.max` set to `current-payment-due` minus and plus 0.01. Also call `ramp-get-bill-draft` (Ramp server) with the same `vendor-name.contains` and `amount.min` and `amount.max`. If either returns a bill or draft with the same invoice number, report it and stop. Do not create a duplicate.

**Step 3: Find the vendor and entity in Ramp**

Call `ramp-get-vendor` (Ramp server) with `name.contains` set to the `vendor`. If there is not exactly one match, list the matches and stop. Then call `ramp-get-entity` (Ramp server) and pick the entity named `{ramp-entity-name}`, or the only entity if just one exists.

**Step 4: Confirm with the user**

Show the vendor, the Ramp vendor id, the entity, the invoice number, the amount and the dates you will use, and ask the user to confirm. Do not continue without an explicit yes.

**Step 5: Create the draft**

Call `ramp-bill-draft-add` (Ramp server) with `vendor_id` from the Ramp vendor, `entity_id` from the entity, `invoice_number` from the requisition's `vendor-invoice-number`, `issued_at` set to `billing-date`, and `invoice_currency` set to USD unless the entity says otherwise. Then call `ramp-bill-draft-add-line-item` (Ramp server) with the new draft's id as `draft-bill-id`, `amount` set to `current-payment-due`, and `memo` naming the Procore project and requisition.

**Step 6: Report**

The new draft bill id, the amount, the vendor, and a note that the draft still needs approval in Ramp.

**Rules & Guidelines:**

* `procore-get-requisitions` is on the Procore server. All Ramp tools are on the Ramp server.
* The only tools that may write are `ramp-bill-draft-add` and `ramp-bill-draft-add-line-item`, only after the explicit yes in Step 4. Never call `ramp-bill-add`, `ramp-bill-update`, `ramp-bill-archive`, or any `procore-create-`, `procore-update-` or `procore-delete-` tool.
* Create one draft per run and never a draft bill that duplicates an existing bill or draft.

**Validation:**

* If the requisition is not found or not Approved, stop and say so.
* If the vendor is missing in Ramp, stop and tell the user the vendor must be added first; do not create it.
* If the user does not confirm, make no changes.

Who it's for

One answer, three teams that use it

Accounts payable

Get approved requisitions into Ramp

Turn an approved requisition into a draft bill without retyping, then approve it in Ramp as usual.

Draft a Ramp bill for invoice INV-3110 on Fabrikam Depot.

Project accountants

Avoid keying an invoice twice

The check for an existing bill or draft catches duplicates before they reach the payment run.

Is there already a Ramp bill or draft for Contoso Electrical invoice INV-0872 on Northwind Plaza? If not, draft one.

Finance controllers

Keep approval where it belongs

Drafts stop at draft, so a person still reviews and approves the bill in Ramp.

Create a draft in Ramp for the approved Riverside Tower requisition INV-2207 under entity Contoso Construction US.

How it works

What PopdockAI does when you ask

You name the invoice and the project. Your AI assistant reads Procore, checks Ramp and writes a draft only after you have seen the values and said yes.

Ask

You give the vendor invoice number, the project and the Ramp business entity if needed.

Your AI tool

Check

It reads the requisition, confirms it is Approved and checks Ramp bills and drafts for a duplicate.

procore-get-requisitions
ramp-get-bill
ramp-get-bill-draft
ramp-get-vendor
ramp-get-entity

Match

It finds exactly one Ramp vendor and the business entity, and stops if either is unclear.

No items found.

Create

You confirm the values, it creates one draft bill with a line for the amount due and reports the draft id.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

procore-get-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

ramp-get-bill

Returns Ramp bills as read from the Ramp connector. Filters include: vendor name, approval status, id, vendor name contains, due date to.
get-data

ramp-get-bill-draft

Returns Ramp draft bills as read from the Ramp connector. Filters include: comment object type, maximum records, vendor id, minimum amount, vendor name contains.
get-data

ramp-get-vendor

Returns Ramp vendors as read from the Ramp connector. Filters include: name contains, created at to, legal name contains, vendor owner id, maximum records.
get-data

ramp-get-entity

Returns Ramp business entities as read from the Ramp connector. Filters include: connected subsidiary external id, id, connected subsidiary name, maximum records, connected subsidiary name contains.
run-action

ramp-bill-draft-add

Add draft bill in Ramp. Writes to the live Ramp account. Not individually tested, so try it against a sandbox Ramp account first.
run-action

ramp-bill-draft-add-line-item

bill_draft.add_line_item in Ramp. Writes to the live Ramp account. Not individually tested, so try it against a sandbox Ramp account first.
Read only.Nothing in Ramp 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

One draft bill per approved requisition, ready for approval in Ramp

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

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