id like to build the following
- trigger: new excel file in folder
- action: add table from new excel file to an existing Google sheet
- action: remove duplicate rows from merged tables in the Google sheet
- action: highlight to me which rows have changed or which rows are new in the Google sheet
im new to Zapier so any help would be highly appreciated!
What data point would be used to determine the duplicates?
@Troy Tessalone - it will be the first column, which is a links to unique LinkedIn profiles
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.
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?
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.