The valuable information the user is introducing in the chatbot I'm saving in a Google SpreadSheet and the automatization it's done through Pabbly.com
Everything works fine until i try to 'enhance' the spreadsheet by putting code in 'Apps Script'. I would like to have two extra features (see the attached picture):
1. the date and time of the new entry in the spreadsheet
2. the possibility to mark with done (when it's marked 'done', the row turns green) the confirmed prospects
There is someone with more experience in Google Sheets who can assist me?
or
There is another better way to achieve my goal?
Thank you!
https://cdn.discordapp.com/attachments/1140323380466294844/1140323380617285733/image.png▾