Skip to main content

I am trying to automate something to eventually end up bringing a file into a specific dropbox folder where it is automatically checked every couple minutes. I have the data taken from a google form updating a row in sheets, and I can manually export it as XML, and put that file into the dropbox folder it needs to go in. I just need to automate the process of exporting it as XML. I know I could do this using Python and find tutorials that way, but this would be super convenient to just do it all in Zapier. Thanks!

Hi ​@Carson R 

You would likely have to use a Code step in a Zap to take the data from GSheets and convert to the desired XML structure.
GSheets can return data in JSON format.

Code help: https://zapier.com/apps/code/help


Hi ​@Carson R,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


Ah yes, sorry. I did end up using a Zapier Webhook to send a ping to PythonAnywhere where I have a piece of code that can do the job. Thanks for your help!


That’s awesome ​@Carson R! Were glad to hear that you have found a workaround here and thank you for sharing it here!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗