Google Mail
Google Drive
Google Sheets
Workflow Template

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

This Playbook will find all emails from your specified timeframe, upload any attachments to Google Drive and save all the information to Google Sheets.
Bardeen automates your repetitive tasks without code.
Install the Chrome extension for free.
Find emails
Action
Upload file to Google Drive
Action
Add data to sheet
Action
Add data to sheet
Action

How does this automation work?

Bardeen's Playbook is designed to optimize your email management and data organization by automatically copying emails from a selected timeframe into Google Sheets and saving all attachments in Google Drive. In today's data-driven environment, having easy access to your important correspondence and documents is vital for personal productivity and efficient data sourcing research. This automation saves time and ensures that your information is systematically organized and easily retrievable for future reference.

Here's how this workflow operates to optimize your email management:

  • Step 1: Find emails within timeframe - Bardeen searches your Gmail for all emails within the specified dates. This step is pivotal for targeting the exact range of correspondence you need.
  • Step 2: Save attachments to Google Drive - Any attachments found in these emails are then uploaded to a specified folder in Google Drive, ensuring that your documents are safely stored and organized.
  • Step 3: Record email data in Google Sheets - The details of the emails, including subject lines and other relevant data, are added to a Google Sheet of your choosing. This creates a structured overview of your correspondence.
Run this Google Drive automation with Bardeen in minutes.

How to run the workflow

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.

Run this Google Drive automation with Bardeen in minutes.

Available actions & triggers

Apps:
Copy all emails from a timeframe to Google Sheets, saving all attachments in Google Drive
Copy all emails from a timeframe to Google Sheets, saving all attachments in Google Drive
Copy all emails from a timeframe to Google Sheets, saving all attachments in Google Drive
Types:
Both
Actions
Triggers
Add text to Google Sheet
Add text to Google Sheet
Action
When row changes
When row changes
Trigger
When email received
When email received
Trigger
When row is added to Google Sheet
When row is added to Google Sheet
Trigger
Create new spreadsheet tab
Create new spreadsheet tab
Action
Find email thread from current page
Find email thread from current page
Action
Forward email
Forward email
Action
Share Google Drive file
Share Google Drive file
Action
Update or add rows in/to a tab
Update or add rows in/to a tab
Action
When email is received
When email is received
Trigger
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use

FAQs

Bardeen - Playbook / Autobooks: Is it possible to create a Playbook that scrapes data from a website and sends it as an email attachment?

You can create a Bardeen Playbook to scrape data from a website and then send that data as an email attachment.

Youtube: Can I download a Youtube video to my computer using Bardeen?

Unfortunately, Bardeen is not able to download videos to your computer.

Google Sheets: What is the best way to export data to Google Sheets?

Exporting data (ex: scraped data or app data) from Bardeen to Google Sheets is possible with our action to “Add Rows to Google Sheets”.

Meetings: Is there a playbook to record and summarize meetings?

There isn't a specific AI use case available for automatically recording and summarizing meetings at the moment

Playbooks/Autobooks: How do I edit an action in a Playbook or Autobook?

Please follow the following steps to edit an action in a Playbook or Autobook.

Scraper: How can I get data from multiple sections of a profile (Eg: getting the experience section on a linkedin profile)?

Cases like this require you to scrape the links to the sections and use the background scraper to get details from every section.

By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.