TL:DR How can I add multiple files to my Gmail step using Web Content Link?
I'm trying to automate my entire invoice creation workflow. Broadly speaking my Zap:
- Triggers on me uploading a new file (screenshot of my timecard) to a specified Drive Folder
- Creates a copy of an invoice template I’ve specified in Google Sheets
- Writes necessary info to that sheet
- Creates an email with invoice sheet AND two screenshots (total of 3 files)
I’m 95% there, but I’m stuck on how to attach multiple files in my Gmail step. I’m using an API request step to get the correct files. But I don’t know how to ‘separate’ these in order to add multiple attachments/web content links in my Gmail step. I feel like I need to loop and/or transform this data - but I’m not sure
- Google Drive API request Configuration
- Google Drive API request Test
Thanks in advance for any and all help