[chore]: add a workflow to add new issues to the project automatically

### What would you like?

When a new issue is created, it is automatically added to the project [#346](https://github.com/orgs/aws/projects/346)

### Possible Implementation

We can't use the projects field in the issue template because that would require the author to have the write permission to the project

### Is this a breaking change?

No

### Does this require an RFC?

No

### Additional Context

_No response_