Before you begin: This Support Guide shows you how to import data from TapClicks to Google Sheets using an add-on.
Install the Add-on
1] From a Google Sheet, on the top menu click Add-ons-->Get add-ons.
2] At the top of the Google Workspace Marketplace, enter "TapClicks" in the search box and hit Enter.
3] You should only see one result: the TapClicks add-on. Click it.
4] On the next screen, click the Install button.
5] When the permission popup appears, click Continue.
6] If you have to choose a Google Account, do so.
7] When the allow access popup appears, click Allow at the bottom.
Use the Add-on
8] To launch the add-on, click Add-ons-->TapClicks-->Show Sidebar
9] The add-on appears on the right side.
10] Enter the instance in the Instance textbox. The instance is a URL with this format: <instance_name>.tapclicks.com.
11] Enter your account email and password.
12] Click Login.
13] The add-on has several inputs (see image below).
14] Choose your data source from the Data Sources dropdown menu.
15] Choose your data view from the Data Views dropdown menu.
16] Decide how you want to group the data and make the selection from the Group by(s) dropdown menu. You can make more than one selection.
|NOTE: Fields selected as Group bys are automatically added as columns in your Google Sheet. Therefore, there is no need to select them in the Columns menu as well (step 18).|
17] You can remove a Group by selection by clicking the "x" to the right.
18] Decide what columns you want to import and make the selections from the Column(s) dropdown menu. You can make more than one selection.
19] You can remove a Column by selection by clicking the "x" to the right.
20] Select the data range you want to import from the Date Range dropdown menu. If you don't want one of the predefined selections, choose Custom and enter your preferred range
21] If you chose a Group by field (step 16) that is date-based, a Time Grouping menu will appear. Choose an option for your Group by field.
22] Click the Options arrow.
23] On the Options menu, choose a row limit, a sort by column (if you chose more than one) and a direction for the sort from the respective dropdown menus.
24] If you change your mind, click the Clear Sort button at the bottom and start over.
25] To filter the imported data, click the Add Filter button.
26] From the Select Field dropdown menu, choose a field to filter the imported data.
27] Select a filter attribute from the Select Attribute dropdown menu. Depending on the field selected, there may not be an attribute to select.
28] To remove the filter, click the "x" to the right.
29] To add more filters, repeat steps 25 - 28.
30] Click the down arrow to the right of the Insert Data button.
31] Select one of the three options:
- Insert Formula: inserts the formula represented by the selections you made
- Insert Data: inserts the data (beginning where the cursor is)
- Save Query: saves the query (you will have to give the query a name)
32] Click the Insert button. It will either say Insert Formula, Insert Data or Save Query, depending on your selection above.