DataMate is a powerful Google Sheets™ add-on designed to streamline data management, contact organization, form creation, and template handling for businesses and individuals. With an intuitive custom menu, DataMate simplifies complex tasks, enhances productivity, and integrates seamlessly with Google Workspace™ tools like Gmail™ and Google Drive™.
Key Features:
Custom Data Management Menu
Access a user-friendly "DataMate" menu in Google Sheets™  with options to save records, reset inputs, create new datasets, and manage contact sheets. The menu includes sub-menus for FormBuilder, AddressBlock, and Templates, making it easy to navigate and perform tasks efficiently.

Data Management and Organization  
Save Records: Copy data from an "Input" sheet to "Data," "Update," and "Log" sheets with precise mappings, preserving formats and formulas.  

Reset Input/View: Quickly reset input fields or refresh the "View_Print" sheet for clean data presentation.  

New Dataset Creation: Generate essential sheets (Input, View_Print, Log, Update, Data) with predefined formatting, formulas, and hyperlinks for seamless data tracking.  

Add Input Sheet: Duplicate and rename input sheets, automatically linking them to a "Dashboard" sheet for easy navigation.

Contact Management (AddressBlock)  
Contact Sheets: Create and manage "contacts," "Address," and "NewContact" sheets with predefined headers for names, emails, phone numbers, and addresses.  

Import Gmail ™  Contacts: Upload CSV files to map contact data into the "contacts" sheet, supporting up to 2000 rows.  

New Contact Entry: Add new contacts via the "NewContact" sheet, with data automatically integrated into the main contacts list.  

Edit Contacts: Use VLOOKUP and XLOOKUP-like formulas to update contact details by name or company, with data validation for accuracy.

FormBuilder for Dynamic Forms  
Form Creation: Build custom forms using the "FormSetup" sheet, supporting field types like text, email, number, checkbox, radio, file uploads, signatures, and checkout tables.  

Preview and Submit: Preview forms in a web interface, validate inputs, and save responses to specified sheets and cells.  

File Uploads: Store uploaded files and signatures in Google Drive™ folders, with URLs saved in the spreadsheet.  

Email Notifications: Send automated email notifications upon form submission, including field data and checkout details.

Template Management  
Prebuilt Templates: Set up templates for Inventory, Weekly Timesheets, and Purchase Orders with automated formatting and formulas.  

Invoice and Timesheet Submission: Save and update invoices or timesheets, copying data to designated sheets for tracking.  

Customizable: Tailor templates to your needs with flexible mappings and data validation.

Email Integration  
Mail It Sidebar: Send formatted spreadsheet ranges as HTML tables via Gmail™ to selected contacts or all contacts in the "contacts" sheet.  

Automated Emails: Notify users of dataset creation or record saves with customizable email templates.

Advanced Features  
Dynamic Formulas: Use VLOOKUP, XLOOKUP-like functions, and CONCATENATE for automated data retrieval and formatting.  

Data Validation: Ensure data integrity with validation rules for contact selection, email formats, and form inputs.  

Sheet Linking: Create hyperlinks between sheets and a central "Dashboard" for quick access to datasets.  

Scalable Data Storage: Support large datasets with up to 800 columns and 10,000 rows in the "Data" sheet.

Why Choose DataMate?
DataMate empowers users to manage data efficiently within Google Sheets™, eliminating the need for multiple tools. Whether you're tracking inventory, managing contacts, creating forms, or sending professional emails, DataMate offers a comprehensive solution. Ideal for small businesses, freelancers, and teams, it saves time and enhances organization with minimal setup.
Get Started
Install DataMate from the Google Workspace Marketplace™, access the "DataMate" menu in Google Sheets™, and start managing your data with ease. For support, visit our help page linked in the add-on.