In order to use the Google Sheets module, you must first link your Google account.
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.
The Choose Worksheet to Read 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.
Pick the Google Sheet you want your WayScript program to write to.
Select the Worksheet you would like to write.
If "Include Headers" is selected, data headers will be written to your Google Sheet.
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 it is written.
The Google Sheets module allows you to ignore duplicates. If the same data already exists anywhere within the selected column(s) of the spreadsheet, the new row will not be written to the file.
If the entire row is equal to another entire row in the spreadsheet, it will not write the row again.
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."
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 like.
By default, changes WayScript makes to your Google Sheets do not fire notifications. This is to prevent your program from triggering another program with a Google Sheets Trigger.
If you want your changes to fire a notification, enable this setting in the "Advanced Settings" section.
If you are writing to a spreadsheet with both the "Replace File" and "Include Headers" options enabled and would like to replace everything EXCEPT the header row on each run of your script, enable this option under the "Advanced Settings" section. (The header row is presumed to be the first row of your worksheet.)