Connectors

/

Ramp

/

Match Ramp users to PowerGP Online employees
Report
Cross-Connector

Find Ramp card users whose GP employee has left

For IT and integration teams who want Ramp users checked against Dynamics GP employees by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Ramp users to PowerGP Online employees
Check our active Ramp users against employees in the Fabrikam GP company and show anyone who is active in Ramp but not in GP.
120 active Ramp users checked, 4 need attention. - Active in Ramp, inactive in GP: 2 users - No GP employee found: 1 user - Matched by name only, low confidence: 1 user - Name differs between systems: 3 users Want the list of the 2 priority users with their employee ids?
Ramp
Sample figures. Your results come from your own account.
ramp-get-user
powergp-online-get-employees

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

Leavers in Dynamics GP stay active as Ramp card users

When someone leaves, HR changes their employee status in Dynamics GP, but nobody cross-checks the Ramp user list. Leavers stay active as card users, and spotting them means comparing two lists person by person.

Without PopdockAI

  • Export Ramp users
  • Export GP employees with their status
  • Match people one by one
  • Miss a leaver whose name is spelled differently

With PopdockAI

  • Ramp users read, up to 200
  • Each matched in GP by employee id, or by name when no id exists
  • Missing, inactive and low confidence matches listed with counts
  • No pay or personal data shown, and nothing changed

The prompt

Use this prompt

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

Prompt
**Objective:** Compare Ramp users with the employees in Dynamics GP company `{gp-company}` and report people who are active in one system and not the other, for Ramp users with status `{ramp-status}` (default ACTIVE).

**Step 1: Ramp users**

Call `ramp-get-user` (ramp) with `status` set to `{ramp-status}`. Keep `id`, `first-name`, `last-name`, `email`, `employee-id`, `status`, `role`. Cap at 200 and say if you capped.

**Step 2: GP employees**

For each Ramp user with an `employee-id`, call `powergp-online-get-employees` (powergp-online-ai) with `employee-id` set to that value and `company` set to `{gp-company}`. Keep `employee-id`, `first-name`, `last-name`, `employee-status`, `department-id`. For Ramp users with no `employee-id`, call it with `first-name` set to the Ramp first name and match on last name too.

**Step 3: Report**

Lists: Ramp users with no GP employee; Ramp users active while the GP employee is not active (the priority list); name differs between systems; Ramp users matched only by name (low confidence). Then counts.

**Rules & Guidelines:**

* Tools whose names start with ramp-get are on the ramp server; tools whose names start with powergp-online-get are on the powergp-online-ai server. Both servers must be connected.
* This prompt is read-only. Never call any Ramp tool that adds, updates, deletes, archives, suspends or terminates anything (any `-add`, `-update`, `-delete`, `-archive`, `-suspend` or `-terminate` tool on the ramp server). The powergp-online-ai server has no write tools.
* Pass `company` to every GP tool; if `{gp-company}` is empty, ask which GP company to use before calling.
* Report amounts with their currency. Do not net amounts across different currencies.

**Validation:**

* Never output `social-security-number` or any other field beyond those listed, even though the GP tool returns them.
* If employee ids are blank for most Ramp users, say the match is name-based and low confidence.

Who it's for

One answer, three teams that use it

IT administrators

Remove card access for leavers

Active Ramp users whose GP employee is inactive are listed for action.

Which active Ramp users are inactive employees in our Contoso GP company?

HR managers

Check offboarding reached Ramp

See which leavers still hold Ramp access, without exposing pay or personal data.

Compare Ramp users with GP employees in Northwind and show anyone not active in GP.

Internal auditors

Test user access with evidence

Counts and match confidence give you a clear record of the review.

Match all Ramp users to Fabrikam GP employees and list low confidence matches.

How it works

What PopdockAI does when you ask

You choose a GP company and Ramp user status and your AI assistant matches users to PowerGP Online employees. Name-only matches are marked low confidence.

01

Ask

You choose the GP company and the Ramp user status to review.

Your AI tool

02

List

It reads the Ramp users, up to 200.

ramp-get-user

03

Match

It looks each one up in GP by employee id, or by name when no id exists.

powergp-online-get-employees

04

Report

You get missing, inactive and low confidence matches with counts.

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

ramp-get-user

Returns Ramp users as read from the Ramp connector. Filters include: scheduled invitation date to, status, last name, maximum records, role.
get-data

powergp-online-get-employees

Returns employees from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
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

Leavers with live Ramp access found quickly

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