Send product reviews invitations by uploading a file with customer data

If you want to invite customers to write product reviews manually, you can create a CSV file that contains your customers' information, then import it to Trustpilot Business. Here’s how to do it.


● All New (paying and free) customers that sign up on or after Oct 1, 2020 will have 90 days from first use to upload a file with customer data.

Existing paying customers, FileUpload will be limited to 90 days from the effective date of contract renewals on or after Nov 1, 2020.

Existing free customers will have access to FileUpload for 90 days from first use on or after Oct 1, 2020.

  1. In Trustpilot Business, go to Get reviews. Click Try a different way to get reviews.
  2. Click Select file and upload your CSV file. The columns in the CSV file should include the following data in this order:
    • Customer email
    • Customer name
    • Reference number
    • SKU
    • Product name
    • Product URL
    • Image URL

Note: If the Reference number and the Customer email address match, all product reviews will be combined in one invitation email.

  1. Check your customer data to make sure it's correct, then click Next.
  2. In the Sender name field, enter your sender information. Then select the Reply-to email address you would like the invitation to be sent from in the drop-down menu. You can also select the option to Add another Reply-to Email. Next, choose if you'd like to send from a generic no reply email, or from your own email domain. Click Next.

  1. In Select template, choose the template you'd like to use from the Select template for the product review invitations menu. You can browse the options and make your selection by clicking Change. You can also choose the language for your invitation.

  1. In the Invitations landing page to send customers to: drop-down menu, select the local Trustpilot website that you want to send your customers to when they write their review. Click Next.

  1. Review your data. If you're satisfied, click Send Invitations.

Note: By default, customers will be asked to leave a product review right after they've written a service review. You can enable separate product review invitations in the Timing and frequency section of your Invitation Settings.

Was this article helpful?