Yep - this is how that script approaches the integration challenge; it assumes you want all of the fields. But who really cares if it pulls too much information?
Well, you now have two reasons to do the following:
- Since the free script you found pulls in all of the data, let’s assume you have that working in a sheet tab named “RawData”.
- Given the requirement that you don’t need all of the data fields for analytical purposes, simply create another sheet in the same spreadsheet document named “VizReadyData” and use spreadsheet array functions to pull over the fields that you actually need.
- Given the requirement to order the fields specifically, establish your array formulas such that they place the columns in exactly the order you want.
By doing this, you will have a VizReadyData sheet with exactly what you want.
The formula for pulling records from one column in RawData to another column in VizReadtData is likely to be ArrayFormula() which need only exist in the first cell of each column in the VizReadyData sheet. For example, if you wanted column A in RawData to be updated to column G in VizReadydata, this is probably the formula you would place in the first cell of VizReadyData (i.e., A1).
ArrayFormula(VizReadyData!A2:A = RawData!A2:A)
Rinse-repeat for all the columns you need and you should be ready to perform your dashboard activities.