Can I use Google Sheets to manage my test cases ?
Scenario: you are using Google Sheets for writing Botium test cases (same format as in Excel).
Solution: register your Google Sheet in Botium Box as “Download Link”.
Create Google Project and Enable the Sheets API
Go to the Google Developers Console
Select your project or create a new one (and then select it)
Enable the Sheets API for your project
In the sidebar on the left, select APIs & Services > Library
Search for "sheets"
Click on "Google Sheets API"
Click the blue "Enable" button
Create Google Service Account
Open the Google Project you created above
In the sidebar on the left, select APIs & Services > Credentials
Click blue "+ CREATE CREDENITALS" and select "Service account" option
Enter name, description, click "CREATE"
You can skip permissions, click "CONTINUE"
Click "+ CREATE KEY" button
Select the "JSON" key type option
Click "Create" button
Your JSON key file is generated and downloaded to your machine (it is the only copy!)
Click "DONE"
Note your service account's email address (also available in the JSON key file)
Share your Google Sheet with the Google Service Account
Open your Google Sheet
Share the sheet with the service account’s email address from above
Note the sharing link
Register Download Link in Botium Box
Use the Google Sheet sharing link as download link
Post the content of the service account JSON file in the form
Click on Save and check the configuration by clicking the Download button - it will download the Google Sheet as Excel file (without any formatting applied, as they don’t matter for Botium test cases anyway).