Note: This guide provides a quick overview of how to use the Google Sheets Add-on. For detailed, step-by-step instructions, please refer to 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.
4] When prompted to allow access, click Allow.
Step 2: Display the Sidebar Add-on and Login
1] Go to Extensions→TapClicks→Show Sidebar.
2] Click Login/Sign Up in the sidebar.
3] Enter your TapClicks instance into the textbox and click Continue.
4] When TapClicks opens, click Accept to authorize Google Sheets to access your data.
Step 3: Select Data to Import
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.
Step 4: Customize Data Display Options
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 additional filters.
Step 6: Finalize the Process
1] Click Insert Data, Insert Formula, or Save Query to finalize the process.
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. |