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!
Best answer
How do you download an entire sheet as xml using Zapier automation?
- Beginner
- 1 reply
Best answer by Troy Tessalone
Hi
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 30942 replies
- Answer
Hi
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
+6- Zapier Staff
- 2336 replies
Hi
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.
- Beginner
- 1 reply
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!
1 person likes this
+6- Zapier Staff
- 6380 replies
That’s awesome
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.