Google Sheets is an online spreadsheet that allows you to create and format spreadsheets. It facilitates multiple users to work on the same spreadsheets simultaneously. It allows you to manage spreadsheets, manage worksheets, read, write, update, and clear data from worksheets. The API also allows you to perform column-wise, row-wise, and cell-wise operations.

The Google Sheets Ballerina connector exposes the Google Sheets API v4 through Ballerina. The connector makes it convenient to implement some of the most common use cases of Google Spreadsheets. With this connector, you can programmatically manage spreadsheets, manage worksheets, perform CRUD operations on worksheets, and perform column-level, row-level, and cell-level operations.

The Google Sheets Ballerina listener allows you to listen to Google Sheets events. It listens to events triggered when a spreadsheet is edited. For example, when a row is appended, when a row is updated, etc.

For more information, go to the module(s).

• googleapis.sheets
• googleapis.sheets.'listener

1. Download and install Java SE Development Kit (JDK) version 11. You can install either OpenJDK or Oracle.

   Note: Set the JAVA_HOME environment variable to the path name of the directory into which you installed JDK.

2. Download and install Ballerina Swan Lake Beta3.

Execute the commands below to build from the source.

• To build the package:

  bal pack

• To test the package:

  bal test

As an open source project, Ballerina welcomes contributions from the community.

For more information, go to the contribution guidelines.

All the contributors are encouraged to read the Ballerina Code of Conduct.

• Discuss the code changes of the Ballerina project in [email protected].
• Chat live with us via our Slack channel.
• Post all technical questions on Stack Overflow with the #ballerina tag.