Matching values between two sheets in Zapier for data synchronization

Question

What i Want to Achieve Compare two columns from two different worksheets:

Sheet 1: 129W (Column AB) trigger

Sheet 2: Women (Column Y) lookup spreadsheet row

If the value in 129W exists in Women, add a note in 129W (e.g., in a check column).

If the value in 129W does not exist in Women, create a new row in Women with the data from 129W.( row should be created (next row) after decting the latest row ) iteration should be there to matches values from 2nd row till the values exist in that column

i want zapier to detect the whole column and match values according to it , but insted it is only taking up the one cell or a row from the lookup column

JammerS · Answer

Hi ​@EternalNik,Welcome to the Community.Zapier doesn't support comparing entire columns simultaneously, as it works on a row-by-row basis. However, you can set up a multi-step Zap to loop through each row in one column and check for a match in another worksheet. The process involves triggering new or updated rows, using a lookup step to find matches, filtering based on the result, and adding unmatched rows to the second sheet. A second Zap can be used since Zapier lacks a built-in way to annotate matched rows. This approach consumes tasks quickly, so a more advanced solution like Python with the Google Sheets API might be more efficient for large data sets.Feel free to ask if you need further help setting this up or have any other questions.

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded