Skip to main content

I have a custom workflow:
Step 1 - When a new email is received in Inbox with a specific subject + attachments the trigger Gmail - New Attachment runs.

Step 2 - Airtable action - Find record is searching for record in my base by Email.

Step 3 - Zap splits into 2 paths.

Step 4 - Path #1 if record exists in Airtable.
Step 5 - Google Drive action - Find folder.

Step 6 - Google Drive action - Create folder (a new folder creates inside folder from Step 5).

Step 7 - Google Drive action - Upload file (upload attachment from step 1).
Step 8 - Airtable action - Create record (creates record with a link to folder where attachment was uploaded)

So if I have more than 1 attachment as many new records are created in my database as there were attachments in the email. 

I need all attachments from one email to be saved separately not zip file in one folder on Google Drive and I can create 1 record in my Airtable base with one link to this folder.

How can I make that? 

Thank you!

Hi ​@Yurii Horulko 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

Make sure to map a variable that has “Attachment” singular.


Is it ok?


Airtable action


@Yurii Horulko 

If you only want 1 record created per GDrive Folder, then use this Zap action:

Airtable - Find Record

Check the checkbox to create record if not found

So the step becomes: Airtable - Find/Create Record


Those records are not the same. Find Record searches in Client table. Create Record creates new record in Submission table.


@Yurii Horulko 

Can you clarify the issue you are having with your Zap step config?

Outline a specific example.


I received email with 3 attachments. I built zap. You could see the screenshot above. When the automation finished I got 3 records instead of 1.


Screenshot


I can’t add the screenshot


@Yurii Horulko 

If you only want 1 Submission record then follow this suggestion...

 

NOTE: Add a Delay (After Queue) step to make sure only 1 Zap runs at a time.
https://zapier.com/apps/delay/help

 

If you only want 1 record created per GDrive Folder, then use this Zap action:

Airtable - Find Record

Check the checkbox to create record if not found

So the step becomes: Airtable - Find/Create Record


Hi there, ​@Yurii Horulko👋

Did Troy’s latest suggestion help to get things sorted here?

Want to make sure you’re all set, so let us know how things are going! 🙏