Hey Sean! This sounds like a really useful workflow. I don’t think we have a way to upload a file to a server, but you could you use something like Dropbox? Our Dropbox integration can add text to and create text files, and I could imagine that working, even if you have to set up a cron task to sync from Dropbox over to your file after. 

I’d offer more advice but this realllllly seems like it might be over my head—I think pythons are snakes. But I hope the suggestion is helpful. 

I totally agree! Pythons are snakes :)

I was taking a look and found OneDrive - create a file from template will be really useful for this, depending on how easy/hard it will be to retrieve the file in OneDrive, otherwise, Dropbox will work too. 

Thanks for your response.

Great idea @jpot . If that doesn’t work, maybe you can have your python code expose a webhook and let Zapier call this webhook. You can then send some JSON data with all the stuff you need towards the script, which would automatically take actions from there.

Let us know how it goes! :D

~Bjorn

All done!

I went the low tech route - with something that looks like this: 

Trigger: When a row is updated in Smartsheet

Do this:

  Only continue if Backup script created is not true

  Format the filename to replace cspace] with _

  Create new text file in OneDrive (based on a template)

  New row update in Smartsheet (update the Backup script created checkbox)

All that will remain to be done is to update the file extension from .txt to .py

Thanks for your ideas. 

Sean