I have a zap which is on a daily schedule to download a CSV file (via Easy FTP) to populate a Zapier table. This was working perfectly until the CSV became larger than 1MB. Now the Files by Zapier step fails…
File exceeds maximum size of 1 MB.
Is there a workaround for this?
Best answer by Sparsh from Automation Jinn
Hey
Try to use Trigger Zap from CSV action of Files by Zapier. You would need two zaps and webhook to achieve it.
Here is a helpful article about it here- https://help.zapier.com/hc/en-us/articles/28030319732749-Trigger-60-000-rows-from-a-single-CSV-file-using-Files-by-Zapier.
For any feature request, contact Zapier support here- https://zapier.com/app/get-help
Alternatively, once you have the data in Google Sheets you can use Get Many Spreadsheet row(upto 1500 rows) to send data to Zapier Tables
Hope it helps!
+6Hey
Are you on a free plan because I see a limit of 100 MB for uploading files and 4MB and 60000 rows limit for triggering by CSV in Files by Zapier? See more about it here- https://help.zapier.com/hc/en-us/articles/8496288813453-Send-files-in-Zaps
Some of the workarounds you can try is uploading it to Google drive or OneDrive and triggering it from there. Hope it helps!
Hi
No, I’m on the Pro plan and the CSV is only 1.2MB. The error messages says 1MB limit but the Pro plan should allow for 4MB.
+6Hey
Which exact trigger/action are you using? Can you post the screenshots for us to have more context?
Also, is it under 60000 rows as well as it says 4MB and 60000 rows for triggering Zaps from CSV rows. You can only trigger 1 CSV file every 30 minutes. See more about it here- https://help.zapier.com/hc/en-us/articles/28030319732749-Trigger-60-000-rows-from-a-single-CSV-file-using-Files-by-Zapier. Hope it helps!
+6Hey
I think this limit might be specific to this Line Items to CSV action in Files by Zapier. The 4MB and 60000 rows limits is for triggering by CSV and the 100 MB limits for sending files in Zapier in general. As said in the previous reply, you may want to look into workaround of uploading it in Google drive or One Drive to achieve your desired workflow. After that you can also use Trigger Zap From CSV Rows in another Zap to have larger limits. Hope it helps!
I can’t seem to be able to get round this.
I tried uploading the file to Google Drive and then created a zap to populate a zapier table when the Google sheet is updated. But I got this error...
“This Google Sheets step is pending because it returned too many results at once”
Surely there’s a solution, the csv is only 1.2MB
BTW I should also mention that the data needs to be imported into a zapier table as it’s being used as a knowledge source for a chatbot (to date a Google sheet cannot be used as a knowledge source).
+6Hey
Try to use Trigger Zap from CSV action of Files by Zapier. You would need two zaps and webhook to achieve it.
Here is a helpful article about it here- https://help.zapier.com/hc/en-us/articles/28030319732749-Trigger-60-000-rows-from-a-single-CSV-file-using-Files-by-Zapier.
For any feature request, contact Zapier support here- https://zapier.com/app/get-help
Alternatively, once you have the data in Google Sheets you can use Get Many Spreadsheet row(upto 1500 rows) to send data to Zapier Tables
Hope it helps!
+14Hi
The error indicates the Zap action for Tables - Line Items from CSV has a max file size of 1MB.
Do you need all of the columns from the CSV file?
Workaround likely includes uploading the CSV file to GDrive, then using GSheets Zap actions to grab the needed data.
NOTE: Looping Zap app has a max of 500 iterations.
Thanks
Hi
Got it working! Adding the Get Many Spreadsheet Rows step done the trick.
Thanks for your help.
+11That’s great news
Please do reach back out if you need any more help from the community. Until then, happy Zapping! 😁⚡
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
