Ecosuite Docs
  • Ecosuite User Guide
  • Modules
    • Events
      • Creating a SolarNetwork reset event
      • Creating a Service Request
    • Energy
      • Download Datums
      • Asset Hierarchy
    • Economics
      • Economics Module FAQ
    • Data
      • Project
        • New Project Guide
        • Operating Reports
        • Status
          • Project and System Status and Project Flag filtering
        • Expected Energy Calculation Setup
        • Importing from Coda
      • Pro Forma
        • Importing Financial Models
      • Audit
      • Raw Data
    • Forge
  • Admin
    • User Management 101
    • Settings
      • Tariffs
  • Ecosuite Terminology
    • Forecasting
  • Ecosuite AI
    • Accessing raw data (e.g. for ML training)
  • Power Dashboard
  • 🏢Organizations
    • Google Integration
      • Getting Started
        • Self Hosted
        • Ecosuite Infrastructure
Powered by GitBook
On this page
  1. Organizations
  2. Google Integration
  3. Getting Started

Self Hosted

Self hosting your own Google integration

PreviousGetting StartedNextEcosuite Infrastructure

Last updated 1 year ago

Some of our services require a Google integration to hook into your own Google cloud infrastructure.

What you'll need is to provide a functioning . 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 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 xyz-abcd@username.iam.gserviceaccount.com)

  • 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.

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.

🏢
service account
provided Google Cloud documentation
An example spreadsheet using Google Sheets.