Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

There is two sides of the setup, one in iHub Cloud and one in Google Console

Google Console

...

Goto Google Console

...

Create a project

...

Reference create a service account https://cloud.google.com/iam/docs/service-accounts-create

  1. Create and Goto Google Console

  2. Create a project

  3. Goto API & Services

  4. Click Credentials

  5. Click Create Credentials

  6. Create a Service Account

  7. Click on the Service User

  8. Click Keys, create new

  9. Download the Private Key as JSON

  10. Enable the API that you want to access. example Google Sheets

  11. For Google Docs, Sheets, Presentation etc share the resource with the service account to grant access

...

Now when ever you create an issue it will trigger the integration, which will create the JWT token and exchange it to a access token. The access token is then used in the child action to perform the append of a row with issue data.

References

https://developers.google.com/identity/protocols/oauth2/service-account#httprest

https://cloud.google.com/endpoints/docs/openapi/troubleshoot-jwt

https://developers.google.com/sheets/api/guides/concepts

https://nishothan-17.medium.com/google-sheet-apis-using-google-cloud-platform-gcp-credentials-8bca55521af