Self Hosted

Self hosting your own Google integration for use within your Ecosuite Org

Some of Ecosuite's services require a Google integration to hook into your own Google cloud infrastructure.

What you'll need is to provide a functioning service account. You will then go into your organization preferences and update the Google integration section with your service account private key (an RSA private key), as well as the generated service account client email.

1. Follow the provided Google Cloud documentation to create your service account.

The gist of it is:

• Click IAM & Admin

• On the left pane, click Service Accounts

• Click Create service account

• Create the account and you'll get an email for that service account (e.g [email protected])

• Click on the email from the menu, then head to the KEYS tab, create a new key: ADD KEY --> Create new key (choose JSON).

The private key should look something like this:

-----BEGIN RSA PRIVATE KEY-----
MIIBOgIBAAJBAKj34GkxFhD90vcNLYLInFEX6Ppy1tPf9Cnzj4p4WGeKLs1Pt8Qu
KUpRKfFLfRYC9AIKjbJTWit+CqvjWYzvQwECAwEAAQJAIJLixBy2qpFoS4DSmoEm
o3qGy0t6z09AIJtH+5OeRV1be+N4cDYJKffGzDa88vQENZiRm0GRq6a+HPGQMd2k
TQIhAKMSvzIBnni7ot/OSie2TmJLY4SwTQAevXysE2RbFDYdAiEBCUEaRQnMnbp7
9mxDXDf6AU0cN/RPBjb9qSHDcWZHGzUCIG2Es59z8ugGrDY+pxLQnwfotadxd+Uy
v/Ow5T0q5gIJAiEAyS4RaI9YG8EWx/2w0T67ZUVAw8eOMB6BIUg0Xcu+3okCIBOs
/5OiPgoTdSy7bcF9IGpSE8ZgGKzgYQVZeN97YE00
-----END RSA PRIVATE KEY-----

You will want to make sure that you use the newline escape where there are
newlines. For example:

-----BEGIN RSA PRIVATE KEY-----\nMIIBOgIBAAJBAKj34GkxFhD90vcNLYLInFEX6Ppy1tPf9Cnzj4p4WGeKLs1Pt8Qu\nKUpRKfFLfRYC9AIKjbJTWit+CqvjWYzvQwECAwEAAQJAIJLixBy2qpFoS4DSmoEm\no3qGy0t6z09AIJtH+5OeRV1be+N4cDYJKffGzDa88vQENZiRm0GRq6a+HPGQMd2k\nTQIhAKMSvzIBnni7ot/OSie2TmJLY4SwTQAevXysE2RbFDYdAiEBCUEaRQnMnbp7\n9mxDXDf6AU0cN/RPBjb9qSHDcWZHGzUCIG2Es59z8ugGrDY+pxLQnwfotadxd+Uy\nv/Ow5T0q5gIJAiEAyS4RaI9YG8EWx/2w0T67ZUVAw8eOMB6BIUg0Xcu+3okCIBOs\n/5OiPgoTdSy7bcF9IGpSE8ZgGKzgYQVZeN97YE00\n-----END RSA PRIVATE KEY-----

• Go to APIs and Services and click on Library. Enable the Google Sheets API and Google Docs API.

Using templates

Many of our google integrations use templates when importing/exporting data.

To provide your own template, you must provide the id of the document you wish to use.

An example spreadsheet using Google Sheets.

You can find the ID following the /d/ inside the URL.

After you have created a template, the only thing you will have to do is to make sure that you share the document with your service account email address to make sure that it has permissions to access it.