ABCDEFGHIJKLMNOPQRSTU
1
Instructions (AFTER YOU MAKE A COPY OF THIS SPREADSHEET)Control ValueURL
2
1. Log into Trello in the same browser you're viewing this spreadsheet inhttps://trello.com/
3
2. Enter your Trello App Key in cell B3. Visit URL in cell C3 and copy entry in "Key" fieldhttps://trello.com/1/appKey/generate
4
3. Enter you trello token in cell B4. Visit URL in C4, click "Allow", and then copy the output tokenhttps://trello.com/1/authorize?key=&name=Trello+Upload+Spreadsheet&expiration=never&response_type=token&scope=read,write
5
4. Enter ID of board that you want to upload to in cell B5. To view available boards get a list, use the option in the "Trello" menu in this spreadsheet
6
5. (NOTE: Optional if you populate list Names in column B of the Backlog Sheet) Enter ID of list that you want to upload to in cell B6. To view available lists, use the option in the "Trello" menu in this spreadsheet.
7
6. Populate the Backlog sheet with the entries that you want to upload. Only entries with nothing in column A will be uploaded.
8
7. Select "Upload Outstanding Backlog Items" from the Trello Menu in this spreadsheet.
9
8. Wait for script to complete - it should tell you at the end how many entries have been uploaded. Note: It will stop after 5 and half minutes, to stop the script from timing out. All entries that are uploaded will have "Completed" in Column A
10
9. Repeat steps 7 and 8 until all entries are uploaded.
11
12
If you love this spreadsheet so much that you can't help but want to reward the developer, then you can do so here:http://www.littlebluemonkey.com/tip-jar
13
14
Version History
15
V 2.3 - 2016-10-26Fixed error were script ended due to accessing Properties too many times in short period
16
V 2.4 - 2017-01-03Added ability to create List if it does not exist, and will do this even if there is no card name specified
17
V 2.4.1 - 2017-01-06When creating lists, add them to the end of the board.
18
V 2.4.2 - 2017-04-05Can now create cards that contain large amounts of data
19
V 2.4.3 - 2019-01-30Replaced deprecated UIAPP with HtmlService
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