A timesheet that fills itself

Every day the scenario gathers your meetings, emails and repository work, writes a short summary and adds a finished row to your tracking sheet.

  • Pulls meetings from Google Calendar, emails from SendGrid, work from GitHub
  • An assistant writes a short summary of the day
  • Adds a finished row to asproCloud every day
  • Honest hours without manual tracking
Set it up for yourselfScriptera

How it works

To move data from Google Calendar to SendGrid automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Daily at 7PM
  2. Then: Set Variables
  3. Then: Get Today's Emails
  4. Then: Aggregate
  5. Check: Merge
  6. Then: Format All Data
  7. Then: Generate Journal Summary
  8. Then: Split Out
  9. Then: Insert Sheets Entry
  10. Then: Get Today's Calendar Events
  11. Then: Aggregate1
  12. Then: Create Sheet If It Doesn't Exist
  13. Check: If it didn't exist
  14. If yes: Init Sheet Headers
  15. Then: init Sheet Columns
  16. Then: Split Out1
  17. Then: Get Commits From Github
  18. Check: If Authors Commit
  19. If yes: Aggregate3
  20. Then: Split Out2
  21. Then: Get GitHub PRs
  22. Check: If it's created today
  23. If yes: Aggregate2
  24. Check: If it's closed today

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

Similar scenarios