Google Sheets

Work with Google Sheets

Read File

Select or Upload a Google Sheets File

When the Google Sheets module is activated, the default setting is to read a file. Reading files allows you to import columns into WayScript as variables.

Columns Appear

Once a spreadsheet is selected, the spreadsheet will populate on the page. Notes: The 'Sheet Name' selector can be used to pull in data from different tabs on a spreadsheet The 'Ignore Headers' checkbox can be used to prevent WayScript from pulling in column headers if they exist in the file. Row 1 in this image shows an example of headers that I might want to ignore.

Import Columns

In order to import a column as a variable, the column must be labelled. Then, the column will appear under variables.

Write File

Choose A File To Write Data

Pick a file to write or create a new file.

Choose a Worksheet

Select the Worksheet you would like to write to.

Write Mode

Add To File: every time the program runs, new rows of data will be added to the bottom of the spreadsheet Replace File: every time the program runs, the file will be wiped clean before the program runs.

Ignore Duplicates

The Google Sheets module allows you to ignore duplicates. In other words, if the same data already exists as a row in the spreadsheet, the file will not write it again. Ignore All Columns: If the entire row is equal to another entire row in the spreadsheet, it will not write the row again. Ignore A Specific Column (Ex: Column 1): If the selected column already contains the value about to be written to that row, the row will not be written.

Write Your Columns

You need to assign values to columns by pressing the + button under add your variables. Then the values of these variables will be written to your Google Sheets spreadsheet when your program runs. You can add as many columns as you would like.