A weekly report on your channels — by email

How it works

To pass leads from Azure Cosmos DB to SendGrid automatically, use a ready-made scenario — no manual copying, no lost leads.

1. Starts when: Schedule Trigger
2. Then: Get skool members
3. Then: Markdown
4. Then: Extract Skool member count
5. Check: Merge
6. Then: combine the data
7. Then: Map out all 3 counts for each social platform
8. Then: Search records
9. Then: Update record
10. Then: Get channel stats
11. Then: Format youtube sub count
12. Then: Get tiktok followers
13. Then: extract current tiktok followers
14. Then: Get Video Data
15. Then: Get Transcripts
16. Then: Format youtube video stats
17. Check: Merge1
18. Then: Aggregate1
19. Then: add up metrics
20. Then: current metrics
21. Then: last weeks lable
22. Then: Search records2
23. Then: Edit Fields4
24. Then: calculate metrics
25. Then: Create a record
26. Then: last weeks lable1
27. Then: Search records1
28. Then: Generate analysis report
29. Then: Send html style report to your email
30. Then: Get last weeks vids
31. Then: Get tiktok data
32. Then: Format Channel stats
33. Check: last 7 days?
34. If yes: Merge2
35. Then: combine items
36. Then: Extract follower count for tiktok
37. Then: OpenRouter Chat Model
38. Starts when: Schedule Trigger1
39. Then: Get skool members2
40. Then: Markdown1
41. Then: Extract member count1
42. Then: Get channel stats1
43. Then: Get week lable

You can launch this Azure Cosmos DB + SendGrid integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.