In Progress

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.

Skills: PHP, Web Scraping

See more: 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

About the Employer:
( 23 reviews ) Morningside, Australia

Project ID: #14982311

Awarded to:

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 in 10 days
(109 Reviews)
6.8

62 freelancers are bidding on average $536 for this job

$555 USD in 10 days
(106 Reviews)
8.2
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 More

$833 USD in 15 days
(87 Reviews)
8.0
bdsiddhi

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

$600 USD in 10 days
(179 Reviews)
8.3
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 More

$736 USD in 10 days
(71 Reviews)
7.5
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 More

$540 USD in 10 days
(92 Reviews)
7.8
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- More

$500 USD in 5 days
(215 Reviews)
7.4
wpoppo

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 More

$600 USD in 12 days
(116 Reviews)
7.6
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 More

$548 USD in 6 days
(282 Reviews)
7.3
$555 USD in 10 days
(60 Reviews)
7.4
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 [url removed, login to view] Relevant Skills and Experience I have a Professional team for More

$555 USD in 10 days
(102 Reviews)
7.4
Webicules

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 More

$555 USD in 10 days
(182 Reviews)
7.6
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 More

$618 USD in 10 days
(19 Reviews)
6.8
$555 USD in 10 days
(8 Reviews)
6.9
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 More

$500 USD in 7 days
(210 Reviews)
7.2
JoomlaVogue

Please have a look at our portfolio for CorePHP projects:[url removed, login to view] Relevant Skills and Experience Please have a look at More

$277 USD in 10 days
(100 Reviews)
7.4
$555 USD in 14 days
(94 Reviews)
6.4
tranngocanh1702

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 More

$600 USD in 12 days
(69 Reviews)
6.8
qprotex

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

$555 USD in 10 days
(51 Reviews)
6.6
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 More

$1000 USD in 10 days
(8 Reviews)
6.6
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 More

$773 USD in 15 days
(51 Reviews)
7.0