Automate Your Weekly Business Report With AI: A Complete Setup

Introduction

Every Monday morning, you probably spend 30–60 minutes pulling together the same numbers: revenue, expenses, top customers, outstanding invoices. Then you write a summary email to yourself or your team. This setup automates all of that.

By the end of this guide, you’ll have a system that automatically pulls your weekly financial data from Xero, sends it to an AI, and delivers a plain-English business summary straight to your inbox — every Monday before you’ve had your first coffee.

Total setup time: About 45–60 minutes, no coding required.


What You’ll Need

Before you start, make sure you have the following:

  • A Xero account with at least a few weeks of transaction history
  • A Make account (formerly Integromat) — the free plan is enough to start
  • An OpenAI account with API access — you’ll need a paid account (usage costs roughly $0.01–0.05 per report)
  • A Gmail or Outlook inbox to receive your reports
  • A laptop or desktop (this is tricky to set up on a phone)

Step-by-Step Setup

Phase 1: Connect Xero to Make (10–15 minutes)

  1. Log in to Make at make.com. Once you’re on the dashboard, click the blue + Create a new scenario button in the top right corner.

  2. Add your first module. You’ll see an empty canvas with a large circle. Click it, then type “Xero” in the search box. Select Xero from the results.

  3. Choose the trigger action. From the list of Xero actions, select Search Records. This tells Make to go fetch data from your Xero account on a schedule.

  4. Connect your Xero account. Click Add next to the Connection field. A popup will appear asking you to sign into Xero and grant Make permission. Click Allow Access. Once connected, you’ll see your organization name appear in the field.

  5. Configure what data to pull. In the Record Type dropdown, select Profit and Loss Report. Set the From Date to {{formatDate(addDays(now; -7); "YYYY-MM-DD")}} and the To Date to {{formatDate(now; "YYYY-MM-DD")}}. This automatically fetches the past 7 days every time the scenario runs. Copy these values exactly, including the curly braces.

  6. Add a second Xero module for invoices. Click the small + icon to the right of your first module. Search for Xero again and select Search Records. This time, choose Invoices as the record type, and filter by Status = AUTHORISED to pull only outstanding invoices.

Phase 2: Build the AI Summary (15–20 minutes)

  1. Add an OpenAI module. Click the + after your invoice module, search for OpenAI, and select Create a Completion (GPT-4o).

  2. Connect your OpenAI account. Click Add next to Connection. You’ll need to paste in your OpenAI API key. To get this, open a new tab, go to platform.openai.com, click your profile icon in the top right, and select API Keys. Click Create new secret key, copy it, and paste it into Make. Click Save.

  3. Write your prompt. In the Messages section, click Add item, set the role to User, and paste this into the Content field — then customize the bracketed parts:

    You are a business analyst summarizing weekly performance for a small business owner named [Your Name]. Here is their financial data for the week:

    Profit & Loss Summary: {{1.rows}}

    Outstanding Invoices: {{2.invoices}}

    Write a friendly, plain-English summary in 3 short paragraphs: (1) how the week went financially, (2) any invoices that need attention, (3) one actionable suggestion based on the data. Keep it under 200 words.

    Replace {{1.rows}} and {{2.invoices}} by clicking inside those fields and selecting the matching output from your earlier modules using Make’s variable picker — click the variable icon and drill into your previous steps.

  4. Set the model to GPT-4o. In the Model dropdown, select gpt-4o. Leave all other settings at their defaults.

Phase 3: Send the Report to Your Inbox (10 minutes)

  1. Add an email module. Click + after the OpenAI step, search for Gmail (or Email if you use Outlook), and select Send an Email.

  2. Connect your email account. Follow the same OAuth popup process you used for Xero. Grant Make permission to send on your behalf.

  3. Fill in the email fields:

    • To: Your email address
    • Subject: Weekly Business Report – {{formatDate(now; "MMM D, YYYY")}}
    • Content: Click the variable picker and select the Content output from your OpenAI step. This drops the AI-generated summary directly into the email body.
  4. Set your schedule. Click the Clock icon in the bottom left of the scenario canvas. Set the schedule to Every week, on Monday, at 7:00 AM in your local timezone. Click OK.

  5. Save your scenario. Click the floppy disk icon (or press Ctrl+S). Then flip the toggle at the bottom of the screen from OFF to ON to activate it.


Testing It Works

  1. Run a manual test. Before waiting until Monday, click the Run once button (the triangle play button at the bottom of the canvas). Watch each module light up green as it executes.

  2. Check your inbox. Within 2–3 minutes, you should receive an email with your AI-generated summary. Open it and confirm it includes real numbers from your Xero account and reads like a coherent summary, not garbled data.

  3. Verify the data looks right. Cross-check one number from the email — say, total income — against what you see if you log into Xero and run the same P&L report manually. They should match.


Troubleshooting

The Xero module returns empty data. This usually means the date formula isn’t formatted correctly for your Xero region. Go back to the Search Records module and double-check the From Date and To Date fields. Make sure you’ve used semicolons (;) inside the formatDate function, not commas — Make uses semicolons as separators.

The OpenAI module shows an error about “insufficient quota.” Your OpenAI account needs a small credit balance to use the API. Go to platform.openai.com, click Billing, and add $5–10 of credit. API usage for this report costs a few cents per run, so that will last months.

The email arrives but the AI summary looks generic or makes up numbers. The variables from your Xero modules didn’t map correctly into the OpenAI prompt. Go back to Step 9, delete the placeholder text in the Content field, and re-insert the variables using Make’s blue variable picker dots rather than typing them manually.


Next Steps

Once your weekly report is running smoothly, add a Slack notification as a second branch after the OpenAI step. Use Make’s Slack module to post the same AI summary to a private channel — so the report shows up wherever you actually start your Monday, not just in an inbox you might not check until afternoon. This takes about 10 extra minutes to set up using the same steps you already know.