Hi,
I’m trying to set up a workflow in Make.com to process rows from a Google Sheet, but I need to skip the header row and retrieve the previous row’s data for each subsequent row. Here’s what I’m attempting to do:
- Use a Google Sheets - Search Rows module to find the previous row’s data.
- The sheet has a header row, so for the second row of data (row 3 in the sheet), I need to get row 2’s data, and so on.
- I’ve set up a variable ‘CurrentRowNumber’ to keep track of the current row being processed.
- I’m trying to use an if statement in the Search Rows module to handle this logic, but I’m encountering issues with the syntax and execution.
- I’ve also attempted to use a Router to separate the logic for the header row and subsequent rows, but I’m still facing challenges.
Can somebody provide a working solution to retrieve the previous row’s data for each row, while properly handling the header row and the second row of data (which should not have a ‘previous’ row to retrieve)?"
