How to Build the Weekly Report with AI: Step by Step

Friday, 2pm. Daniel, your head of sales, is already thinking about the weekend. The weekly report to the management team is due at 3pm, and the numbers still have to come out of HubSpot, two Excel workbooks and a lexoffice export, before anyone can even write a sentence of commentary. A weekly report with AI closes that gap: an AI employee pulls the numbers from the systems where they live, drafts the write-up around them, and asks you to approve before anything is sent. This guide shows, step by step, how to build the weekly report with Superkind in Outlook, Teams or Slack, how to turn it into a Friday routine, and how to keep it fast when the business grows.

What is a weekly report with AI?

A weekly report with AI is the standing Friday report drafted by an AI employee that pulls the numbers from the operational systems where they live, applies your KPI definitions, writes the summary, and asks you to approve before it is sent. The report itself has not changed - pipeline, revenue, hours, open items, highlights, risks - what changes is who does the gathering and the first draft. Instead of a team lead copying between HubSpot, two Excel workbooks and a lexoffice export at 2pm every Friday, the AI employee does that part and hands over a draft that is ready to review.

What you need

A short list of prerequisites. If this is already in place, the first weekly report with Superkind takes about 15 minutes to set up.

Step by step with Superkind

Superkind is the AI employee you write to in Outlook, Microsoft Teams, Slack or the Superkind web app, like a colleague. It is hosted and processed in Europe, GDPR compliant, with 1,500+ integrations into HubSpot, Microsoft Excel, Google Sheets, DATEV, SharePoint, Salesforce, lexoffice, Personio and Zendesk, and it asks you to approve before anything is sent. Here is the weekly report in six steps, from the first task to the Friday routine.

1. 1

   Connect the systems you need

   In the Superkind app, connect HubSpot (or Salesforce) for pipeline, Microsoft Excel or Google Sheets for the team workbooks, and DATEV or lexoffice for revenue. Each one is one OAuth click; Superkind takes only the permissions it needs. Add SharePoint if the finished report has to land in a folder.

2. 2

   Write Superkind the task in plain words

   In Teams, Slack or Outlook, describe what the report has to contain. No template to pick, no filter wizard. The first sentence is the format you want (“a one-page summary for sales management”), the next sentences are the numbers it should pull.

3. 3

   Superkind gathers and drafts

   It pulls the figures from HubSpot, Excel, Google Sheets and DATEV through its 1,500+ integrations, applies your KPI definitions (your “weighted pipeline”, your “closed won”), writes the number plus a short commentary (“pipeline is up 12% on last week, driven by three new deals above EUR 50,000”), and prepares the email, Teams message or Slack post to Daniel.

4. 4

   You approve or correct

   Superkind shows the draft and asks for sign-off before anything goes out. You tweak a sentence, correct a number, approve, and the report is sent. Every correction is stored in your Company Brain so Superkind applies it next Friday without being asked.

5. 5

   The report lands with the recipient

   Daniel gets the finished report in his inbox or Teams channel at the time you set. If he has a question, he asks Superkind directly in the same thread (“which three deals drove the 12% jump?”) - no new tool, no new login.

6. 6

   Save it as a Friday routine

   “Every Friday at 3pm, build the weekly report for the sales team and send it to Daniel.” Superkind runs it on schedule, drafts, asks for your approval, sends. If you are on holiday, your colleague takes over the approval in Teams or Slack.

Set it up as a Friday routine

A one-off report is useful. A routine is what changes the Friday afternoon. The pattern is the same every week: ask once, approve, done. The routine itself is a sentence in Teams or Slack.

• Schedule and fallback - the routine runs on a time (Friday 2pm) and knows who to ask for approval if the main approver is out. No week is missed because the team lead is on holiday.
• KPI definitions carry over - the way you defined “closed won” last week is still what Superkind uses this week. If the definition changes, you tell it once in the thread and it updates the routine.
• Highlights and risks - after a few runs, Superkind picks up what counts as a highlight for your team (a deal above a threshold, a drop in utilisation) and surfaces them without being asked.
• One-off questions, same channel - mid-week, you can ask “draft the weekly report now with Monday-to-Thursday data” and Superkind runs it ad hoc without touching the routine. See ad-hoc reporting for the one-off side.
• The report evolves - when Daniel asks for a new metric (“add revenue per sales rep”), you say it once and the routine includes it from the next Friday on.

Data protection and EU hosting

The weekly report touches customer names, deal amounts, employee hours and project margins. For a German or EU team this is where many setups stall: nobody wants the Friday report to end up on a US server without a signed DPA. The practical standard is a data processing agreement under Art. 28 GDPR, a lawful basis under Art. 6, a record of processing under Art. 30, and AI literacy training under Art. 4 of the EU AI Act (Regulation (EU) 2024/1689)⁵⁶.

Safe by default

Your data stays in Europe, under a DPA, with no training on your data.

• Hosted and processed in Europe
• GDPR compliant
• Aligned with the EU AI Act
• No training on your data
• DPA through the Trust Center

For a weekly report that lists top deals by customer, utilisation by employee or margin by project, this means the names stay in the EU, the model does not learn them, and the DPA covers the whole chain from Outlook through HubSpot to DATEV. The AI models themselves (OpenAI, Anthropic, Mistral, Google) are processed in Europe.

Other ways to build the weekly report

A weekly report can be built in several ways. Honest trade-offs, no fake weaknesses.

The honest line: a dashboard answers “what are the numbers?”, Superkind answers “what is the weekly report, and send it”. The two sit side by side. For the one-off version of the same question, see ad-hoc reporting; for the tools that build the dashboards, see the 10 best AI tools for ad-hoc reports in 2026.

5 common mistakes

• Writing the task like a dashboard spec - a wall of fields and filters never produces a readable report. Write it like you would to a colleague: “a one-page summary of the week in sales”, then say which numbers.
• Skipping the KPI definitions - without “this is what we call weighted pipeline”, Superkind picks a sensible default and you spend Friday correcting it. Define the three or four KPIs once, in plain words, and the problem is gone.
• No fallback approver - the team lead is on holiday, nobody approves, the report misses Friday. One line in the routine (“ask Nadine instead”) prevents it.
• Letting the report grow forever - every quarter someone asks for another metric and the Friday report becomes unreadable. Review once a quarter: what did Daniel actually read, what gets cut.
• Treating the first draft as final - the first run of a routine is never the keeper. Expect to correct two or three sentences for the first few Fridays; after that the routine is tight.

6 tips that keep the report useful

1. Lead with the three sentences the recipient will read

Daniel reads the first paragraph, scans the numbers, and goes to his next meeting. Make the first three sentences the ones that matter: the headline number, the direction vs. last week, the one risk. Superkind can do this if you ask for it in the task.

2. Keep the number of KPIs below seven

A weekly report with twelve numbers is a worksheet, not a report. Pick the five to seven that drive the decision for next week. Everything else lives in the dashboard or the ad-hoc report.

3. Say what “closed won” means in your Company Brain

The hardest sentences in any report are the ones where the definition is implicit. Write it down once (“closed won = status Closed Won in HubSpot with a signed contract in DocuSign”), store it in your Company Brain, and the number is the same every week.

4. Train your team on AI literacy under Art. 4 of the EU AI Act

A short session on how Superkind handles data, where the processing happens (EU), and how approval works. Art. 4 of the EU AI Act requires this for anyone using an AI system at work from 2 February 2025. One hour is enough for a weekly-report routine.

5. Attach the raw data when it helps

Daniel sometimes wants to see the deal list behind the number. Ask Superkind to attach the HubSpot or Excel file to the Friday email, or to drop it in SharePoint and link to it. No separate export step.

6. Review the routine once a quarter

Set a 15-minute slot every quarter: did Daniel act on the report, which metrics did he quote in meetings, which ones never came up. Cut what nobody reads, add what came up ad hoc more than twice. The routine stays sharp.

From the first task to your own app

With Superkind, the data stays in Europe from the first weekly report to your own reporting app. Four stages, on the weekly report.

1. 1

   Ready in minutes

   Sign up free, ask Superkind in Teams to draft this Friday’s report from HubSpot and the Excel sheet, and watch it come back by 3pm.

2. 2

   Tasks become routines

   “Every Friday at 3pm, build the weekly report and send it to Daniel.” Superkind runs it on schedule, drafts, asks for your approval, sends. You explain the format once, it keeps running.

3. 3

   Learns from day one

   Every correction adds to your Company Brain: your KPI definitions, the way you phrase highlights, the people who need to see each section. This knowledge is never lost, even when a team lead leaves.

4. 4

   Your own reporting app, without starting over

   When it gets more complex (one weekly report per team, with a monthly roll-up, cross-linked to the project dashboard), build custom solutions and your own app on the Superkind platform with 1,500+ integrations: your Super App. Built yourself or with us. It all belongs to you.

Conclusion

The weekly report is a Friday ritual that nobody wants to do and that everybody needs. Superkind handles the slow half (gathering from HubSpot, Excel, Google Sheets, DATEV, SharePoint through 1,500+ integrations) and the first-draft half (write-up with your KPI definitions), and asks you to approve before it reaches Daniel. Set the routine once in Teams or Slack, review it quarterly, and the Friday afternoon stops being a scramble. Start with this Friday’s report as the first task, free, and let the next weeks run as the routine. See project reporting for the solution page, and summarise Teams meetings for the related meeting side.

Frequently asked questions

Henri Jung

Co-founder of Superkind, the AI employee teams write to in Outlook, Teams and Slack. Henri helps companies, from small teams to the Mittelstand, hand their routine work to AI - without new tools, consultants or an in-house AI team.