generate reports / invoices monthly for client projects from clickup timelogs

[johnsBeharry]

Requirements

• we need a node script which can fetch data from our clickup workspace and persist it to a database (postgres, or disk)
• we want to eventually interact with the data via an api
• we want notifications for when the time tracked on a project reaches some amount of hours

Tasks & Time Logs

• we track our time in clickup, these times are entries on tasks
• tasks can last longer than a month
• tasks have a last update field
• filter tasks by last updated (inputed month)
• this can be used to check if time was logged (assumption)
• time-log entries are an array on clickup tasks
• so we need to filter a tasks time log entries by the inputed month

Deployment

• Consider deploying Cloudflare Workers, or Netlify Functions