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.
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.
In order to import a column as a variable, the column must be labelled. Then, the column will appear under variables.
Pick a file to write or create a new file.
Select the Worksheet you would like to write to.
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.
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.
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.