Replace XLSX with Microsoft Excel

  • 1 March 2023
  • 1 reply
  • 20 views

Hi,

 

I need help making a Zap for weekly reports that send out to my Gmail as a xlsx attachment. I receive 60+ files every Monday. I currently have a zap that takes the attachments and uploads them to my drive.

 

I would like to merge all of these files under the header row into a single master file.

 

Can you please help me make a Zap for this? I can’t figure it out.


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 +11

Hi @Katana!

I understand most of the workflow as you’ve described it but I’m not 100% clear on this:

I would like to merge all of these files under the header row into a single master file.

Can you elaborate a bit on this? How does that merged spreadsheet relate to all the individual ones you get? 

Thanks!