About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Google Sheets bank transaction Zap fails with "file is too large" error

  • 14 September 2023
  • 1 reply
  • 74 views
J

Hello All, 

Novice here. I am looking for what a way to zap bank transactions (either in real time or using a CSV each month) into a Google Sheets spreadsheet file I use for accounting with built in formulas and whatnot. I can’t seem to figure out what I would think should be simple. 

For starters, I do not have any accounting specific software (like Quickbooks/Wave/Xero) and do not want to pay for them if I don’t have to. For my accounting, within my Google Sheet spreadsheet, I usually just manually enter the date, expense category, description of expense, and then amount. There are formulas on other sheet pages that give me totals for categories, months, etc. I’m a small business owner and there are not tons of expenses per month and this usually takes me 20-30 mins each month but if I can simply zap it then even better. 

I tried to go the route whereby I get a CSV from my bank (US Bank) and put it into a Google Drive folder which is the trigger. The next step would be to use the Utilities formatter to upload a CSV. The issue I have is that the CSV is over the allotted 150k (2,398 bytes with only 23 rows and 5 columns) and therefore get the error message that my file is too large.

I can convert the CSV into an excel spreadsheet but I am not seeing a way to extract the data to then update the master Google Sheet accounting file. 

 

Thanks.

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

SamB
Rank
Userlevel 7
Badge +11

Hi there, @Joski. Welcome to the Community! 👋

Perhaps you could try using an app like Split CSV to split the large CSV into smaller files? You’d have one Zap that splits the files, then another Zap that uses the Split CSV Split Completed trigger to run when each of the smaller files created. In that second Zap, you’d have a  Formatter (Utilities > Import CSV) action to import the data and then use a Create Multiple Spreadsheet Rows (Google Sheets) action to add the information into the Google Sheets spreadsheet.

Do you think that would be a viable option? If you give that a try and run into any issues please let us know - happy to help further! 🙂

Terms & Conditions