I want to use Gsheets to track accounts and group membership in a proprietary 3rd-party application. Right now I have a python script running on a server that checks the sheet for accounts and membership parameters and it works great. It will read the sheet and check the 3rd-party app and make sure they always match with the sheet being the source of truth.
However, I'm not really a Gsheet master. Recently I found that I can create buttons in Gsheets that will run JS code. I'm also not a JS master, however. I actually have two questions. The first one I think the answer is yes. Can I hit outside resources like REST endpoints from these buttons? If I am right and that can work. The second question is, can I have a JS script inside a button run a python script that I contain in the Gsheet somehow? The reason is that this would make the entire process contained in the Gsheet for much easier distribution and adoption as it eliminates the need for ancillary resources to run the Python code. Any help would be much appreciated! Thanks! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/112325bc-207d-4623-95a9-bbcec6c70098%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
