1. New Query Rows function is now available.

    This function will query Salesforce for each row of data filling in blank cells with values from Salesforce. You’ll need to map your columns before you can run this function:

    It will use the values that are filled in to create a query to pull values that are empty. Clear the corresponding mapping to not use values from a specific column.
    This functionality can also be used in a Flow Step to let your users query rows by simply clicking on the Run Flow button. The admin needs to first set up the Flow Step mappings correctly.
  2. Refresh All function will now produce a user-friendly progress dialog box showing the Refresh All operation progress:
  3. It is now possible to set up your workbook to refresh all sheets automatically when it is opened. If the user is not automatically logged in – the refresh will happen after the first login: