Using Google API for Sheets, collecting recurring data sets and inserting into database (PHP MYSQL)

Completado Publicado hace 6 años Pagado a la entrega
Completado 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.

PHP Extracción de datos web

Nº del proyecto: #14982311

Sobre el proyecto

53 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

sunsoftpro

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

$526 USD en 10 días
(123 comentarios)
7.2

53 freelancers están ofertando un promedio de $547 por este trabajo

webbookstudio

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

$540 USD en 10 días
(318 comentarios)
8.6
seaanddream

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

$500 USD en 5 días
(300 comentarios)
8.2
iramrao

I have worked with google sheets before and I am professional web application developer with years of experience of MySQL database so that won't be a problem for me :) Let's discuss Relevant Skills and Experience 5+ y Más

$736 USD en 10 días
(93 comentarios)
7.9
mantislin

Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/scr Más

$548 USD en 6 días
(458 comentarios)
8.0
fleetways

Thank you for looking at our bid. (a)Web application with a refresh button to fetch latest data from google sheet (2)Local database update on fetch or on google sheet edit, request your response. Relevant Skills and Más

$833 USD en 15 días
(90 comentarios)
8.0
tarekahmed

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

$555 USD en 10 días
(127 comentarios)
7.7
mascotindia123

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

$500 USD en 7 días
(274 comentarios)
7.6
jinzhenzhu8691

'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

$555 USD en 10 días
(22 comentarios)
7.2
kanika6665

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

$555 USD en 10 días
(69 comentarios)
6.9
Wangxianming

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

$1000 USD en 10 días
(16 comentarios)
6.8
Shopify

Relevant Skills and Experience We also use to work on other CMS based on PHP like - Wordpress, Drupal, Joomla *Shopping cart/ eCommerce CMS - 1)WoocommerceD 2)Opencart 3)Shopify 4)Laravel 5)CodeIgnite 6)Symfony Pr Más

$618 USD en 10 días
(26 comentarios)
6.9
luiswilliam

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

$250 USD en 10 días
(69 comentarios)
6.7
prashushinde9

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

$773 USD en 15 días
(53 comentarios)
7.0
ruwanjayawardena

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

$555 USD en 10 días
(35 comentarios)
6.4
rinkul123

We have more than 5 years of experience on professional web and blog designs as well as on developments with 2 years experience in Web security and virus removal. Relevant Skills and Experience Website design, web dev Más

$450 USD en 10 días
(83 comentarios)
6.7
Verz1Lka

Hello! I'm web-scraping and web automation expert. I have 5 years of experience and i have 500+ finished projects (ecommerce, directory listing, etc...) Relevant Skills and Experience I can scrape protected sites, and Más

$535 USD en 10 días
(109 comentarios)
6.6
wenmobile3

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

$555 USD en 10 días
(19 comentarios)
5.6
RubyOnRail

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

$555 USD en 10 días
(15 comentarios)
5.8
olansile

A proposal has not yet been provided

$550 USD en 5 días
(9 comentarios)
5.5
vietdevteam

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

$250 USD en 3 días
(42 comentarios)
5.4