[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_

Start by checking the repository's GitHub Actions workflow configuration and the linked project #346. Add automation so each newly created issue is added to that project, then verify the workflow with a newly opened issue and confirm it appears in the project.

Written by the indexing model from the issue text.