How do I add multiple attachments from Google Drive to a MS Outlook email?

Hi ​@tobias.gould1 

Help links for using files in Zaps: https://help.zapier.com/hc/en-us/articles/8496288813453-Send-files-in-Zaps

Loops run in parallel unless programmed to run sequentially.

How to do sequential looping: 

You probably need to use one of these options:

• Storage
  • Add values to a Storage Key, then the key after the last loop
  • https://zapier.com/apps/storage/integrations#help
• Digest
  • Add values to a Digest, then find Digest and release digest after the last loop
  • Help: https://zapier.com/apps/digest/integrations#help
• Zapier Tables
  • Add records to a Zapier Table, then find matching records after the last loop
  • Help: https://zapier.com/apps/zapier-tables/integrations#help

For us to have true context, post screenshots showing how your Zap steps are outlined in order and configured in the CONFIGURE tab while in EDIT mode.

Thanks for getting back to me so quickly - these are the breakdowns of the steps I am currently using - do i just need to change it to a sequential loop? Thanks

​@tobias.gould1 

If you already have the file IDs in the GSheet, then you probably want to use a different approach that does not involve looping with the GDrive Find File step.

Instead, add this as Zap step 3.

Zap action: Formatter > Text > Default Value

See screenshots below for how to configure.

Then map the output of the Formatter Step 3 to the Outlook Send Email Attachments field.

GDrive File direct download link format: https://drive.google.com/uc?export=download&id=XXX

Replace XXX with the GDrive File ID.

Make sure the GDrive Files are publicly accessible.

Utility to use to get the direct download link format for a GDrive file: https://sites.google.com/site/gdocs2direct/

Help links for different GDrive File link formats: 

###

As an alternative approach, try using this Zap action: GDrive - Retrieve Files from GDrive

Ask ChatGPT to help you with the Custom Query syntax.

###

For context related to your original Zap step design approach…

If you are trying to get a list of GDrive files to send as email attachments, then you need to aggregate those found GDrive Files and find the array of aggregated files before mapping the files to be email attachments.

You probably need to use one of these options:

• Storage
  • Add values to a Storage Key, then the key after the last loop
  • https://zapier.com/apps/storage/integrations#help
• Digest
  • Add values to a Digest, then find Digest and release digest after the last loop
  • Help: https://zapier.com/apps/digest/integrations#help
• Zapier Tables
  • Add records to a Zapier Table, then find matching records after the last loop
  • Help: https://zapier.com/apps/zapier-tables/integrations#help

Thank you - sorry if I am being silly but after I have created the https://drive.google.com/uc?export=download&id=XXX links - can I put the output of that straight into an attachment? i did this and it failed to send, then I put them into formatter to convert to line items and then added but that just sent blank attachments.

or do I have do what you are suggesting re storage/digest/tables?

Thanks,

Toby

​@tobias.gould1 

Make sure the GDrive Files are publicly accessible direct download links.

We would need to see updated screenshots with how your Zap steps are outlined and configured.

Ah so this has sensitive info so im unable to do this - can I just edit so its only visible if download links only?

​@tobias.gould1 

You can redact sensitive info (variable values) and still show us how the Zap steps are outlined and configured.

Thank you Troy - I spent countless hours on ChatGPT trying to resolve this, which was completely useless, you have saved me a lot of time! Appreciate your help