Problem connected to magento from Google sheets
Quote from web idea on November 30, 2020, 10:49 amHey. 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.
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.
Quote from rahulp411 on May 31, 2021, 7:02 amMicrosoft 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.
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.