Sign Up for Free

RunKit +

Try any Node.js package right in your browser

This is a playground to test code. It runs a full Node.js environment and already has all of npm’s 400,000 packages pre-installed, including testx-google-spreadsheet-runner with all npm packages installed. Try it out:

require("testx/package.json"); // testx is a peer dependency. var testxGoogleSpreadsheetRunner = require("testx-google-spreadsheet-runner")

This service is provided by RunKit and is not affiliated with npm, Inc or the package authors.

testx-google-spreadsheet-runner v1.1.0

Google Spreadsheet runner for Testx

testx-google-spreadsheet-runner

Google Spreadsheet Runner for TestX

Requirements

Installation

npm i testx-google-spreadsheet-runner --save

How to use

First of all, you need to know how to create and run a TestX test project. If you don't know how, check out the the TestX documentation.

To use test scripts from a Google spreadsheet, import the runner:

runner = require 'testx-google-spreadsheet-runner'

Then, create a normal Jasmine test and pass the id of the spreadsheet to the runner:

describe 'Google search', ->
  it 'should display relevant results', ->
    runner.runGoogleSpreadsheet '1xLNhRCq3BuOA2Ve7C8xRcM7VpmeCgKv4Bkyhd494T7I'

or to run only one specific sheet:

describe 'Google search', ->
  it 'should display relevant results', ->
    runner.runGoogleSpreadsheet '1xLNhRCq3BuOA2Ve7C8xRcM7VpmeCgKv4Bkyhd494T7I', 'Sheet2'

The following spreadsheet is used in both examples: https://docs.google.com/spreadsheets/d/1xLNhRCq3BuOA2Ve7C8xRcM7VpmeCgKv4Bkyhd494T7I.

Caveat

Currently the runner only supports public spreadsheets as authentication is not yet implemented. Make sure your spreadsheets are public by publishing them to the web (File -> Publish to web).

RunKit is a free, in-browser JavaScript dev environment for prototyping Node.js code, with every npm package installed. Sign up to share your code.
Sign Up for Free