SMBcrm Announces Enhanced Google Sheets Features

Managing Your Data Just Became Easier: SMBcrm Announces Enhanced Google Sheets Features

We’re excited to share improvements to our Google Sheets capabilities. In our ongoing commitment to improving your user experience, we’ve added new Action Types to streamline your workflow: “Create Multiple Spreadsheet Rows” and “Update Multiple Spreadsheet Rows”.

Create Multiple Spreadsheet Row(s)

With this enhancement, you can efficiently insert new rows of data beneath existing information in your Google Sheets. This feature simplifies the process by allowing you to send data directly to a Google Sheets document, eliminating the need for third-party integrations. All you need to do is synchronize your Google account with our system and choose the desired sheet from your Google Drive. Our intuitive user interface makes it easy to send data to your sheet in a few steps.

Here are some use cases for Create Multiple Spreadsheet Rows:

  • Batch data entry into specific worksheet
  • Importing data in bulk from external sources

How it Works

Create Multiple Spreadsheet Rows

This is how you can use the new feature:

  1. Select “Create Multiple Spreadsheet Row(s)” from the Action dropdown in your account.
    Integrated Google Accounts
  2. Select the spreadsheet and worksheet in which you want to make the changes.
    Spreadsheet and worksheet
  3. Choose the start and end column in the worksheet. Our system considers the sheet’s first row as the header row, and each column label is based on the header values.
    Columns in worksheet

Need to update the headers in the sheet? Click the “Refresh Headers” button to fetch the most recent header value from the sheet.

Update Multiple Spreadsheet Row(s)

This action allows you to modify existing data within a specified range based on a unique identifier. Think of it like a bulk editing tool.

Some use cases for Update Multiple Spreadsheet Rows include:

  • Bulk editing of product prices or inventory levels
  • Updating customer records with the latest contact information

How it Works

Update Multiple Spreadsheet Rows

This is how you can use the new feature:

  1. Select “Update Multiple Spreadsheet Row(s)” from the Action dropdown in your account.
    Integrated Google Accounts
  2. Enter the row number where you want to update the worksheet.
  3. Choose the start and end column in the worksheet. This ensures that your data is accurately mapped to the correct columns in the sheet and that your workflow aligns with the latest sheet configurations.
    Columns in worksheet

With these new features, SMBcrm offers you the tools to ensure the accuracy of your data workflows, improve your automation processes, and maintain your retail standards. Upgrade your SMBcrm experience here.

In case you missed it: For more product updates, check out our recent article on Enhanced Call Configuration.

SMBcrm ©2024 | All Rights Reserved