Where customers can drop off returns

Every drop-off point for returns, on a map and in a sheet.

MediumMonthly

E-commerce & D2C brandsE-commerceRetail

Use this template

What it does

Every quarter: post offices and shipping services in each city you sell in, nearest to the busiest blocks, on a returns map and in a sheet for the customer service team.

In one sentence: Monthly on the 1st at 08:00, in London, Manchester and Edinburgh, find post offices, shipping and mailing services and courier services in the area, remove duplicates, then show them on a map, email the list to you and add row in Google Sheets.

Why it is useful

Easy returns sell more. Customer service can point every shopper to a drop-off near them.

Who it is for

E-commerce & D2C brands. Online stores and direct-to-consumer brands choosing pickup points, stockists, pop-ups and cities, and keeping deliveries on time. Every use case for e-commerce & d2c

Best use cases

  • An online fashion store
  • A marketplace
  • A D2C brand

What each run gives you

  • A map
  • A Google Sheet

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 60 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is medium: 7 blocks.

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. Cities we sell inWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Drop-off pointsxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
  4. Each point onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
  5. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.
  6. Update the returns sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
  7. Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.

How to set it up

More for E-commerce & D2C brands