Connect Wallabi.ai to Google Sheets to analyze your revenue and marketing data right where you work. No need to switch between tools or learn a new system – just add powerful analytics to your existing spreadsheets.
This guide covers installation, basic setup, and how to use Wallabi's analytics features in Google Sheets. Let's get your data flowing.
What can I do to prepare my data for analysis?
Use Clear Headers: Ensure each column has a unique, descriptive header in the first row.
Consistent Formatting: Keep data types consistent within columns (e.g., all dates in the same format, all numbers without text).
Avoid Merged Cells: Merged cells can disrupt data processing; split them into individual cells.
Model for Analysis: Organize your data in rows and columns, with each row representing a unique record and each column representing a distinct field.
One table per sheet: Ensure each Google Sheet contains only one table per sheet/tab, with clearly defined headers and no unrelated data outside the table.
What do I need before connecting to Google Sheets?
You will need Google Chrome, the Wallabi for Chrome browser extension, a Google or Microsoft oAuth email address, and a Google Workspace account. For more details on getting started with Wallabi, see here.
How do I connect to Google Sheets?
From your insight feed, select the hamburger menu in the top left corner, then select "Data" to navigate to your Data Management tab.
Select "Add data" at the bottom of your list of data sources, then select the data source you want to connect.
This opens a new dialogue prompting you to authenticate your Google Drive account and select a Google Sheet from the menu.
Select the tabs you wish to import and click "Add selected sheets."
That's it! Wallabi will start analyzing your data.
How often does the data sync between Google Sheets and Wallabi?
Data is synced every 30 minutes by default.