That’s exactly what I’m doing.
- You need to get an API key from Google associated with your Google account. This is a private number that I don’t think you want others to have access to. Go here to see how to get the key:
- Turn on sharing for you sheet by clicking on the “Share” button with your spreadsheet open. Copy the link and click “Done” to enable sharing.
- Find your spreadsheet ID by copying the portion of the link after /d/
- Create and test your HTTP_GET function. This page explains how to create the http website:
Essentially, you need to modify the portions in the brackets of the link below:
https://sheets.googleapis.com/v4/spreadsheets/[enter your spreadsheet ID here]/values/[enter your worksheet name here]![enter your cell that you want to read here]?key=[enter your API key here]
Paste this into the URL box of your browser and check what it returns on your screen. If everything worked correctly, you should see your value show up in a matrix. It will also tell you if you have an error. You can replace the cell portion with a range of cells by following the developers guide on Google.
This is what I get when I type in my URL:
“Report” is my worksheet.
“B23” is the cell I am reading.
“1.263” is the value of “B23” that I am interested in.
Let me know if this works for you, and I will explain the next steps of how to process the information in Smartthings.