Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I add new excel files to google sheet and filter which ones are new or updated?

Hello

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! 

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.

 

 

Terms & Conditions