Copy all emails from a timeframe to Google Sheets, saving all attachments in Google Drive

Managing your email can be a tedious and time-consuming task, especially when you're dealing with a large volume of messages and attachments. This automation is here to simplify the process for you.

With this automation, you can specify a timeframe to find all relevant emails and attachments. It will automatically upload any attachments to Google Drive, providing easy access to files whenever you need them. Additionally, it will save all email information to a Google Sheets document.

Whether you're a busy professional, small business owner, or just looking to streamline your workflow, this automation can help. It's a powerful solution that can help you save time and stay organized. Give it a try and see how it can benefit you.

Let’s set it up!

Step 1: Pin the playbook and integrate Google Sheets and Gmail

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Gmail and Google Sheets.

Click on the playbook card, and the setup flow will start. Bardeen will ask you to specify a Google Sheets spreadsheet for your emails. You can choose an existing sheet or create a new one.

Bardeen will also ask you to specify a Google Drive folder for your email attachments. It will save any attachments to the folder you specify and include the link in the Google Sheets spreadsheet.

Click on “Save Input” and checkmark Google Sheets. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to copy all emails to Google Sheets, saving all attachments in Google Drive

Press Option + B on your keyboard to launch Bardeen. Click on the playbook. Run the playbook when you want to save emails for a specified time frame.

It will find all your emails, get information like subject line, date, link to email, email body and sender, upload all email attachments to Google Drive, and save all the information to your Google Sheets.

You can also edit the playbook and add your next action to further customize the automation.

Find more Google Sheets integrations, Gmail integrations, Google Drive integrations and Google Sheets and Gmail integrations.

You can also find more about tips and tricks to use Google Sheets, how to increase your personal productivity and how to manage the data sourcing and research process.