Write to Google Sheets#

Adds a row to the end of the spreadsheet: a request, an order, survey answers.

Settings#

• "Table" — where to write:
  • "Create new" — the bot itself creates a spreadsheet in the connected Google account on the first write. Set the "Table name". The bot writes headers — the variable names — into the first row.
  • "Use existing" — enter "Link to table" and "Sheet".
• "New sheet every month" — for a new spreadsheet: at the beginning of each month the bot creates a new sheet in it, and at the beginning of the year — a new spreadsheet.
• "Mapping Variables to Table Cells" — what to write to which column. A value is added with the "Add variable", "Add constant", "Add global variable" and "Add text" buttons, with the column letter next to it. The "Creation date" constant writes the current date and time.

Outputs#

• "Continue" — the row has been written.

Good to know#

Empty values are not written to the spreadsheet — the cell stays empty. If all values are empty, the bot sends "Variables not found" and goes no further. If the mapping is not set — "Variable mapping not set".