spreadsheet

Google AppScript: Create Form using HTML, Publish Form as WebApp & Show data from Spreadsheet

This article shows: 1) How to create Google Form using standalone HTML file 2) Fetch data from Google Spreadsheet and populate Select box of the HTML Form 3) Populate second select box based on the value selected from first select box 4) Show result data from spreadsheet on form submit Basically, we have a spreadsheet … Read more

PHP: Google Spreadsheet with OAuth (Add, Edit, Delete, View data)

I was using ClientLogin method to access and update Google Spreadsheet. The ClientLogin method was in a deprecated state and now it has been turned off. We now need to use OAuth for authentication. Google APIs Client Library for PHP enables you to work with Google APIs such as Google+, Drive, or YouTube on your … Read more