Hey pmccord,
for your first question, I had a similar problem and I solved it with the following flow:
1) I exported the Notebook to python
2) In SQL Server, I created a SQL Server Agent job to run my script
3) In SQL Server, I created a Stored Procedures to trigger the SQL Agent job created @ previous step
3) In MS Power Automate I created a flow to manually trigger the stored procedures created @ previous step
4) have the end users install the Power Automate App on their phone and push the button to reset their data any time they need to.
if this is something that could work for you, I would be more than happy to share the flow in details with screenshots.
Good luck!
D