Page 1 of 1

Get info from google sheets?

Posted: Fri Aug 21, 2020 11:16 am
by RytisT
Hi. Is it possible to somehow pull data from google sheets regularly to switch as xml? I suppose I need scripting module for that? Or perhaps there's any other way without it? Any ideas? Thanks.

Re: Get info from google sheets?

Posted: Tue Sep 29, 2020 12:33 pm
by mart3223
Try using Zapier make a Zap that transfers the file (CSV or Excel) by FTP/Mail and you can pick it up in Switch. Convert it with this app (https://www.enfocus.com/en/appstore/pro ... cel-to-xml) and then you can use all info in Switch.