Forum Navigation
You need to log in to create posts and topics.
Problem connected to magento from Google sheets
November 30, 2020, 10:49 am
Hey. Check with your hosting provider, as Google server do calls from few different IP address's(depends from yours region). And sometimes they have to be whitelisted.
Thanks.
May 31, 2021, 7:02 am
Microsoft Flow, or Power Automate now, is actually an excellent solution. I use it for something else, but basically the same concept. I have a script that runs a MySQL query and dumps the results to a csv file. Flow watches the directory for the file (SSH/SFTP), uploads it to Sharepoint, sends an email to everyone interested in the file, and deletes it from the original location (SSH/SFTP).
If you aren't using Office 365 you should be able to do something similar with Zapier. Or, there is bound to be a Google Sheets Python script on Github somewhere.