Google Spreadsheet reading datas from MySQL



I need to create Google Spreadsheet so It will allow me to do this :

1, The spreadsheet will read datas stored on MysQL server and load into rows/columns

2, When I Enter specific SKU code into "reading" field in spreadsheet, it should connect with SQL server, and return a possible products in list. When I choose certain product, it will fill up another cells with its datas (description, price, unit,etc..)

When entering datas into quotation, I want to see a collapsed view : 1 row for 1 product. But sometimes if I need I should be able to view it in different view too : each product should have loaded a thumbnail too (loaded from eshop based on MySQL) .

Basicaly the same option should have customer too if sent by "share link or publish to web" : to see both collapsed and "unfolded" version.

I will be happy to change the functionality if better solution can somebody suggest, I require this, because I have similar template in MS Offce already and it works fine, but I want the sharing feature and more flexibility. I have a MS office template working, which I will be happy to provide to understand it more deeply..After project succesfull I have many other features to implement as another projects.

Skills: Google App Engine, MySQL

See more: sql server price list, publish google spreadsheet to web, google spreadsheet web app, spreadsheet google, office web app server, row spreadsheet, reading, google suggest, customer spreadsheet, spreadsheet price list, office app 2013, create google spreadsheet, spreadsheet columns, spreadsheet template, quotation engine, mysql web spreadsheet, product eshop, google app enter, mysql spreadsheet, google publish, google app mysql, google spreadsheet code, google engine app, option spreadsheet, spreadsheet sql server

Project ID: #4236692

Awarded to:


Hi, can help.

€350 EUR in 4 days
(13 Reviews)

3 freelancers are bidding on average €350 for this job


Hi! Seems interesting project. Google Apps Script is a powerful tool and I think we can accomplish what you need. Contact me and we'll discuss more details.

€300 EUR in 5 days
(11 Reviews)

Hi! Please see your inbox.

€400 EUR in 2 days
(10 Reviews)