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

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.

Kemahiran: PHP, Pengikisan Web

Lihat lagi: php save form data to google spreadsheet, insert data into google spreadsheet using javascript, google spreadsheet api php tutorial, connect google spreadsheet to sql server, write to google spreadsheet php, google spreadsheet api php without zend, get data from google spreadsheet javascript, submit form data to google spreadsheet, search engine using google api, plot flight path using google api, using google api image search, interactive map using google api, prase rss using google api, net applications using google api, send email using google api, driving distance using google api java, using google api pagerank, distance excel using google api, php search script using google api, using google api search mysql database

Tentang Majikan:
( 24 ulasan ) Morningside, Australia

ID Projek: #14982311

Dianugerahkan kepada:


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 dalam 10 hari
(122 Ulasan)

57 pekerja bebas membida secara purata $544 untuk pekerjaan ini


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 Lagi

$540 USD dalam 10 hari
(207 Ulasan)

Dear Employer, I'm very much confident & interested to work on this [login to view URL] have an expertise on PHP & MySQL & also customise any complex level of concept to exceed your expectations. Relevant Skills and Experienc Lagi

$600 USD dalam 10 hari
(205 Ulasan)

Hello, I am a professional PHP developer with an experience of more than 8 years in creating and customizing PHP based websites, themes and plugins/modules. Relevant Skills and Experience I am well equipped in PHP, W Lagi

$600 USD dalam 12 hari
(179 Ulasan)

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 Lagi

$548 USD dalam 6 hari
(387 Ulasan)

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 Lagi

$833 USD dalam 15 hari
(88 Ulasan)
$555 USD dalam 10 hari
(114 Ulasan)

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- Lagi

$500 USD dalam 5 hari
(254 Ulasan)

I am able to create the web app that can connect with Google Sheet to pull data and show dropdown list of sheet names and submit button. I am ready to start now. Relevant Skills and Experience I am Anna with more than Lagi

$600 USD dalam 12 hari
(122 Ulasan)

Hello, I am Web Expert. I have expertise in WordPress, Magento, Joomla, PHP, MySQL, HTML5, CSS etc. All my websites are well adaptable to mobile, tablets, laptops and desktops. Relevant Skills and Experience Please s Lagi

$555 USD dalam 10 hari
(229 Ulasan)
$555 USD dalam 10 hari
(74 Ulasan)

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 Lagi

$736 USD dalam 10 hari
(74 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(126 Ulasan)

'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 ! Lagi

$555 USD dalam 10 hari
(22 Ulasan)

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 Lagi

$500 USD dalam 7 hari
(241 Ulasan)

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 Lagi

$618 USD dalam 10 hari
(26 Ulasan)

Please have a look at our portfolio for CorePHP projects:[login to view URL] Relevant Skills and Experience Please have a look at Lagi

$277 USD dalam 10 hari
(104 Ulasan)
$555 USD dalam 10 hari
(32 Ulasan)
$555 USD dalam 14 hari
(154 Ulasan)

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of e Lagi

$555 USD dalam 10 hari
(67 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(63 Ulasan)