Lengkap

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.

Example:

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.

Kemahiran: Excel, Javascript, MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: 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

Tentang Majikan:
( 10 ulasan ) Rivalta, Italy

ID Projek: #19029091

Dianugerahkan kepada:

susanna2018

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 Lagi

$30 USD dalam sehari
(7 Ulasan)
3.4

3 pekerja bebas membida secara purata $43 untuk pekerjaan ini

mrbrave

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 Lagi

$70 USD dalam 2 hari
(249 Ulasan)
6.7
iusmanadil

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 Lagi

$30 USD dalam 3 hari
(9 Ulasan)
3.6