You need to log in to create posts and topics.

Problem connected to magento from Google sheets


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.


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.