# Exporting energy report with smarthings-cli?

**URL:** <https://community.smartthings.com/t/exporting-energy-report-with-smarthings-cli/262902>\
**Category:** Automation Ideas\
**Created:** [April 29, 2023, 9:00pm UTC](https://community.smartthings.com/t/exporting-energy-report-with-smarthings-cli/262902 "2023-04-29T21:00:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sediento](https://yyz2.discourse-cdn.com/smartthings/user_avatar/community.smartthings.com/sediento/32/172239_2.png) [@Sediento](https://community.smartthings.com/u/Sediento)\
**Post date:** [April 29, 2023, 9:00pm UTC](https://community.smartthings.com/t/exporting-energy-report-with-smarthings-cli/262902/1 "2023-04-29T21:00:15Z")

</div>

Is there a way to export all the data related to the consumption of a plug?

---

<div class="post-metadata">

**Author:** ![h0ckeysk8er](https://yyz2.discourse-cdn.com/smartthings/user_avatar/community.smartthings.com/h0ckeysk8er/32/195141_2.png) [@h0ckeysk8er](https://community.smartthings.com/u/h0ckeysk8er)\
**Post date:** [April 29, 2023, 11:47pm UTC](https://community.smartthings.com/t/exporting-energy-report-with-smarthings-cli/262902/2 "2023-04-29T23:47:58Z")

</div>

> [@Sediento](#):
>
> Is there a way to export all the data related to the consumption of a plug?

If the device reports consumption info in history, you can use the method described [here](https://community.smartthings.com/t/post-groovy-google-spreadsheet-integration/255717) to save it to Google Sheets.

---

<div class="post-metadata">

**Author:** ![Sediento](https://yyz2.discourse-cdn.com/smartthings/user_avatar/community.smartthings.com/sediento/32/172239_2.png) [@Sediento](https://community.smartthings.com/u/Sediento)\
**Post date:** [April 30, 2023, 2:29pm UTC](https://community.smartthings.com/t/exporting-energy-report-with-smarthings-cli/262902/3 "2023-04-30T14:29:43Z")

</div>

That’s the problem. It doesn’t show the energy consumption on the history even though I can see it on the energy tab in the app.
