How do I add new excel files to google sheet and filter which ones are new or updated?

Hi @Ramz 

What data point would be used to determine the duplicates?

Hi @Troy Tessalone - it will be the first column, which is a links to unique LinkedIn profiles

@Ramz 

Where is the Folder being used in the trigger step? (e.g. in GDrive)

Is it an Excel file, a GSheet file, or a CSV file?

action: highlight to me which rows have changed or which rows are new in the Google sheet

This can’t be done via Zapier.

You could instead include a timestamp in a column to help you understand when data was added.

Thanks @Troy Tessalone 

It’s actually a CSV file, I tried using Formatter but there is a size limit (<150k...)

The folder is in Gdrive

What is timestamp? Is that a formula in excel or gsheets?

Thank you! 

@Ramz 

How big are the CSV files?

How many rows are in the CSV files?

Error: CSV Import only supports file sizes < 150K

The Import CSV File utility only supports importing files that are 150 KB or less in size (around 1,000 rows of a 10 column CSV file). You'll need to split the CSV file into multiple files if it's too large.

You can try the Looping option for handling a CSV file so you can find else create records: https://zapier.com/apps/looping/integrations

NOTE: Looping has a 500 record limit.