Automated Data Export
I have a problem that I have been struggling to find an efficient solution for regarding how to routinely get form data out of smartsheets. I am hoping for ideas, advice, and/or secure tools that you all may know of to help with that. For context, below is my current issue/goal and what I think is the best solution. Please critique:
Goal: I need to get my form data out of smartsheets and into our local network. (Specifically, we are trying to get it onto our SQL Server.) For example, when an object is stolen, we want a user to fill out a form to get all the information for the police. We want the information that was added the smartsheet to then automatically be sent to our SQL Server where it will be used to create a nice looking report.
We have explored some options, we are ruling out Data Shuttle as a tool because it is too expensive for our use case. We are ruling out Zapier because of firewall concerns.
Current Idea: We are looking for a SFTP location for smartsheets, or some secure location where we can grab information for our SQL server. I know there's likely a lot of work that goes into this solution, but security is vital for this project.
Please let me know if you have an idea, a tool, some advice, or if I need to elaborate.