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 NAMEDESCRIPTIONNOTES
IDUnique ID for the payment
TIMESTAMPDate and time for the readingRequired

Time of payment in UTC timezone using ISO 8601 format
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
PAYMENT_AMOUNTAmount paidRequired
PAYMENT_CURRENCYThe currency of the transactionRequired
TRANSACTION_TYPEPossible values: FULL_PAYMENT, INSTALLMENT_PAYMENT, NON_CONTRACT_PAYMENT, DISCOUNT, REVERSAL, ENERGY_CREDITRequired
TRANSACTION_CHARGESCharges associated with the transactionNot Required
REFERENCE_IDPayment reference IDNot Required
CUSTOMER_IDThe customer ID of the user of the device (SHS device or mini-grid meter). This may be required by the financing organization in order to verify the sale.Required
METER_ID
This is the serial number of the stand alone solar system
The system serial number will serve as the primary identifier in this program.

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
Required
CUSTOMER_NAMEName of the customerRequired
CUSTOMER_PHONEPhone number of the user of the deviceNot Required

Example : +234xxxxxx
CUSTOMER_CATEGORYCategory of the customer who uses the property applicable Required Description device. Dependent on the provider.
Example values are Public, Prepaid, Residential, Commercial, Business, etc.
FINANCING_IDID specific to the financing provider or program.Not Requiried
AGENT_IDThe agent facilitating the transaction, such as a sales person's nameNot Requiried
LATITUDELatitude of the location of the deviceNot Requiried
LONGITUDELongitude of the location of the deviceNot Requiried
UTILITY_IDA unique ID for utilityNot Requiried
FAILED_BATTERY_CAPACITY_COUNTThis field will track the number of instances where batteries fail to reach their capacity limit, a crucial metric for understanding payment and operational efficiency.Not Requiried
ACCOUNT_TYPEThis is the customer typeNot Requiried
STATUSNot Requiried
NOTESAny other notes you want to addNot Requiried

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