Go to https://developers.google.com/sheets/api/quickstart/java

Go to Step 1: Turn on the Google Sheets API and click the Enable the Google Sheets API button

Enter StreamLineQA Automation for the project name and continue with the setup

After you click next, you'll be asked to configure your oauth client. Select Desktop app from the dropdown and click CREATE

Download the credentials.json file and store it in the Credentials folder

Click the API Console link to open your new project

Click the + ENABLE APIS AND SERVICES link and enable the Google Drive API

Find skeletons for all of the files you need here. https://drive.google.com/drive/folders/1OJdg4N7svzxXFPqLRlYr4qLLE3Ddu9Ii?usp=sharing

For the StreamLine Web and App Automators, you'll need to create a new sheet in the config file named Google Sheets Setup

In cell B1, specify whether or not you want to use google sheets (yes or no)

In cell B2, enter the id of the test folder, the folder where all of your google sheets tests are stored. You can find the id of the folder in the url

In cell B3, enter the id of the output folder. After every run, we'll convert your output excel file to a google sheet and store it in this folder

In cell B4, enter the id of the data file. The id can be found in the url

If you have data driven tests (redirects, screenshots, logins, searches, or forms), enter the id's of the data files in column H.