1. Incremental Sales Data Sync
Data AnalystBackground
A sales team generates a new export file every day. The analyst needs to add only the new sales records to the master annual report.
Problem
Manually copying and pasting new rows daily is prone to errors and duplication.
How to use
Set the cursor mode to 'primary-key', select the 'id' column, and input the last processed ID (e.g., 5).
cursorMode: primary-key, cursorColumn: id, lastCursorValue: 5Outcome
The tool appends all records with an ID greater than 5 to the master workbook and provides the new maximum ID in the output JSON.