FlowsBook a callSign inCreate free accountSign up
AI employees and automation

How to automate PDF reports that go out on a timetable

Automate PDF reports with your logo: a timetable, the data, an AI summary and a report step that emails the file or files it in a Google Drive folder, with no copying by hand.

Part of the guide AI employees

By the xMap team · · 5 min read

To automate PDF reports, chain four steps and let them run on a timetable: something that starts the run (every Monday, the first of the month, or when a form is filled in), the blocks that gather the data, an AI step that writes a short summary of the whole list, and a report step that lays everything out with your logo and colour and emails the PDF or saves it to a Google Drive folder. Once it works, nobody exports, pastes or formats anything again.

This article is for people who produce the same document again and again: operations managers, analysts, account managers at agencies, franchise and network leads. It covers which reports suit automation, the choices that decide how the PDF looks, where the file should go, a made-up example, the mistakes that make automated PDFs unreadable, and the blocks in order.

Which reports are worth automating

A report is a good candidate when its shape stays the same and only the data changes. Typical cases:

  • A weekly list of road closures and roadworks around a set of depots or sites.
  • A monthly view of new competitors around each store, for a regional manager.
  • A client report from an agency: the businesses around the client's location and how they are rated.
  • A briefing pack before a meeting, built when someone fills in a form with the meeting's city.
  • A quarterly board pack of five slides on the network's surroundings.

Reports that need judgement in every line, such as a negotiation memo, are better drafted by the AI and finished by a person.

The choices that shape the PDF

The Make a report block has a handful of settings, and each one changes what the reader gets:

SettingOptionsWhen to pick what
MakeA report (A4), Slides (16:9), or bothA4 for people who read the list; slides for directors who want one idea per page
TitleYour own, or emptyEmpty uses the flow's name and the date, which keeps a folder of reports in order
IncludeSummary, figures, charts, map, the listLeave out what the reader never uses; a map only helps when results have positions
Send itBy email, or to Google DriveEmail for a few named people; Drive when a team keeps an archive

The settings of Make a report.

The logo and colour come from your organization's settings, so every report looks like your own document. The list holds the first 100 items; the figures and charts count them all.

Where the file should go

Email suits a report a few people read the day it arrives. The PDF is attached, under the usual email rules (on the Free plan, people at your own organization's email domain), and people who unsubscribed are left out.

Google Drive suits reports a team keeps and compares. Give a folder link or a folder name; a name that does not exist yet is made for you, and an empty field uses a folder named after the flow. After a real run, each item carries the link to the PDF, so a block after it can post that link in a message.

A made-up example

This example is invented. A property management firm in Cape Town looks after 25 buildings. Every Friday afternoon its building managers want to know what roadworks and closures are near their buildings before the weekend's move-ins and deliveries.

The firm's flow reads the buildings from a table in My data, checks for traffic incidents around each one, has the AI write a five-line summary naming the buildings most affected, and makes an A4 report with the summary, the count, a map and the list. The PDF lands in a shared Drive folder titled with the date, and an email with the link goes to the building managers. Before, an assistant spent most of Friday morning on it; now the folder simply gains a file each week. A similar flow in Montreal sends a monthly report of new restaurants near a food supplier's customers, as slides.

Mistakes that make automated PDFs useless

  • Everything included. A 40-page list nobody scrolls. Trim the list, keep the summary and the figures.
  • No summary. Without a few sentences on what matters, readers have to work it out themselves, and soon stop opening it.
  • An AI that invents numbers. Tell the summary step to use only the figures in the data. The report's own figures are counted, not written.
  • The wrong day. A Monday report that lands on Saturday is read on Monday afternoon, after the decisions were made.
  • Testing by sending. A test run never sends; check the PDF with Run once to yourself before deploying it to the whole team.

The blocks in order

  1. When: a Schedule (every Friday at 14:00, the first of the month), or a Form page for reports made on request.
  2. Where: an Area of interest, or your own sites from My data.
  3. What: the data blocks, such as Traffic incidents, Nearby places or Weather forecast.
  4. Summary: xMap LLM set to The whole list, with instructions about the reader and a rule against adding numbers.
  5. The PDF: Make a report, A4 or slides, by email or to Drive.

Deployed, the AI employee produces the report on time without anyone touching it, and the PDF in the inbox or folder is the only sign it ran. Ready-made versions include the weekly road disruption report, the monthly area report for hotel owners and the impact report for donors. The help article on reports lists every setting, and the workflow automation guide shows where reports fit among other automations.

Questions

Can the PDF carry my company's logo?

Yes. Make a report uses the logo and colour set in your organization's settings; without them it uses xMap's design.

Can it make slides instead of a document?

Yes. Choose Slides (16:9) for short pages with one idea each, or Both to get two separate PDF files.

Where does the summary come from?

From an xMap LLM block set to The whole list, placed before Make a report. Without one, the report starts with the figures.

Does a test run send the report?

No. A test run says what it would make; Run once and live runs make the PDF and send it.

Templates that do this

Read next

More on ai employees and automation · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.