App Functionality

[dessie_moonsamy]

I have a google sheet that will populate via a whatsapp integration.  This sheet will be my job cards.

I want to use this spreadsheet as my source data. The app should be able to look at this data and send me an email as and when the google sheet is updated.  The app wont be used to create job cards but rather notify me of when a new record is updated on the spreadsheet.  Is this possible?

[Marc_Dillon]

Yes and no.

Bots typically only trigger on data changes that happen in the app. But recently(ish) they added "external eventing" that can trigger a bot upon a manual edit of the GSheet, however most integrations from other services that send data in still don't trigger this.

You can work around by keeping another table of "seen" records, and running a scheduled bot to identify new records by not existing in the "seen" table. Or by just editing a "seen" column in the same table.

Or you can work around by setting up an appropriate onChange App Script.

[dessie_moonsamy]

Thank you.  I am am going to give this a try and report back.