# Queue Trustpilot review invitations for every Shopify order

> Every new order queues a Trustpilot review invitation timed to land about a week after checkout, and logs it to your tracking sheet.

- Workflow type: code
- Services: Trustpilot, Shopify, Google Sheets
- Categories: Marketing, Operations
- Published: 2026-08-10

## What it does

- Watches your Shopify store for new orders and picks up the buyer's first name, email address, and order number.
- Schedules a Trustpilot review invitation to go out about a week later, so it lands after the parcel has arrived rather than at checkout.
- Ties each invitation to the real order number, so the reviews you collect count as verified purchases.
- Logs every invitation to a Google Sheets tab and quietly skips cancelled orders, fully refunded orders, and anyone without an email address.

## What you'll need

- A Shopify store you can connect
- A Trustpilot Business account on a plan that includes review invitations
- At least one invitation email template already set up in Trustpilot
- A Google Sheets spreadsheet with a tab for tracking invitations

## Prompt

Poll my Shopify store for order events. Each time a new order comes in, I want a Trustpilot review invitation queued automatically, so nobody on my team has to remember to ask for reviews.

Before anything else, filter the order out if it is cancelled, if it is fully refunded, or if it has no customer email address on it. Skip those orders silently and do not log them as invitations. From every remaining order, take the buyer's email address, their first name, and the order number.

Resolve my Trustpilot business unit once using Find Business Unit with my store's domain, then call List Invitation Templates to get the invitation email templates available to that business unit. Pick the template I have configured by name, falling back to the first available template if that name is not found. Do not create a new template.

Then call Send Email Invitations for that business unit. Pass the buyer's email address and first name as the recipient, pass the chosen template, and pass the order number as the reference id so every review that comes back ties to a real purchase. Set the preferred send time to roughly seven days after the order was placed, so the invitation lands after the parcel has arrived rather than at checkout.

After each invitation is queued, use Google Sheets Append Values to add a row to my tracking tab recording the order number, the customer email, the scheduled send date, and the template that was used.

Two implementation notes. The Trustpilot invitation endpoints live on a different host from the main API, https://invitations-api.trustpilot.com/v1, and they are private endpoints, so they need a bearer token minted through the client credentials exchange rather than the plain api key header. Also keep track of which order numbers have already been invited, so a re-polled order never produces a duplicate invitation. If Trustpilot rejects an individual invitation, log the failure and keep processing the remaining orders.

## How to customize

- Change the delay. Seven days suits most parcels, but you can shorten it for digital goods or stretch it for made-to-order items.
- Pick a different invitation template, or choose between templates based on what the customer bought or which store they ordered from.
- Add your own skip rules, for example ignoring wholesale orders, test orders, or repeat buyers you have already asked this month.

## FAQ

### When does the review invitation actually reach the customer?

About seven days after the order is placed, which is usually just after the parcel has landed and the customer has had a chance to try what they bought. If your delivery times are faster or slower, you can move that window.

### Will the reviews count as verified?

Yes. Each invitation carries the real order number with it, so Trustpilot can tie the review back to a genuine purchase. Verified reviews are the ones that can feed into Google Seller Ratings, which is why the order number matters.

### What happens with cancelled or refunded orders?

They are skipped. When an order is processed, anything that is already cancelled, fully refunded, or missing a customer email address is passed over silently, so you never ask someone to review a purchase that fell through.

### Do I need to write the invitation email?

No. It uses the invitation templates you have already set up in your Trustpilot account, so the wording and branding stay exactly as you designed them.

### Can I see which invitations went out?

Yes. Every invitation is written to your Google Sheets tracking tab with the order number, customer email, scheduled send date, and the template that was used, so you have a running record you can filter and audit.

Use this prompt in General Input: https://www.generalinput.com/prompts/queue-trustpilot-review-invitations-for-every-shopify-order