Add a timestamp to a Google Spreadsheet (v3)

If you want to store in Google Spreadsheet, when a visitor started a conversation with your bot, here is how to do it.

Bear in mind that the time stamp, will based on the users browser time zone.

  1. Add the code snippet in the Welcome Message as in the picture:

Hi there!<script> const timeStamp = new Date(); Landbot.exec("landbot-custom-data", {"timestamp":timeStamp}) </script>
  1. In the Google Spreadsheet integration add the landbot variable @timestamp (as in the picture below) to the row in your Google Spreadsheet integration block.

  1. Once an input is done it will be displayed as follows in google spreadsheets:
These scripts and how to's are not native functionalities. Landbot won't be able to support, help or guarantee these scripts and how to's. These Workarounds and How to's are for developers, as a learning and example material on how to extend or modify some of the platform limitations.  Due to platform updates, some scripts might stop working in the future.Please, note that in case of Scripts and Workaround the Custom Success Team can deliver limited support.

How did we do?