Google Sheets Add-On
Overview
Retrieve Data Easily: The ReportDash Add-On for Google Sheets™ empowers users to seamlessly pull data from various external sources, including Facebook, Google, LinkedIn, Twitter, TikTok, Bing, and more, directly into Google Sheets™.
Flexible Data Manipulation: This add-on goes beyond data retrieval, offering users the flexibility to blend/group data and perform a diverse range of computations, ensuring dynamic and comprehensive analysis.
Intuitive Table Creation: With the addon, users can effortlessly generate one or more tables within a Google Sheets™ Spreadsheet, streamlining the organization and presentation of their data.
Versatile Table Functionality: These tables can either fetch data from an external source or consolidate and organize data from any existing table(s), providing a versatile solution for various data management needs.
Ample Data Capacity: Each table boasts the impressive capacity to accommodate up to 100,000 rows of data, ensuring that users can handle substantial datasets with ease.
User-Friendly Design: The ReportDash Add-On for Google Sheets™ is intentionally designed for non-programmers, offering a user-friendly experience that doesn't require coding expertise.
Smart Guidance: Auto-suggestions are provided to guide users along the way, ensuring a smooth and intuitive experience during data manipulation and analysis.
Explore Further: Check out the next tabs for more in-depth details on the features and functionalities offered by the ReportDash Add-On.
Need Assistance? When in doubt, don't hesitate to drop us a line at support@reportdash.com. We're here to help!
Creating Table
Data is incorporated into the spreadsheet through the creation of tables. Each table is distinguished by a unique title, adhering to specific criteria. Table titles should commence with lowercase letters, may include alphanumeric characters and underscores, and must not include any spaces.
There are two distinct types of tables:
Data Fetch Tables: These tables are designed to retrieve information from external sources.
Computed Tables: These tables involve the performance of computations based on specified criteria or calculations.
Modifying Table
Upon creating a table, a sequence of operations can be applied to it, executed in the order defined. The diverse operations include:
Creating a New Column: Add new columns to enhance data representation.
Modifying Column Properties: Tailor column properties such as title and data type to meet specific requirements.
Filtering: Apply filters to refine and focus the displayed data.
Slicing: Extract specific subsets of data for detailed analysis.
Sorting: Organize data for clarity by sorting based on chosen criteria.
Reordering Columns: Adjust the order of columns to enhance the visual presentation of information.
Adding a Summary Row: Include summary information for quick insights.
Certain operations may necessitate referencing columns or individual cell values. Column references follow the format tableTitle['Column Name'], while cell values are referenced as tableTitle['Column Name'][rowNumber].
Tables are inherently ordered, executing in the sequence displayed on the sidebar. To modify this order, simply drag and rearrange tables as needed.
Furthermore, operations can reference all columns or cell values from tables positioned above the current table, facilitating comprehensive data manipulation and analysis.
Explore the detailed explanations of each table operation below.