Combining Google Drive Files and Airtable Attachment, to send one email with Mailgun

How To
,
1

Hi. I’m having issues with combining a list of files from 2 different output streams. What I am trying to do is the below:

  • There are a list of Google Drive share file links. Iterate through these, get the ID, download the file
  • Each report record in Airtable will have a GeneratedPDF. This should be downloaded as a file.
  • All the downloaded files from Google Drive, plus the generated PDF file in airtable should be combined to sent in one email in Mailgun.

I’ve managed to do just one or the other - sending only the google drive files, or only the airtable attachment. The issue seems to be combining them together in one array, to send to Mailgun.

below is the current test scenario, which does not work. The biggest issue I’m facing is that the object output of Google Drive download, vs the Http Get File download do not match, hence I cannot easily aggregate them together. Also, I would need to ideally aggregate both the data of the file, and also it’s filename so these are used to be sent to Mailgun.

image
image1387×689 86 KB

Attached you can find the blueprint, if it helps.
blueprint.json (114.9 KB)

Any advice would be greatly appreciated!

Regards,
Karl

2

Welcome to the Make community!

This seems like a complex scenario you’re trying to make, perhaps exporting the blueprint might help others replicate the issue to be able to answer your question.

At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (119.3 KB)

2 Likes
3

Hi. Sure, I’ve uploaded the blueprint on the original post. Thanks

2 Likes