Using Google API for Sheets, collecting recurring data sets and inserting into database (PHP MYSQL)
$250-750 USD
Pagado a la entrega
We have a workbook in google that has multiple sheets with the same data sets on each one for each month. We need to get the information from each sheet an add the data in a mysql database for each sheet and have it update on page load from the latest data shown on the sheet (the sheet is updating frequently). The data will be saved in the database with the corresponding sheet name.
This will allow us to retrieve the information from the database for a given month-year (sheet name).
The JOB:
1. Using supplied API key and Credentials, read the list of sheets from shared google workbook.
2. Using the sheet names as a reference allow the collection and update from any given sheet and store it in a mysql database for that sheet name (month-year) (1 of the cols in the database).
3. Write a simple web application to show a drop down list of sheet names and a submit button that we can then update the data from the sheet into the database. We will then display in html certain information from the database after the data has been updated.
An example of the Spreadsheet is attached, you will see the sheet names are the Month - Year and the sheets can contain different employee names and can have more or less employees on any given sheet, the format always stays the same however including the empty rows.
Nº del proyecto: #14982311
Sobre el proyecto
Adjudicado a:
develop the simple application to synchronize the data from Google sheet to MySQL database. Relevant Skills and Experience PHP, Web Scraping, Google sheet API Proposed Milestones $526 USD - Milestone
53 freelancers están ofertando un promedio de $547 por este trabajo
Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Más
Hi, my name is Sevinc. I read your "Google API" project descriptions carefully before bidding. I checked the attached sshot as well... I got what you need and ready to go ahead. Relevant Skills and Experience I am 5- Más
On time and On budget I can do all what you want .... I did 320 projects with a rate of 5/5 .... please check https://www.freelancer.com/u/tarekahmed.html Relevant Skills and Experience I have a Professional team for Más
Hey Friend, We are 14 person team of developer, designer and tester provide you excellent services. Relevant Skills and Experience Myself having has 10 years experience of web site development. Expert in Custom pr Más
'Swift - Modest - Competent' Tired of communication issues with the other developers? Tired of developers raising the price midway through the project? Well.. you don’t have to worry about that anymore with me ! Más
Hi jimby222, I find myself eligible for this job since I am having 7 years of extensive experience Relevant Skills and Experience: I am Good at PHP, Web Scraping Proposed Milestones: 555 - We will discuss the milestone Más
hi, I've experienced in web develop 7 years. Especially php and javascript framework expert level. I'll give you perfect result. If you're on mind work with me contact me. regards Relevant Skills and Experience PHP, W Más
Hello, I am very exciting to see your Google API project description. I am talented in Google apps script API for several years. I made a lots of product with Google Spreadsheets. Relevant Skills and Experience Hope t Más
Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. Relevant Skills and Experience I expertise in: - RubyO Más
Hi.., Contact me via freelancer chat.I need to discuss more about your project requirement in detail. I m standalone custom php developer. Thank you. Ruwan (PHP Full stack Engineer) Relevant Skills and Experience - P Más
Hi How are you? I have gone through your job description carefully and understood it correctly. Relevant Skills and Experience I am an expert in PHP, css3/Html5, javascript and MySQL. I have 5 years of experience in p Más
I have checked the requirement and I am clear with the scope. I have few questions on the description and would like to discuss this. Please initiate the communication, so we can discuss the project. Proposed Mileston Más
I have read your project. I'm sure i can help you to do it. I have 7 years of experience in Web Development, System & Network Administrator and Security Researcher. Choose me then you will work with a Professiona Más