CODEWITHSUNDEEP
phpmysqlformsgoogle-forms
skwidbreth
skwidbreth

Reputation: 8444

PHP to MySQL and Google sheet?

A few months ago, my supervisor needed me to create a form to collect some data - at the time, the most sensible thing to do was just to whip together a Google Form, no problem. Now it turns out that the data collection program needs to expand, and it makes more sense to direct the form to a MySQL database (using PHP) instead - again, no problem, already done. However, for reasons I won't elaborate on here, my supervisor still wants that data to go to the original Google Sheet as well.

My question - is it possible to submit form data to two separate sheets when one is a MySQL table and the other is a Google Sheet?

Thanks!

Upvotes: 2

Views: 4761

Answers (1)

Dani Polo
Dani Polo

Reputation: 423

I know that feel bro ;)

There's some resources to handle boss requests:

  1. PHPExcel Class is a library written in pure PHP and providing a set of classes that allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, HTML...
  2. You will need an script to process the outputs.
  3. Excel / CSV > MySQL
  4. MySQL > Excel / CSV

If you need directly to work with Google Docs, you will have to follow the previous steps and play with the following project:

php-google-spreadsheet-client is a library that provides a simple interface to the Google Spreadsheet API.

You will need to store data in MySQL and pass it to Google.

Second idea:

If your boss neet it NOW, you can give a chance to Zapier and do it fast. If you don't need a very fast sync time, it can be a good free option.

I hope it helps :)

Upvotes: 1

Related Questions