Project to log data from Google Nest thermostats into a Google Sheet, using the Smart Device Management (SDM) API and Apps Script. It also uses the weather.gov API to add local weather data.
The SDM API was launched in September 2020 (read more).
Follow the steps in this Get Started guide from Google to access your device(s).
Note: there is a one-time, non-refundable $5 charge to access the API.
The project must be created in the same Google account as the Nest home devices are connected to.
You will need to create a project in your Google Cloud console, where you can get OAuth ID and secret.
This project uses the OAuth2 Apps Script library.
And yes, it's possible to set your thermostat temperature from your Google Sheet, at this endpoint
Tutorial: Control Your Nest Thermostat And Build A Temperature Logger In Google Sheets Using Apps Script