Obtain Access Tokens by following this link https://central.ballerina.io/wso2/gmail

Configure endpoint parameters with your tokens

Create a google spreadsheet similar to the one attached (refer Students Marks.xlsx)

Obtain the spreadsheet id by extracting the value between the "/d/" and the "/edit" in the URL of your spreadsheet

Replace sheetID and sheetName with yours as indicated in the code

The module can be run on terminal from the parent folder using the following command: ballerina run module

Unit tests can be done using the following command: ballerina test from the parent folder