Back

Copy matching data from one Google Sheet into another

Target sheet updated from a source sheet, with matched, added, and unmatched rows counted

OpsAnalystsEAsEveryone
Prompt

Open my source sheet [source sheet link and tab, e.g. the weekly actuals export] and my target sheet [target sheet link and tab, e.g. the budget tracker]. Match rows using [key column, e.g. full name, email, or order ID], ignoring case and extra spaces. For each match, copy [columns to bring over, e.g. actual spend and status] into the matching target columns. When a target cell already has a value, [overwrite rule, e.g. only fill empty cells, or always replace]. Rows only in the source: [add them to the bottom of the target, or list them for me]. Don't edit the source sheet or any target columns I didn't name. If a key matches more than one row, leave it alone and flag it. If you're unsure which columns correspond, stop and ask first. Finish with a summary: rows matched, cells updated, rows added, and a list of unmatched or flagged keys.

Works withdocs.google.com