ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
@dropdown
2

INSTRUCTIONS:

1. Make a copy within your own drive and do the following:

— Replace the Spreadsheet URL in the formula on the IMPORTRANGE function on the 2023 calendar sheet (cell A2)
— Go to the "2023 calendar" sheet → Go to cell A2 → Copy the URL from the "Share" button on the top right of the file → Paste the URL wherever you see one (check the image below)

This will pull the data from your current sheet and not the original template you copied.


2. Need to add new social networks? Make a copy of one of the existing spreadsheets and do the following:

— Go to the "Content Pillars" column → Right click → Click on Data Validation → Change the pillars based on your own content pillars
— Go to the "Content Format" column → Right click → Click on Data Validation → Change the formats based on the target platform (E.g., Single Post for Meta's Threads → [THR] Single post])
— Go to the "2023 Calendar" sheet → Go to cell "A2" → Copy the formula marked in red below → Paste it before the "SORT" function → Replace it with your spreadsheet's URL → Replace the Sheet name marked in pink with your new sheet's name

E.g., "IMPORTRANGE ("Spreadsheet URL", "Sheet name!A2:L);

This will import all the posts from the new sheet you create onto the 2023 calendar sheet. And the [THR] tag will help you identify which network it's for.

NOTE: If you're changing the name of any sheet or adding more columns, adjust the formula in the cell you see below. It'll make sure none of the posts are missed and everything get pulled.

3
4
5
6
7
8
9
10
11
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