Join Makerpad today

Makerpad is home to over 9,000 folks. Access members-only content, build real projects & get expert support
Tutorials
/
πŸ”— Save Gmail attachments to Google Drive + Airtable

πŸ”— 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 folks. Access members-only content, build real projects & get expert support

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