Before starting this first step, create a blank Airtable base with the following headers.
- Email Subject
- File Name
Tutorial on how to upload multiple files attachments or photos automatically to Airtable from your Google Drive using Integromat. Test a free plan here:https. Airtable helps finance teams streamline data, accelerate workflows, and makes reporting easy. Manage your most important finance workflows. Whether you’re managing budgets or invoicing, you can do it in Airtable. Get started with pre-made templates,.
Before you'll be able to create new bases from Google Drive or sync Airtable to Google Drive, you'll need to connect Airtable to Google Drive. From Google Drive, click on the My Drive menu, then the More option, then select the option Connect more apps. Search for Airtable, then click the blue Connect. Google’s powerful search capabilities are embedded in Drive and offer unmatched speed, performance, and reliability. And features like Priority use AI to predict what you’re looking for and surface. Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.
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.
- Email Subject (1. Subject from Gmail)
- Date (1. Date from Gmail)
- File Name (2. File name from the Iterator)
- 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?
Air Table Google Drive Free
Tom Osman - Makerpad