TLDR: Automate #3324

cc @bernays

We can use the same approach as our Helm Charts:
https://github.com/cloudquery/helm-charts/blob/8b1b9b5ece94a92e1ac329594645a4b3318a9c4d/.github/workflows/deps_bump_versions.yml#L10

The linked workflow adds a comment to the PR that triggers another workflow that updates the docs.

That way we keep renovate in charge of handling updates (for example it can rebase PRs with conflicts, auto merge non breaking updates, etc.), but ensure the CI works for those API updates PRs