How to Populate Your meerakts AI TableMeerakts AI provides various methods to add data to your tables, enabling you to create comprehensive datasets for analysis, enrichment, and research. Whether you’re importing existing data, searching the web, or exploring entities, Meerakts AI offers flexible options tailored to your needs.
Importing Data from CSV FilesThe CSV Import tool allows you to upload data from existing CSV files directly into your meerkats AI table.How to Use CSV Import:
Click on: ‘Add data’ button
Upload Your CSV: Choose the file you want to import.
Map Columns: Match the CSV columns with your Meerakts AI table columns.
Save and Import: Your data will be imported
Good Use Cases:
Importing large datasets quickly.
Transferring existing spreadsheets into Meerakts AI for enrichment.
Tips:
Ensure your CSV columns match the column types in your Meerakts AI table for seamless importing.
Select Google SERP under integrations tab.Enter your search query and set the location to scrape the data from SERP. Import listicles of top products, recently funded startups, blog articles and more.How to Use Google Search:
Click on: ‘Add data’ button.
Set search query: For e.g.: “Latest funded AI startups.”
Set location: Optional, and to be used if you want to import SERP data for specific regions.
Save and import : Data will be scraped and imported to your table.
Good Use Cases:
Building a list of potential clients in the tech industry.
The Building Blocks of Your meerkats AI TablesColumns are the foundational elements of your meerkats AI tables. They provide structure, organize your data, and define the specific information you want to capture for each entity—whether it’s a company, individual, or news article. Understanding how to configure columns effectively is key to unlocking the full potential of meerkats AI’s AI-driven capabilities.
Meerkats AI makes it easy to create and customize columns according to your research or data analysis needs. Each column can be tailored to ensure your data is captured accurately and efficiently.
There are two ways to add your column:
One is to click on the ’+’ icon. Only recommended if you want to set up a column manually.
2. The second way to create a column is by clicking on ‘AI assistant,’ and describing your task,.The AI assistant will set up everything for you. E.g.: “Find the CEO of the company.” This is recommened only to create AI columns and formulas.
Column Name: Choose a clear and concise name that reflects the specific data point you want to collect. This makes it easier for AI to understand and populate the relevant information.
Examples:
“Company Name” for the company’s full legal name
“Recent Funding Round” for the latest investment stage
“Contact Email” for a designated person’s email address
Column Format: Select the format of the data you want to capture. Meerkats AI offers various data types, such as:
Single-line text: For short entries (e.g., job title, company name)
Long text: For more detailed information (e.g., company description)
URL: For web addresses (e.g., LinkedIn profile, company website)
File: For uploading documents, PDFs, or images
Single-select: Choose one option from a predefined list (e.g., industry)
By understanding how to create and configure columns effectively, you can transform meerkats AI into a powerful data analysis tool tailored to your unique needs. These column types allow you to structure your data in a way that fits your analysis goals.Meerkats AI’s AI capabilities bring your columns to life, enabling them to automatically gather and enrich data based on your specific needs.
Input Column: Use this column to enter data manually, giving you control over inputs, especially useful for custom fields.
Formulas: Use this column to apply spreadsheet formulas on the data set.
AI Column: The AI column will actively populate the data by using selected tools. The tools available for AI column are:
Meerkats agent: Performs a web search to fetch the asnwer for your query.
Third party apps: Extract contact information, sync CRM and outreach tools.
AI Scrapers: Pulls specific information from a given URL.
Row expander: Extracts information from one sheet and writes to another sheet.
Instructions Only: Synthesizes an answer using a Large Language Model (LLM) based solely on inputs from other columns. This tool is perfect for generating summaries, performing analysis, or crafting text content based on existing data in your table.
These tools allow you to harness the full power of AI to extract, synthesize, and enrich data, turning your Meerkats AI tables into dynamic sources of actionable insights.
Connecting columns: To provide context to the AI use ’@’ in your prompts to refer to other columns as inputs, you guide the AI to use this data when generating outputs. E.g.: “Find the ceo of @company name.”
By clicking on the columns count tab at the bottom of the table view, you can toggle the columns on or off individually to hide the columns. To unhide columns, click Show All or toggle the columns on or off.
Choose between Equal to, not equal to, greater than, greater or equal to, less than, less or equal to, is empty, is not empty and enter a value in the field.