# weekly report

**URL:** <https://community.hubspot.com/t/weekly-report/108275>\
**Category:** Reporting & Analytics\
**Tags:** starter\
**Created:** [May 30, 2024, 7:53am UTC](https://community.hubspot.com/t/weekly-report/108275 "2024-05-30T07:53:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![EnrickDeMunter](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@EnrickDeMunter](https://community.hubspot.com/u/EnrickDeMunter)\
**Post date:** [May 30, 2024, 7:53am UTC](https://community.hubspot.com/t/weekly-report/108275/1 "2024-05-30T07:53:58Z")

</div>

Hello,

I want to create a weekly report about last weeks meetings, but i want to include the note’s. The problem is that i get duplicates because of the notes is it possible to set them together so that each deal has got all the notes of that deal.

If i export the excel straight from the deal dashboard the notes merged in each deal. that is the way i want it.

---

<div class="post-metadata">

**Author:** ![HFisher7](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hfisher7/32/101931_2.png) [@HFisher7](https://community.hubspot.com/u/HFisher7)\
**Post date:** [May 30, 2024, 9:29am UTC](https://community.hubspot.com/t/weekly-report/108275/2 "2024-05-30T09:29:56Z")

</div>

Hey @EnrickDeMunter, this would be possible using a pivot report type via a custom report, but unfortunately that is a Pro+ feature!

---

<div class="post-metadata">

**Author:** ![EnrickDeMunter](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@EnrickDeMunter](https://community.hubspot.com/u/EnrickDeMunter)\
**Post date:** [May 30, 2024, 9:36am UTC](https://community.hubspot.com/t/weekly-report/108275/3 "2024-05-30T09:36:00Z")

</div>

would it be possible to make automatic exports out of the deals every week?

---

<div class="post-metadata">

**Author:** ![HFisher7](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hfisher7/32/101931_2.png) [@HFisher7](https://community.hubspot.com/u/HFisher7)\
**Post date:** [May 30, 2024, 9:40am UTC](https://community.hubspot.com/t/weekly-report/108275/4 "2024-05-30T09:40:42Z")

</div>

@EnrickDeMunter - Yes, you could set up an automatic emails ending out the Deal report each week - [instructions linked here](https://knowledge.hubspot.com/dashboard/email-or-export-reports-and-dashboards#manage-recurring-report-emails:~:text=Schedule%20email.-,Manage%20recurring%20report%20emails,-If%20you%27re%20a)

---

<div class="post-metadata">

**Author:** ![EnrickDeMunter](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@EnrickDeMunter](https://community.hubspot.com/u/EnrickDeMunter)\
**Post date:** [May 30, 2024, 9:43am UTC](https://community.hubspot.com/t/weekly-report/108275/5 "2024-05-30T09:43:00Z")

</div>

Sorry i didn’t explain properly, What i want is that in crm-\> deals you can export an excel. And i want that excel to be exported automatically every week. Is that possible?

---

<div class="post-metadata">

**Author:** ![SalmanLatif](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@SalmanLatif](https://community.hubspot.com/u/SalmanLatif)\
**Post date:** [June 3, 2024, 6:42am UTC](https://community.hubspot.com/t/weekly-report/108275/6 "2024-06-03T06:42:14Z")

</div>

Hey @EnrickDeMunter I fear that is not possible with HubSpot-only features. You may need to use third-party integrations like Zapier for the job.  
For instance, with Zapier you can:

Create a Zap that triggers a report export based on specific criteria (e.g., new deals created or updated within the last week). This Zap can then send the data to an Excel sheet in Google Sheets or Microsoft Excel Online.

If doing this manually, you will need to first:

1. Create a Custom Report: To do so, simply go to **Reports \> Reports** and click on **Create Custom Report**. Choose the **Single Object** or **Cross Object** report depending on your needs. Include the **Deals** object and add a filter to show deals created or updated in the last week. Add the **Notes** property to the report so that you can see the notes associated with each deal.
2. Click on the **Export** button. Choose the **Excel** format and schedule it to export weekly.

If you REALLY want to automate this, you will need to rely on HubSpot APIs + a Python script.  
Hope this helps!
