Skip to content

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

  1. Go to the Google Developers Console

  2. Select your project or create a new one (and then select it)

  3. 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

  1. Open the Google Project you created above

  2. In the sidebar on the left, select APIs & Services > Credentials

  3. Click blue "+ CREATE CREDENITALS" and select "Service account" option

  4. Enter name, description, click "CREATE"

  5. You can skip permissions, click "CONTINUE"

  6. Click "+ CREATE KEY" button

  7. Select the "JSON" key type option

  8. Click "Create" button

  9. Your JSON key file is generated and downloaded to your machine (it is the only copy!)

  10. Click "DONE"

  11. Note your service account's email address (also available in the JSON key file)

Share your Google Sheet with the Google Service Account

  1. Open your Google Sheet

  2. Share the sheet with the service account’s email address from above

  3. 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).

Attention: Google Sheets API Usage Limits

Botium is using the Google Sheets API for reading the Google Sheet. If there are usage limits (quotas) in place, you can check them as described here