Log to Google Sheets

This is a really helpful thread:

So basically, you can get component attributes (or status) of all your devices in a single API call using:

GET https://api.smartthings.com/devices?capabilitiesMode=and&includeStatus=true

In call Headers, along with Authorization token, you need to include Accept header with value of application/vnd.smartthings+json;v=20170916

The response is JSON which you can parse. Hope this will help.