Join Makerpad today

Makerpad is home to over 9,000 thousands folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in ๐Ÿ˜- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
Tutorials
/
๐Ÿ”— Save Gmail attachments to Google Drive + Airtable
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as complete

๐Ÿ”— Save Gmail attachments to Google Drive + Airtable

Link to Demo

In this tutorial you'll learn how to create a simple automation that will monitor your Gmail inbox and save any incoming attachments into a Google Drive folder then Create a Record containing a Direct Download link in Airtable.

What you'll need

  • 1 x Gmail Account
  • 1 x Integromat Account
  • 1 x Airtable Account + new base
  • 1 x Google Drive

You must be a member to view the full lesson

Join Makerpad today

Makerpad is home to over 9,000 thousands folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in ๐Ÿ˜- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Before starting this first step, create a blank Airtable base with the following headers.

  • Email Subject
  • Date
  • File Name
  • Attachments

Now, create a new scenario in Integromat with Gmail, Google Drive and Airtable as the services.

Select Gmail as the first module with Watch emails as the trigger. Select the Folder you want it to watch, select simple filter and All Emails. Click ok then on the next screen choose From Now On.

Next from the Tools button, select an Interator module as the next step. Open it and in the Array field, map the Attachments variable from the Gmail module.

Once done, add Google Drive as the next step with Upload File as the action. Configure the settings to save the file where you want it. Click ok.

โ€

Next, add a new module and select Airtable. Choose Create a Record as the Action.

Configure your Airtable account (you may need to grab your API key from https://airtable.com/account if this is the first time connecting to Integromat).

Select your base. Select your table. Now maps the following variables to the corresponding fields.

  1. Email Subject (1. Subject from Gmail)
  2. Date (1. Date from Gmail)
  3. File Name (2. File name from the Iterator)
  4. Attachments ( 3. Direct download link from Google Drive)

Once you've done that, test it by clicking Run once if you have emails with attachments in the current targeted folder or by putting it live and sending yourself an email.

That's it! Once set live then you will never have to worry about losing email attachments ever again.

Hope this proves useful and make sure you message if you have an issues setting this up.

Bonus - why not add on a notification or alert onto the end of this flow to let you or your team know that the attachments have been saved? Slack or twilio maybe?

Tom Osman - Makerpad

@tomosman

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.

Ready to get started?

Join the community and start turning your ideas into solutions