Google Assistant to IFTTT to update cell in Google Sheet. onEdit:yes, value:no

user875479 Source

A little confused. I have this working in one sheet, but a different sheet is not. Voice command through Google Assistant triggers IFTTT to send values to a certain cell in my spreadsheet. With onEdit, the cell change triggers the function, correctly identifies the page, row, col of the edit, but no value. Even pulling the row or column or sheet values show nothing in that cell. Can see it on the screen. It triggered the event, but no value as if the event is trigger prior to the value being set.

google-apps-scriptgoogle-sheets

Answers

comments powered by Disqus