This Dexter module allows you to write 1-5 columns from your App into a Google Apps Spreadsheet. It uses the Edit Google Spreadsheet library under the hood.
| Parameter | Required | Multiple? | Details |
|---|---|---|---|
| start_row | No | No | Which row to start reading from (defaults to 2: assumes there's a header in 1) |
| start_col | No | No | Which column index to start at, (defaults to 1) |
| spreadsheet_id | Yes | No | The id of the spreadsheet to store the records to |
| col1_data | No | No | Data to write in the 1st column* |
| col2_data | No | No | Data to write in the 2nd column* |
| col3_data | No | No | Data to write in the 3rd column* |
| col4_data | No | No | Data to write in the 4th column* |
| col5_data | No | No | Data to write in the 5th column* |
* Only columns that have explicit bindings from the app editor will be written to the spreadsheet. Those columns will always overwrite the data that's there. Unassigned columns will NOT overwrite what's there.
Example 1
column 1 is bound to the string 'Hello', the rest are not bound.
The existing table looks like:
A B
C D
Writing to row 1 column 1 will result in:
Hello B
C D
Example 2
column 1 is bound to step('a').input('foo'), which returns 'Hello' column 2 is bound to step('b').input('bar'), which returns nothing.
The existing table looks like:
A B
C D
Writing to row 1 column 1 will result in:
Hello
C D
...since column 2 was bound and was empty.
If you'd like to customize this module, fork it in Github, clone your fork to your computer, then take the following steps:
- Change the package.json:name to a unique package name (dexter check_name will help you here)
- COPY env.example.js into a new env.js file and hook it up as instructed
- Make sure your test spreadsheet has some values that match the queries in fixtures/default.js
- dexter run to make sure everything's working
- run dexter init inside your newly cloned repo