send a push notification from a public app to a secure app

[GEN318]

I have two white label apps, one requests technicians assistance(public) and the other receives these requests(secure). when a new request is added from the public add i want to send a push notification to the specific technician on the secure app.  the notifications worked when testing on the appsheets app but do not work with the whitelabled versions 

[Steve]

Enable push notifications in your white label apps - AppSheet Help

[GEN318]

i have already enabled push notifications, using the firebase api. but when record is added on my public app i need to send a push notification to the user on my secure per user app. 

[Steve]

How is the automation that sends the notification triggered?

[GEN318]

the public app has an automation that when a record is added it sends a notification to the email referenced in the new record 

[Steve]

What does the monitor tell you?

Monitor automation - AppSheet Help

[GEN318]

all the statues say complete on the monitor. just to be sure we are on the same page the intention is to send a notification from the public app to the secure app. the automation is running on the public app

[Steve]

Ah. I've not worked with notifications at all, but I'd expect notifications can only be sent to users of the same app; you can't send notifications to users of a different app. You would have to find some way to get the recipient and message to the secure app, then have the secure app send the notification.

[GEN318]

okay, would it then be possible to run an automation that checks when a new row is added to the table on google sheets, when the row is added it will then send the notification? 

[Steve]

Absolutely that's possible!

[GEN318]

okay how would i go about having it where my public app would add a new row, then the secure app would check for a new row added?

[dbaum]

Look into External eventing with Google Sheets - AppSheet Help 

[GEN318]

hi thanks for the suggestion, i tried it out but it only sends the notification when i manually add a row to google sheets. i need it to send when a row is added from a different app

[dbaum]

Additional ideas to investigate:

• Use an Apps Script script on the spreadsheet that is triggered by a new row to make a data change via the AppSheet API in the "secure" app that in turn triggers a notification.
• In the "secure" app, create scheduled automations that run periodically (e.g., hourly during working hours) to check for new rows and, as necessary, send notifications.

[GEN318]

Thanks, the first option seems to be more inline with my intentions. do you have any documentation to help get started on the process?

[dbaum]

Simple Triggers | Apps Script | Google Developers