CODEWITHSUNDEEP
javascriptphpgoogle-apigoogle-sheets
geoff
geoff

Reputation: 45

Trying to pull values from a Google Sheet using PHP or Javascript

I have a Google Sheets spreadsheet containing product inventory. There are multiple sheets within the document, each sheet containing products of a particular brand. The two important columns in each sheet that I'd like to be able to work with are Part Number, and Quantity.

What I want to be able to do in my web app is, given a particular part number and brand name, look up the corresponding quantity in the correct sheet in my Google Sheets document, and send that value back to to the web app to display. (Essentially, I want the web app user to be able to click on a part number, and get the current quantity of that item displayed next to it.)

I've tried publishing the Google Sheets document to the web, and accessing it in PHP as several of the formats Google offers (csv, xlsx, and ods) and have hit a wall in each instance:

I don't need to modify the Google Sheet in any way with this... all I need to do is go, "Given brand X and part number Y, return the value in the Quantity column of this Google Sheet." I'm really hoping there's a (fairly) simple way to do this...

Upvotes: 0

Views: 204

Answers (1)

randrade86
randrade86

Reputation: 346

I recommend using this Google Spreadsheets Client API.

It makes the dirty work quite simple and provides a relatively easy-to-use interface so you can work with your spreadsheets without "workarounds".

Upvotes: 1

Related Questions