Script for google sheets

I'll explain what I need.

I have a folder in google drive with many google spreadsheets files inside.

Every file is shared with a specific user and is named with a code associated at that user.

Example: file 123456 is shared with user 123456.

Furthermore, on my website there is a Mysql table called "all_orders" that collect every order related to al the users.


user |orderNumber |sku

123456 |1 |as1254

789456 |2 |pt4587

321654 |3 |pt5698

321654 |3 |pt8574


xxxxxx |n |yyyyyy

I want that a script job is scheduled (every hours) and do this:

Execute a query for every xxxxxx user like:

SELECT * FROM all_orders WHERE user="xxxxxx"

Insert the result of the query in the google sheet xxxxxx under the sheet "orders", deleting the data previously written.

I don't know which is the best way to do this, I hope in your help.

This is a sample only , the column are more and the query little more complex with more condition. So I need to access the code easily to personalize the code. Anyway this is the juice.

The code must not be accessible from user with in the files is shared in.

Квалификация: Excel, Javascript, MySQL, PHP, Архитектура ПО

Показать больше google script for loop, google sheets macros, google sheets api, google spreadsheet script get cell value, google sheets script functions, google apps script for beginners, google apps script call function, google apps script tutorial pdf, direction html form script google, script google calendar, script google maps, script google map api php, script google adsense php, script google map cms, greasemonkey highest script google, good redirect php script google analytics support, script google maps poi, data mining script google, script google trends data, script update cell google sheets

О работодателе:
( 10 отзыв(-а, -ов) ) Rivalta, Italy

ID проекта: #19029091



Hi, sir!! i have been read your description in depth and understand what you want. i think you should use python. python is very simple and powerful for automation. please check me. let's discuss your p Больше

$30 USD за 1 день
(7 отзывов(-а))

3 фрилансеров(-а) в среднем готовы выполнить эту работу за $43


Hi, I have couple of solutions for this. First I will create a master spreadsheet, which will have triggers inside. It will run every x mentioned [login to view URL] can be start and stop with a buttons. Once tri Больше

$70 USD за 2 дней(-я)
(249 отзывов(-а))

Greetings, Hi, First of all, I want to introduce my self I am Senior Full Stack Website Developer, having 6 years of experience in Website Development and Designing. I have understood your requirements with Scri Больше

$30 USD за 3 дней(-я)
(9 отзывов(-а))