Question

Merage daily csv/ excel file to one master google sheet

  • 21 March 2022
  • 1 reply
  • 339 views

Hi Zapier family

I have got an daily email with attachment csv/excel file with the same format (around 8000 rows on some days). Is it possible to download the daily reports to merge to a master google sheet daily?  
The csv file is over 150K

Thanks


Anthony


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +12

Hi @Anthony Chu  Sorry for the delay in getting you some thoughts on this.

Although it’s possible to import a csv into a Google Sheet using Zapier (check out this help doc for more info) it only works with files under 150K. If you’re able to convert the csv into another type of file (eg a new Google Sheet) then you could use Transfer to then move that data into the existing sheet. Transfer has a limit of up to 25,000 records per Transfer run, so it should be able to handle the size of file that you have.