Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to save Gmail attachments to a Google Drive folder using Airtable

Y

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!

1 Attachments
Did this topic help you find an answer to your question?

10 replies

Troy Tessalone
Forum|alt.badge.img+14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Y

Is it ok?

3 Attachments
Y

Airtable action

1 Attachments
Troy Tessalone
Forum|alt.badge.img+14

​@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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Y

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

Troy Tessalone
Forum|alt.badge.img+14

​@Yurii Horulko 

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

Outline a specific example.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Y

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.

1 Attachments
Y

Screenshot

1 Attachments
Y

I can’t add the screenshot

Troy Tessalone
Forum|alt.badge.img+14

​@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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions