ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
2
3
The Elate + Google Sheets integration allows you to connect data from various sheets into Elate using a single document.
4
5
We've gotten things started for you by entering in some examples with sample data in a couple of tabs. Feel free to clear that data out to input your own data.
6
7
If you are wanting to pull in a full record of data without using a specific time field, we recommend adding a column called "Current Date" that populates today's date using the formula: "=today". An example of this is shown in the sample data in this sheet.
8
9
If you have different spreadsheets you are wanting to bring together, you can create different tabs for each dataset. When creating the metric in Elate, you'll find the tab names populate the "resource" field in the configuration mapper.
10
11
Date formats need to be consistent. When connecting into the Google Sheet integration in Elate, you will choose the format that matches your format in the sheet.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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