Google Sheet Integration

Google Sheet Integration

The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source.  Integrating this data makes it available for the following purposes:

  1.  Enabling the remote verification of connections required by some results-based financing programs.
    1.  To learn more about submitting connections and using remote verification, please refer to the Odyssey user guide.
  2. Enable analytics and visualizations of the data via Odyssey’s Analytics platform; providing insights into the operations across your mini-grid sites or solar home system installations; and joined with other data on the Odyssey platform.
  3. Sharing operating data with other users of the Odyssey platform, such as investors or financing program administrators.
    1. When you share, what you share, and who you share with, is entirely up to you and controllable via the Odyssey Project Sharing User Interface. 

Google sheet Integration

Integration Set-Up

  1. Obtain your Google sheet ID from your CRM provider
  2. Set up and schedule your integration in the Odyssey Platform. To do this;

      • Navigate to Operate > Data Integrations

      • On the API Data Integrations tab

      • Click the Create button Enter the following details:

      1. Dataset Name: The name of your project “01_2024_Site Name”

      2. The Data Provider: Odyssey

      3. Data Source: Google Spreadsheet

      4. Dataset Type: Electricity Payments

      5. Target: Select the most appropriate for you depending on the requirements of the financing program. If unsure, reach out to the support team for clarification

        If you are integrating your mini-grid data, select the Project-level option. If you are integrating distributed assets (i.e. SHS) select the Program-level option. 

      6. Authentication: Input the Google sheet ID obtained from your CRM provider

      7. Once set up, the integration will run daily

Field Name
Description
Notes
TIMESTAMP
Datetime for the reading

Required
Format: YYYY-MM-DD HH24:MI:SS+00:00
Assumes UTC, use the timezone specification to adjust.
ID
Unique ID for the payment
Required
METER_ID
Unique ID for the meter
Required – For remote verification, this must match the external_id value entered in the connections section of the project. Learn more about verification here: https://help.odysseyenergysolutions.com/portal/en/kb/articles/submit-remote-verifie#Complete_Remote_Verification
UTILITY_ID
Unique serial number of the Inverter system
CUSTOMER_ID
Unique for the customer
Required
CUSTOMER NAME
Name of payer
Required
TRANSACTION CHARGES
 
PAYMENT_SOURCE
 
 
REFERENCE_ID
Payment reference ID
PAYMENT_AMOUNT
 
Required
ACCOUNT_TYPE
 
 
STATUS
 
 
NOTES


LOCATION


    • Related Articles

    • Mojec Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...

    • Chanels Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...

    • Angaza Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...

    • SteamaCo Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...

    • SparkMeter Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...