Integrate GitHub Actions for Improved Project Management

[khrystianc]

I propose integrating more GitHub Actions into the Agorakube project to automate various project management tasks. This could include automating workflows such as:

• Running tests whenever a pull request is opened or updated.
• Creating new issues or projects from a template when specific conditions are met.

Currently, I see that automation actions are used mainly for marking stale requests and attempting to label issues based on their content.

Describe the solution you'd like
To make the project management process more efficient and consistent, and it could also help catch issues earlier by automating tests.

Describe alternatives you've considered
Continue mostly manual management or having issues sit until they become stale.

Additional context
Links to solution resources: https://docs.github.com/en/actions/managing-issues-and-pull-requests/using-github-actions-for-project-management.