Tibber Energy Export v1.0

	A	B
1
2
3	What is this?
4	This is a Google sheet to get your historial energy consumption from Tibber.
5
6	Who is this for?
7	This sheet is for Tibber users who want to crunch their consumption data manually using Google sheets, or any other type of tool (excel, etc), but don't have the knowledge or interest in learning how to do this using the Tibber API. This only works if you are paying for Tibbers Energy services (you can still play with the demo token if you're not paying though).
8
9	How does it work?
10	The Google sheet connects to the Tibber API to get hourly energy data and prices using your personal access token. To get this sheet running you should make a copy of this sheet so you can edit it (keep it private), you also need your personal access token. To get started, do the following:
11	1	Make a copy of this sheet (this sheet is read-only, but you will be able to edit your copy). Make sure you don't share your sheet with others, unless you want to of course.
12	2	Go to https://developer.tibber.com and sign in with your Tibber account (same as in the app).
13	3	Click on your name top right, then Developer settings.
14	4	If you have a Token already, use that. If not, press Get Access Token -> Create Token.
15	5	Copy the Access token and paste it in "Your access token" in the configuration sheet. (there is a token there already, that's a demo token for you to play with if you don't have an account)
16	6	If you want to get a specific amount of hours, you can specifyt that in the hours to fetch input field.
17	7	Press Get consumption data. First time you run this you need to grant the Google sheet access to Tibber API
18
19	Limitations
20	Currently this only supports one home.
21	If you don't clear the sheet between runs it doesn't work properly.
22	This requires you to have a (free) Google account.
23	Production data is only available the following day (when it's been sent by the grid company).
24	This does not take discounts on smart charging etc into consideration as that is only applied at billing.
25
26	Need help or have suggestions for enhancements?
27	Contact us at hello@tibber.com or straight from the Tibber app.
28
29	Copyright Tibber AS 2021
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100