A temporary fix using the code module (shoutout to Mo for the suggestion, still hoping a cleaner, native solution could be found):
First add the code piece as a step:
Copy the following code into index.ts, change inputs.update_row_range to inputs.YOURKEYNAME
export const code = async (inputs) => {
const updatedRowRange = inputs.updated_row_range;
if (!updatedRowRange) {
console.log("No updated row range provided");
return null;
}
const firstNumberGroup = extractFirstNumberGroup(updatedRowRange);
if (firstNumberGroup) {
const extractedNumber = parseInt(firstNumberGroup, 10);
console.log(`The first grouping of numbers after 'A' is: ${extractedNumber}`);
return extractedNumber;
} else {
console.log("No numbers found after 'A'");
return null;
}
};
function extractFirstNumberGroup(inputString: string): string | null {
const match = inputString.match(/A(\d+)/);
return match ? match[1] : null;
}
It should look like this:
Click add npm package at the top right and add: @types/node
Add a key-value pair to get the row range from the previous step, I chose updated_row_range as the key, the value has to be the updatedRange value from the Google Sheets step:
And voila, you should have an integer as the output which you can use to locate the row that was updated.