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
EXAMPLE
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'
 2021-05-16T14:16:01
PAYMENT_AMOUNTAmount paidRequired
5000
PAYMENT_CURRENCYThe currency of the transactionRequired
Naira
TRANSACTION_TYPEPossible values: FULL_PAYMENT, INSTALLMENT_PAYMENT, NON_CONTRACT_PAYMENT, DISCOUNT, REVERSAL, ENERGY_CREDITRequired
INSTALLMENT_PAYMENT
TRANSACTION_CHARGESCharges associated with the transactionNot Required
1000
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
45987
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
45987
CUSTOMER_NAMEName of the customerRequired
John Does
CUSTOMER_PHONEPhone number of the user of the deviceNot Required

Example : +234xxxxxx
+2344567890
CUSTOMER_CATEGORYCategory of the customer who uses the property applicable Required Description device. Dependent on the provider.

Public, Prepaid, Residential, COmmercial, Business, etc
FINANCING_IDID specific to the financing provider or program.Not Requiried
FIN-ASSET-4567
AGENT_IDThe agent facilitating the transaction, such as a sales person's nameNot Requiried
Name of the Agent/company
LATITUDELatitude of the location of the deviceNot Requiried
1.3,30.14
LONGITUDELongitude of the location of the deviceNot Requiried
1.3,30.14
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
Credit, debt, Public, Prepaid, Customer, Business, etc.
STATUSPayment statusNot Requiried
Assigned, processed, reversed, pending, error, MANUAL, etc.
NOTESAny other notes you want to addNot Requiried
This is a payment

Field Name

Description

Notes

Example

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

A200004567

Customer ID

Unique ID for the customer

Required

FN99998

CUSTOMER_NAME

Name of the customer who uses the meter.

Required

John Doe

FREQUENCY

Frequency of the AC power received by the meter

Not Required



METER_ENERGY_READING_KWH

Total cumulative energy consumption recorded at the reading interval

Not Required

20.456


METER_ENERGY_CONSUMPTION_KWH

Total energy consumption recorded over the reading interval

Required

0.004

METER_ENERGY_CONSUMPTION_COST

Total energy consumption cost recorded over the reading interval

Not Required

4.316

VOLTAGE_MIN


Minimum voltage recorded over the reading interval

Not Required

220.07

VOLTAGE_AVG


Average voltage recorded over the reading interval

Not Required

221.14

VOLTAGE_MAX


Maximum voltage recorded over the reading interval

Not Required

223.43

CURRENT_MAX

Maximum current recorded over the reading interval

Not Required

0.054

CURRENT_MIN

Minimum current recorded over the reading interval

Not Required

0.052

CURRENT_MAX

Maximum current recorded over the reading interval

Not Required

0.054

CURRENT_AVG

Average current recorded over the reading interval

Not Required

0.052

TRUE_POWER_AVG

Average true power over the reading interval

Not Required

10

APPARENT_POWER_AVG

Average power recorded over the reading interval

Not Required

10

POWER_FACTOR

Average power factor recorded over the reading interval

Not Required

0.993

METER_STATE

State of the meter at the time of this reading

Not Required

On or Off

COMMS_UPTIME

Communication uptime

Not Required

100

POWER_LIMIT

Meter power limit

Not Required

3

CREDIT DEBT

Customer balance debt

Not Required

2000

ADDRESS_FULL

Customer full address

Not Required

Full address

LOCATION

Location of the Meter

Not Required


METER_TAGS

Meter tags

Not Required

Pole99, R, Y


    • Related Articles

    • FAQ: I have new data. How do I use it to verify my connections Immediately?

      If you have an Amazon S3 integration or an Excel File integration created on Odyssey, and you would like to immediately use that data to verify your connections. Please follow these steps; 1. Amazon S3 Integration To run your verification: 1. ...

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

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