From Airtable to Google Sheets (public example for medium blog)

	A	B
1	About this spreadsheet
2
3	This spreadsheet contains data from Airtable.
4	Data is automatically synced via Airtable's API at midnight every night. To manually re-sync, choose [Airtable to google sheets sync] in the file menu above.
5
6	The data here is intended to be imported into a business intelligence product like Google Data Studio.
7	If you prefer using Google Sheets to visualise your data, each column of data is a named range, to make it easier to refer to in Google Sheets formulas.
8
9
10	Control panel
11
12	Tables to sync:
13	Table name	Airtable view ID
14	Table 1	viwXXXXXXXXXXXX
15	Table 2	viwXXXXXXXXXXXX
16	Table 3	viwXXXXXXXXXXXX
17
18	If any of the airtable table names change, the automatic syncing from Airtable to this sheet will break. Any table not mentioned in the above list will not be synced.
19
20	Want to add more tables or delete some of them?
21	1. Add to or remove cells from the yellow range above
22	2. Go to [Tools] -> [Script editor] in the file menu and update the cell references (look for //UPDATE CELL RANGE HERE)
23	For example, if you add two new tables to the yellow range above, then the cell reference should be "A14:B18", not "A14:B16".
24	3. Make sure each table represented above has a dedicated sheet, with the same name. The sheets should EXACTLY match the table names in the yellow range
25
26
27	Then, make sure
28	If you're changing the tables to sync on this control panel, and you add or remove a few cells, .
29
30	Base ID, API key, view ID etc is all stored in the script editor: [File menu] -> [Tools] -> [Script editor]
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