Skip to main content

I am currently using the Gmail application to pull an xlsx file from an email I receive, except the attached spreadsheet includes 2 sheets. The Format app is unable to import it as a csv file because of this, and I only need one of the two sheets. Is there a way to split the spreadsheet into two separate csv files, one for each sheet, so I can work with them separately?

This is the error message I receive from the formatting app when I attempt to test run it.

Hi @Ryan Tripi 

Good question.

This is possible using the GSheets API Request Zap action.

Using app APIs is an advanced approach.

Let me know if you need help, I’m a Certified Zapier Expert: https://zapier.com/experts/automation-ace

 


That would help if I could upload the spreadsheet to google sheets, but right now when I try to create a spreadsheet using the xlsx file, it gives me this error. 

 


@Ryan Tripi 

Try this Zap action: GDrive - Upload File

 


Looks like that worked, thanks


That’s fantastic news @Ryan Tripi! Really pleased Troy was able to assist here. 😁🎉

Happy Zapping! ⚡️


Reply