Update records in Google Sheets

You can now update records in a Google Sheet based on your specific criteria. Here's how it works:

Step 1: Choose the Sheet

• Select the Google Sheet and worksheet where you want to search data.

• Enable the ‘First row contains...’ checkbox if your sheet has column headings.

Step 2: Add Search Criteria

• Define the criteria to search for data in the Google Sheet.

• You can add multiple conditions using “ANY/ALL” operators.

Step 3: Update the Data

• Map the columns you want to update with the appropriate value or variable.

• The column names from your sheet will appear in the dropdown for easy selection.

This feature streamlines record updates and ensures you can manage your data efficiently.