Add timestamp to spreadsheet by sending mail

This adds a timestamp to a google spreadsheet by sending an email to Gmail with either Arrival or Departure in the subject line. This combined with a filter in Gmail that labels the email (and archives it) so it doesn't "interfere" with your inbox. I have also added a button in Outlook that will send an email (from a template) without any other interaction needed. Essentially a "punch in" and "punch out" functionality. In the spreadsheet I have parsed the timestamps with different formulas to create a summary of working hours on another sheet.

by schangdk

Learn more

8 Users Enabled This Applet 8
works with
  • Google Sheets

Applet version ID 192851