google sheet to MySQL
Budget: $750 – $1,500 USD
My organization currently using google sheet to manage data for all staff. we need to change the google sheet file annually due to size data too big than google limit. we are looking for some one can handle our project
A) First Phase.
1) Still using with google spreadsheet
2) But google sheet (2A) work as data entry form, after input enough data, staff will submit by google app script to MySQL database(2D ).
3) From database (2D) in MySQL, we can export some Select data back to google sheet (3A) also by google app script.
4) Again from the google sheet (3A) we can submit data to again MySQL database (2D)
5) We can extend the circle as many google sheet and many MySQL data to storeage as we want.
6) On the order hand, we will need to PHP website to make CRUD with MySQL when any one needed the modify or edit the data already submit by google sheet.
I am not expert in programer / Developer - if you guys have any better idea pls let me know to process this project.
Thanks
A) First Phase.
1) Still using with google spreadsheet
2) But google sheet (2A) work as data entry form, after input enough data, staff will submit by google app script to MySQL database(2D ).
3) From database (2D) in MySQL, we can export some Select data back to google sheet (3A) also by google app script.
4) Again from the google sheet (3A) we can submit data to again MySQL database (2D)
5) We can extend the circle as many google sheet and many MySQL data to storeage as we want.
6) On the order hand, we will need to PHP website to make CRUD with MySQL when any one needed the modify or edit the data already submit by google sheet.
I am not expert in programer / Developer - if you guys have any better idea pls let me know to process this project.
Thanks