Read and Write to Google Spreadsheet using Java

This is a boilerplate project that can be used to read and write from a Google Spreadsheet!

Prerequisites

The foremost task, go to the following link and give it a read. https://developers.google.com/sheets/api/quickstart/java

Make sure you complete Step 1.
Download the credentials.json and keep it handy

Installing

git clone https://github.com/wizArD-1910/Connect-To-Google-Spread-Sheet-Using-Java.git
gradle build
Copy credentials.json to src/main/resources
gradle run
A browser window will open, accept and allow google for permissions after reading them
Output should be displayed

Reading

Go to ReadFromSheet.java
Change the spreadsheet id
Go to build.gradle
Change mainClassName = 'SheetsQuickstart' to mainClassName = 'ReadFromSheet'
gradle run

Writing

Go to WriteToSheet.java
Change the spreadsheet id
Go to build.gradle
Change mainClassName = 'SheetsQuickstart' to mainClassName = 'WriteToSheet'
gradle run

Important Information

After changing SCOPE or SpreadSheetId of your project, delete your tokens folder and rerun the application

Project Structure

|-src
    |-main
        |-java
            |-ReadFromSheet
            |-SheetsQuickstart
            |-WriteToSheet
        |-resources
            |-credential.json
|-build.gradle
|-settings.gradle
|-README.md

Ending Notes

The repository follows Conventional Commits and Gitmoji styling
The .idea folder contains files that will change project settings for better understanding of comments
For comments follow:
- //TODO: When you want users to complete some tasks
- //INFO: Add external Information
- //Bug: To suggests for bugs in code
- //URL: For adding URLs

License

sordgom/Google-Spreadsheet-Using-Java

ErrorLooks like something went wrong!

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages