Push notification bot not working when data is pasted into google sheets

AppSheet AppSheet Q&A
1

So i have an automation set up in my Appsheet that will send a notification to users when a new row of data is added. However, the way the data is added to the spreadsheet via external means, i.e n8n bot for instance, and the entire row of data is pasted into the sheet.

Does doing so not trigger the notification automation? Does the row of data have to be manually input in google sheets in order for it to work? And might I ask if there’s a way to trigger the automation with the current data input method?

Thank you in advance.

2

You are probably using an automation from n8n that uses the Google Sheets API to push a new row of data into your datasource. This will not trigger any bots in AppSheet to do anything.

Instead, change your n8n automation to use the AppSheet API to add the required row to the datasource. This WILL trigger any bots within the AppSheet App you specify in the header of the webhook.

4 Likes
3

I’m thinking of calling the n8n API to signal the bot and trigger, wonder if it’ll work though?

4

@ScottDev1’s response is the correct approach.

4 Likes
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.