Unfortunately, as a new user I am not allowed to comment. This is why I need to do a new post regarding to this topic: Insert current date to cell based on content in other cell

This is my code in Google Sheets Script:

function onEdit(e) {
  if (e.range.getSheet().getSheetName() == 'Tabellenblatt1' && e.range.getColumn() == 1) {
    e.range.offset(0,1).setValue(new Date());

It works perfectly when I enter data in cell 1 manually, but when data is added via API (in this case when data is added via Zapier) it does not work. Anybody can give me a hint why?

1 Answer 1


The edit triggers, simple and installable, are triggered by changes directly done by the user while having the spreadsheet open in a web browser.

Similar Q&A



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.