Start free

Loop Returns connector · Returns reports

Read & reportRead-only source

See why customers return, and how much revenue you keep.

Bring Loop returns, returned items and reasons into your reports and AI assistants: refunded, exchange and store credit value, handling fees and upsells, and the reason behind every returned item.

  • Track refunds against exchanges and store credit each week
  • Find the products and reasons behind most returns
  • Ask ChatGPT or Claude which sizes to fix first
Loop ReturnsSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

Loop Returns reportSample data
Return reasonItemsExchanged items
Too small412268
Changed my mind18622
Arrived damaged4119
Refreshes on your schedule in Google Sheets

Loop Returns reporting for one store

One Loop store is the data source. Returns created in your report dates are included in every status, in UTC days and the store’s currency.

Returns

Read each return’s order, state, outcome, item value, refunded, exchange value, store credit, handling fee and upsell.

Returned items

See each item’s SKU, product, price, refund, reason category, return reason and exchange.

Reasons

Group items by reason with returns, exchanges, item value and refunds.

Every status

Open, closed, expired, cancelled and review returns are all included.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Returns
  • Returned items
  • Return reasons
What each dataset reports
  • Returns

    Returns created in the report dates in every state, with outcome, return value, refund, exchange value, store credit and handling fee in your store's currency.

  • Returned items

    Each returned item from returns created in the report dates, with product, SKU, price, refund and the customer's return reason.

  • Return reasons

    Returned items from the report dates grouped by the customer's reason, with returns, exchanged items, item value and refunds for each reason.

Metrics and dimensions

43 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Loop Returns data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect Loop Returns to ChatGPT or Claude for returns questions

Use Datapipe’s MCP access as your Loop reporting tool. Ask about reasons, refunds and exchanges.

Example

Which SKUs were returned most for sizing last month, and how many became exchanges?

Count last month’s returned items with a sizing reason by SKU, show how many were exchanged instead of refunded, and rank by items.

Start with Loop Returns

What you need

A Loop API key with the Returns scope, from Returns Management, Tools & integrations, Developer Tools in Loop Admin.

What to know

Read-only. Datapipe never changes returns. Up to 20,000 rows per report.

How it works

  1. Create your free account, then choose Loop Returns in Data sources.

  2. Paste your Loop API key with the Returns scope.

  3. Choose returns, items or reasons and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with Loop Returns

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Returns with refund, exchange and store credit values, every returned item with its reason, and totals by reason.

Yes. Returns in every status are read.

Your store’s default currency, as Loop reports it.

No. It only reads them.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each Loop Returns account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Turn returns into fixes.

Start free, add Loop Returns and bring return reasons into the tools you already use.

Start free See setup requirements