Add a timestamp to a Google Spreadsheet

Pau Sanchez Updated by Pau Sanchez

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 below picture:

Hi there!<script> const timeStamp = new Date(); this.setCustomData({"timestamp":timeStamp}) </script>
  1. In the Google Spreadsheet integration add the landbot variable @timestamp (as in the picture below):

  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?