Hey @karan_trivedi248
You can try tweak the message query like below:
This will generate a text string like:
You can send this generated string via email using a weekly scheduled api workflow.
Let me know if this works for you.
Thanks