Introduce workflow to automate GitHub Projects

[justinretzolk]

Community Note

• Please vote on this pull request by adding a 👍 reaction to the original pull request comment to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for pull request followers and do not help prioritize the request
• The resources and data sources in this provider are generated from the CloudFormation schema, so they can only support the actions that the underlying schema supports. For this reason submitted bugs should be limited to defects in the generation and runtime code of the provider. Customizing behavior of the resource, or noting a gap in behavior are not valid bugs and should be submitted as enhancements to AWS via the CloudFormation Open Coverage Roadmap.

About

Introduces a workflow to handle various tasks related to automating the team's GitHub Project. The sole job works on the AWS Provider team's GitHub Project, but the workflow is intentionally constructed so that we can easily add other projects within separate jobs (hence the use of env at the top level and within the team_board job).

Similar to #1773, this will require the following secrets in the repository:

Slack related:

• SLACK_BOT_TOKEN
• SLACK_CHANNEL

Depends on #1743 Relates #1742 Relates #1773