Đã hoàn thành

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.

Kĩ năng: Excel, Javascript, MySQL, PHP, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 10 nhận xét ) Rivalta, Italy

ID dự án: #19029091

Được trao cho:

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 Thêm

$30 USD trong 1 ngày
(7 Đánh Giá)
3.4

3 freelancer đang chào giá trung bình $43 cho công việc này

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 Thêm

$70 USD trong 2 ngày
(249 Nhận xét)
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 Thêm

$30 USD trong 3 ngày
(9 Nhận xét)
3.6