New in town: a weekly column draft

A draft "new in town" column every Thursday, from what opened this week.

MediumWeeklyAI

Media, newsrooms & publishingMediaFood and drinkRetail

Use this template

What it does

Every Thursday: restaurants, cafes and shops that opened in your city this week, the best-rated first, written up by xMap AI as a draft for the weekly "new in town" column, saved to Google Drive for the editor.

In one sentence: Thursdays at 10:00, in Manchester, find restaurants, coffee shops and 2 more in the area, keep only new ones, sort them by rating and keep the top 8, write a report with xMap AI, then create file from text in Google Drive and email the list to you.

Why it is useful

Readers love to know what opened near them. The column almost writes itself when the list of new places arrives with a first draft.

Who it is for

Media, newsrooms & publishing. Newsrooms, broadcasters, publishers and media sales teams who need local stories, audiences and advertisers first. Every use case for media & publishing

Best use cases

  • A local newspaper
  • A city magazine
  • A neighbourhood newsletter

What each run gives you

  • A draft in Google Drive

The time it saves

Thursdays at 10:00. Doing the same work by hand takes about 90 minutes each time; it runs about 5 times a month, so it saves about 8 hours a month (an estimate). It is medium: 8 blocks.

The flow, block by block

  1. Every ThursdayTrigger · ScheduleStarts the flow on a timetable.
  2. My cityWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Places that opened this monthxMap 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. Only new onesLogic · Only newLets through only the items this flow has not found before, so a daily flow sends only what is new.
  5. Best 8 firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
  6. Write the column draftxMap AI · xMap LLMTell the AI what to do in plain words.
  7. Save the draft to Google DriveApp · Google DriveCloud storage and file backup
  8. 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 Media, newsrooms & publishing