I’ve created a form submission on my app to automatically appear on my google sheet.
Also, I’ve turned notification on my Google Sheet in effect to let me know if anyone submits a form->appears on my sheet->i get notified by email!
However, this does process does not work, any suggestions please?
I believe that is only if someone submits a GOOOOGLE form (not a Glide Form)
This may work. You can get a notification every time a COLUMN is changed (added to)
https://gsuite.google.com/marketplace/app/magic_cell_notifications/886834937346
Perhaps user zapier - when someone adds a row then send you an email or text, works well!
@spencersRus is correct. That trigger in Google Apps is only for Form submissions if those form submissions are linked to a sheet in the spreadsheet.