Hey ​@RyanForsythe1979,

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 ​@Sparsh from Automation Jinn 

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.

Hey ​@RyanForsythe1979,

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!

​@Sparsh from Automation Jinn 

The csv has less than 170 rows.

Hey ​@RyanForsythe1979,

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!

​@Sparsh from Automation Jinn 

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).

Hey ​@RyanForsythe1979,

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!

Hi ​@RyanForsythe1979 

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 ​@Sparsh from Automation Jinn I’ll try that on Monday. Have a good weekend.

Hi ​@Sparsh from Automation Jinn 

Got it working! Adding the Get Many Spreadsheet Rows step done the trick. 

Thanks for your help.

That’s great news ​@RyanForsythe1979! 🎉 Thanks for coming back to confirm that Sparsh’s suggestion of using a Get Many Spreadsheet Rows action for Google Sheets did the trick - nice one ​@Sparsh from Automation Jinn! 🙌

Please do reach back out if you need any more help from the community. Until then, happy Zapping! 😁⚡