Note: This guide provides a quick overview of how to get started with using the Google Sheets Add-on. If you'd like detailed step-by-step instructions for using the Google Sheet Add-on, see How to Import Data From TapClicks Into Google Sheets.
Step 1 Install the Sidebar Add-on
1] In a Google Sheet, go to Extensions-->Add-ons-->Get add-ons.
2] Enter TapClicks in the search box.
3] Click Install.
Step 2 Display the Sidebar Add-on and Login
1] Go to Extensions-->Add-ons-->TapClicks-->Show Sidebar.
2] Enter your TapClicks instance.
3] Enter your email and password and click Login.
Step 3 Specify Import Data
1] Choose your data source.
2] Choose your data view.
3] Choose one or more groups.
4] Choose one or more columns.
5] Choose the date range.
<h2id="h_01hhj1s89q83h12b0tr6ae1v67" id="h_01HHJ20HV3FEYCA6FM58TTDZ6G"> Step 4 Specify Options for Displaying the Imported Data
1] Click Options.
2] Choose the row limit.
3] Specify sort by and direction.
Step 5 Apply Filters to the Imported Data
1] Select a field to filter on.
2] Select an attribute to filter on.
3] Click Add Filter to apply more filters.
Step 6 Finalize the Process
1] Either click Insert Data.
2] Or click Insert Formula.
3] Or click Save Query.
Step 7 Manage Queries and Set Refresh Settings
1] Click the menu icon in the upper left of the sidebar.
2] Click Manage Queries to use, edit, or delete saved queries.
3] Click Refresh Settings to set the automatic data refresh frequency.
| NOTE: This only works for inserted formulas and not inserted data. |
</h2id="h_01hhj1s89q83h12b0tr6ae1v67">