Copy google sheets data to MySQL Database
- or -
Post a project like this- Posted:
- Proposals: 43
- Remote
- #3757267
- OPPORTUNITY
- Expired
Description
The google sheets data has multiple tabs which you will need to be aware of. There are 7 tabs/sheets in total and the data in google will be added to daily, so the process will need to sync fairly regularly so the data is up to date for the website to utilise.
I can supply a link to the demo data and a test MySQL DB I've created for this purpose - along with anything else needed to facilitate the project. I'm working on the front end, creating a search facility and reporting on the data with a hope I can partner with someone to work on copying/syncing of that data, but also open for any advice you may have for a better approach. Even accessing the google sheets data direct if that's a better approach - but after extensive research and with the complication of having to subscribe to a third party api, don't feel it's the best approach - although I am completely open for any advice and/or guidance
Thanks!
Guy
Guy R.
0% (0)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Guy R
Is this a 1 time copying or It needs ongoing syncing?
Please share sample google sheets with same number of tabs with 1 record sample data -
What is your timeline for this project?
-
Hi Guy,
Are you open to some different approaches?
1. If the source data updates comes from CSV files to google's sheets then I suggest developing scripts that would get the same CSV files from the source directly into MySQL database.
2. If the data updates manually then I suggest to develop simple interface that would do the same manual process, of course it would save the data directly into the database.
Kindly let me know which one you prefer?
Cheers,
M. C.
-
Hello is this still available ?