Merge older data with your new data, de-dupe the results and send it back to the same Google Sheet and save hours of data entry.
- Authorize your Google account in Parabola by signing in.
- Search for the name of the spreadsheet containing your existing data.
Use a Rename step in Parabola to rename columns so that data from different sources matches. For example, in one table a column might be called F Name and in another table it might be called First Name. Use a Rename step on F Name to call it First Name so that the column header matches in both tables.
Tick the checkbox to match up column headers by column names rather than order. For example, if Table 1 has First Name in column 3 and LinkedIn URL in column 12, and Table 2 has LinkedIn URL in column 3 and First Name in column 12, half of First Name would be merged with half of LinkedIn URL in both columns, creating a data mismatch. Ticking Stack Tables will stack data based on column header instead, removing this issue.
De-Dupe requires an exact match. For example, John Smith and John A Smith would leave two records, because the “A” causes it to be a unique record.
The effect is merging the old data with the new data, removing any potential duplicates, and sending the merged data back to the same spreadsheet you started with.