I have created a python script to append new values in gsheet using google apis, in this case the appsheet is not pushing any events. Reading https://support.google.com/appsheet/answer/11520310?hl=en#:~:text=You%20can%20also%20try%20removing,(from%20the%20Users%20tab). tells that third party entries won’t be read. I wanted to know is there any work around for this ?
You are correct that presently sheet updates by third party services do not automatically fire UPDATE events in the app. The data itself will be reflected in the app upon the next Sync for any given user.
However, if you need specific actions to be taken when the data changes then you will need to implement these yourself. How depends on the activity needed.
-
If you wish to make a simple row update and want all App Formulas to fire and perform updates to associated columns, then you will want to call into the AppSheet API and perform a row update that way rather than updating the sheet directly.
-
If you need to apply row updates across multiple tables or multiple rows, then you will need a process that can coordinate these then call into the AppSheet API. NOTE: you can batch similar updates into a single API call - e.g. apply a 10% price increase to all products.
-
Maybe you need to apply updates/insertions and don’t care about triggering update functions in the app? These you can apply directly to the sheet and each user will see the new data/rows on the next data update to their devices.
I believe you can call into AppSheet API with a python script but if not there are other ways - Google scripts or use Make integration service which has default integration with AppSheet.
I hope this helps!